Open for Voting
over 2 years ago

Show how many users are logged into SolarWinds

There are times I would like to know how many users or if a specific user is logged into SolarWinds. I would like to see a feature that would allow me to do this.

  • 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.