Show how many users are logged into SolarWinds

Great insight.

Voted

Curtesy of mesverrum: https://thwack.solarwinds.com/thread/115288

Try this SWQL in a custom query;

     SELECT tolocal(TimeLoggedUtc) AS [Last Login]

     ,AccountID

     ,AuditEventMessage

     FROM Orion.AuditingEvents AS AE

     WHERE daydiff(timeloggedutc ,getutcdate())<31

     AND AE.AuditingActionType.ActionType = 'Orion.UserLogin'

     ORDER BY TimeLoggedUtc

Here is a similar report that shows the last time users have logged in

--SWQL

--Shows last login for all users 

SELECT TOP 1000 AccountID, Enabled, AllowNodeManagement, AllowMapManagement, AllowAdmin, CanClearEvents, AllowReportManagement, AllowAlertManagement, AllowCustomize, AllowUnmanage, AllowDisableAction, AllowDisableAlert, AllowDisableAllActions, AlertSound, MenuName, HomePageViewID, DefaultNetObjectID, DisableSessionTimeout, ReportFolder, AlertCategory, Expires, LastLogin, LimitationID1, LimitationID2, LimitationID3, AccountSID, AccountType, AllowViewCopCheck, DisplayName, Description, InstanceType, Uri, InstanceSiteId

FROM Orion.Accounts

WHERE Enabled LIKE 'Y'

Order by LastLogin DESC

Bump and shameless plug -

The reason for this plug is that if we had the user session timeout event, added to the AuditingEvent table, then we be able to work out who is actually online.

Without it we can only know when they last logged on not if they are still online.