Users Logged in at a given time - (Customer Facing and Technician Backend)

[Leon Els]

We experienced a ServiceNow outage a couple days ago and I would like to go back in time to see how many customers and Technicians were logged in at that time.

Is there any log I can access to view this data?

Thank you!

Leon

[Harshal Aditya]

Hi @Leon Els ,

Hope you are doing well.

In the sys_user table we have fields like last login and last login time. Using these two fields you can find out if the users were logged in during outage.

Please mark this response as correct or helpful if it assisted you with your question.

Regards,
Harshal

[Leon Els]

Thank you @Harshal Aditya , close, but not exactly what I needed.
It appears that this only provides data for the last time the user logged in, there is no history.

[Riya Verma]

Hi @Leon Els ,

Hope you are doing great.

ServiceNow keeps track of various logs that can provide insights into system activities, including user login information.

1. Access System Logs:

   • Navigate to System Logs > All and filter the logs based on the outage timeframe to focus on the relevant period.
   • Look for log entries related to user login activities, such as "LOGIN", "LOGOUT", or any other relevant log entries that indicate user sessions.

2. Analyze Log Entries:

   • Look for entries that capture login events for both customers and technicians.
   • Note the timestamps, user IDs, and any additional details that can help determine the number of customers and technicians logged in.

3. Extract Relevant Information:

   • You can create a script or use tools like Excel or text processing utilities to filter and aggregate the relevant data from the log entries.
   • Extract the user IDs and count the distinct users to determine the number of customers and technicians logged in.

4. Consider Additional Sources:

   • In addition to the system logs, you may also explore other sources of information, such as performance analytics or reporting data, to gather insights about user activities during the outage.
   • These sources can provide metrics and statistics on user logins and usage patterns that can complement the information obtained from the system logs.

[Leon Els]

Hi @Riya Verma , thank you for your help!
We are on Tokyo, below is what I see:
I did browse around in this area, but could not find what I need.

Thank you in advance!