|
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
- 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" - The following results will be generated:
| Start | Stop | Username | CameraID |
|---|
| 21/02/2017 9:51:04 AM | | gmattinson | 46 | | 21/02/2017 9:50:54 AM | 21/02/2017 9:51:04 AM | gmattinson | 51 | | 21/02/2017 9:41:13 AM | 21/02/2017 9:41:46 AM | gmattinson | 51 | | 17/02/2017 3:48:51 PM | 17/02/2017 3:49:20 PM | gmattinson | 51 | | 16/02/2017 11:22:31 AM | 16/02/2017 2:46:40 PM | gmattinson | 51 | | 16/02/2017 11:17:41 AM | 16/02/2017 11:20:49 AM | gmattinson | 51 | | 15/02/2017 10:58:30 AM | 15/02/2017 11:20:14 AM | gmattinson | 51 | | 14/02/2017 8:35:17 PM | 14/02/2017 8:35:47 PM | gmattinson | 51 | | 14/02/2017 8:34:51 PM | 14/02/2017 8:35:06 PM | gmattinson | 51 | | 14/02/2017 8:34:47 PM | 14/02/2017 8:35:06 PM | gmattinson | 17 |
|
Average rating:
|
|
|
|
Please log in to rate.
|
|
Rated by 0, Viewed by 2322
|
|