Looking for report on IPAM accounts with rights

mr.e

I need to provide a report of all our SolarWinds users (over 300 of them), listing their respective rights within IPAM.  However, I cannot find an out-of-the-box report nor can find any useful tables in the database.  So, if any of you have run into the same or similar issue -- and found a solution -- I would very much like to hear from you.  Thanks!!! 

mr.e

I called SW tech support and they helped me find the answer.  Here is a SQL query that will show the IPAM users and user groups, along with their respective rights.

SELECT * FROM [dbo].[WebUserSettings]

Where SettingName LIKE '%IPAM%'  AND

(SettingValue = 'ReadOnly' OR

SettingValue = 'Operator' OR

SettingValue = 'PowerUser' OR

SettingValue = 'SiteAdmin')

ORDER BY  AccountID ASC

Before I forget... Kudos to SW tech support for helping me find the answer.