Export group, individual account permissions/settings

acchong

Are there any easy way to export list of permission and module that groups and individual have on our SolarWinds?

We need to have these permissions exported regularly for access review.

bobmarley

This is the SWQL table that has some of the info. I don't see some of the SAM stuff in there but it is a start.

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, GroupInfo, GroupPriority, AllowViewCopCheck, DisplayName, Description, InstanceType, Uri, InstanceSiteId
FROM Orion.Accounts

--Where AllowAdmin LIKE 'Y' AND Enabled LIKE 'Y' 

Order By AccountID DESC