I am looking for a report that will show the NCM user role assigned to each SolarWinds user account. i think it may need to be a custom SQL report, but cannot be sure what table holds the information. Can anyone help please? Thanks so much.
Custom SQL will more or less look like this:
SELECT DISTINCT
[AccountID]
,[SettingName]
,[SettingValue]
FROM [WebUserSettings]
WHERE [SettingName] = 'NCM.NCMAccountRole'
just my 2 cents.
Anyone please?
Fingers drumming on the table.......
No one?
Try opening SDK and using this Query. It will generate the list of all Orion account ID's and their status and permissions.
SELECT 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
FROM Orion.Accounts
Beyond that, I don't have a resource to pull only that data out in a pretty view, but you might find what you want (manually) by going to Admin > Accounts > Manage Accounts and reviewing the data there:
Example:
You can also open each account up and see if you can find an NCM or Role entry--I could not, and I'm an NCM admin.
Another option might be to go to Admin > Settings > NCM Settings and reviewing the sections to see if you can find what you need intuitively:
Finally, review this link and see if it offers what you need on a per-user basis:
SolarWinds NCM roles - SolarWinds Worldwide, LLC. Help and Support
Troubleshooting NCM user roles can be done here:
Your Orion account (with NCM role 'None') cannot access NCM pages. Contact your Administrator to change your NCM role - …
Here's hoping at least one of these will serve your needs!
Rick Schroeder
Perfect!! That is exactly what I was after. Thanks.
Nice work! Thank you for sharing.
