Senstar
Safeguarding people, places and property
Contact       Xnet Login       English
Knowledge Base Article
Article Type: How To
Product: Symphony
Product Version:
Component:
Device Brands:
Created: 21-Feb-2017 11:03:50 AM
Last Updated:

How to generate a list of users who viewed live video

  1. Open a command prompt and enter the following command line:
    dbupdater "select top 10 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:
     
    StartStopUsernameCameraID
    21/02/2017 9:51:04 AM gmattinson46
    21/02/2017 9:50:54 AM21/02/2017 9:51:04 AMgmattinson51
    21/02/2017 9:41:13 AM21/02/2017 9:41:46 AMgmattinson51
    17/02/2017 3:48:51 PM17/02/2017 3:49:20 PMgmattinson51
    16/02/2017 11:22:31 AM16/02/2017 2:46:40 PMgmattinson51
    16/02/2017 11:17:41 AM16/02/2017 11:20:49 AMgmattinson51
    15/02/2017 10:58:30 AM15/02/2017 11:20:14 AMgmattinson51
    14/02/2017 8:35:17 PM14/02/2017 8:35:47 PMgmattinson51
    14/02/2017 8:34:51 PM14/02/2017 8:35:06 PMgmattinson51
    14/02/2017 8:34:47 PM14/02/2017 8:35:06 PMgmattinson17

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