• Report of Listing of users along with their access roles/rights.

Hi everyone i want to generate a report regarding the users roles/rights but i found some of the variable while generating report.

Can anybody share his/her response whether this is possible or not in SolarWinds .

Report of Listing of users along with their access roles/rights , which cover at least the following fields:-

i User ID

ii User Name

iii Account Status

iv Creation Date

v Last Password Change

vi User account created by

vii User account Authorized by

viii Rights last updated date

ix Rights last updated by

Regards & Thanks

Find more posts tagged with

Accepted answers

All comments

vinay.by

List of users and roles where ? Do you mean SolarWinds users or ?

bobmarley

Active Directory?

Arwen

Hi Vinay & Bob

we want the following report of SolarWinds Local users that we create in SolarWinds

bobmarley

Here is the SWQL Table for accounts. You can create a custom SWQL report and remove any values that you do not need

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

holbms

Ran into allot of issues trying to get Password age on SW local accounts. Basically SolarWinds does not record dates on Password changes. There are several Compliance reports I have to do annually and run into these issues on Accounts. Best Advice is get rid of SW local accounts and use only LDAP and let AD do the account reports especially if needed for compliance reasons.