1 Reply Latest reply on Sep 25, 2018 10:51 AM by mr.e

    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!!! 

        • Re: Looking for report on IPAM accounts with rights
          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.