How can I create a report containing a list of users logging in and out?

0 Likes

Problem:

How can I create a report containing a list of users logging in and out?

Resolution:

ANSWER
----------------------------------
There is a standard Audit Log available which shows users logins:

Administration | Reports | Audit Log

It is also possible to create a custom query that will display a full list of users that have logged in / out of the SCIM system, along with associated timestamps.

To create a custom query go to:

  • Administration | Reports | Custom Queries
  • Click "Add New Query"
  • Enter your SQL query

Example queries:

To get a list of all users:

Select UserName, Operation, TimeStamp from SCC_AuditEntrieswhere UserName like "%"order by TimeStamp

To get a list for the user "user1":

Select UserName, Operation, TimeStamp from SCC_AuditEntrieswhere UserName = "user1"order by TimeStamp

You can also replace the user name with a variable (for example #V1#) and add a value for that variable in the custom query screen.

After running the query, the returned list can be downloaded as a csv file.

If you require asistance with this please contact Support.

Old KB# 23737
Comment List
Anonymous
Related Discussions
Recommended