Question. Any way to create a report that shows what each user or group in Solarwinds has access to within SW?

Burner087

Greetings.  I was asked to provide a report that shows what access within SW that each user or each group has access to.  Does anyone know of any native way in SW that this can be done?  Or a query if necessary?

I tried just using the info provided by default on the manage user accounts and manage group accounts.  But that only provides some of the access info that folks would have within SW.

Thanks.

bobmarley

A lot of the info is in the Orion.Accounts table, this can be put directly into a report.

SELECT TOP 1000 AccountID, Enabled, AllowNodeManagement, AllowMapManagement, AllowOrionMapsManagement, AllowUploadImagesToOrionMaps, AllowAdmin, CanClearEvents, AllowReportManagement, AllowAlertManagement, AllowCustomize, AllowManageDashboards, AllowUnmanage, AllowDisableAction, AllowDisableAlert, AllowDisableAllActions, AlertSound, MenuName, HomePageViewID, SummaryViewID, HomePageDashboardID, SummaryDashboardID, DefaultNetObjectID, DisableSessionTimeout, ReportFolder, AlertCategory, Expires, LockoutTime, BadPwdCount, LastLogin, LimitationID1, LimitationID2, LimitationID3, AccountSID, AccountType, GroupInfo, GroupPriority, AllowViewCopCheck, PasswordExpirationDate, DisplayName, Description, InstanceType, Uri, InstanceSiteId
FROM Orion.Accounts