Knowledge Base Article
Article Type: How To
Product: Symphony
Product Version:
Component:
Device Brands:
Created: 17-Mar-2015 9:48:07 AM
Last Updated:

How to Generate a List of User Login and Log Out Times

This article outlines an alternative to accessing user login and log out times, which are also accessible in Senstar Symphony™ via the Help > View Detailed Event Logs menu.

1.       Open a command prompt and enter the following command line:

dbupdater "select top 100 Login.Timestamp as Login, Logout.Timestamp as Logout, Login.V as [User], Computer.V as Computer from Events Login left join Events Logout on Login.EventGroupId=Logout.EventGroupId and Logout.Name='SessionEnded' and logout.k='sessionid' left join Events Computer on Login.EventGroupId = Computer.EventGroupId and Computer.Name='SessionCreated' and Computer.K='HostName' where Login.Name='SessionCreated' and Login.K='Username' order by Login.Timestamp desc"

2.       The following results will be generated:

LoginLogoutUserComputer
3/16/2015 8:38:56 AM adminJAX-PC
3/13/2015 1:19:24 PM 3/13/2015 1:33:12 PMadminJAX-PC
3/13/2015 8:54:00 AM3/13/2015 9:27:35 AM adminJAX-PC
3/13/2015 8:52:51 AM3/13/2015 8:54:00 AMbobJAX-PC
3/13/2015 8:52:29 AM3/13/2015 8:52:51 AMadminJAX-PC

Average rating:
Please log in to rate.
Rated by 0, Viewed by 1405