I'm trying to generate a automated report from SolarWinds Report Manager or from Report Writer for all accounts in SolarWinds and their respective administrative privileges.
I don't really see any option available in Report Manager nor Report Writer.
I managed to use 1 of the column in DB to differentiate between AD Individual account and Group Account.
Individual Account --> WHERE [SolarWindsOrion].[dbo].[Accounts].GroupPriority = 0
AD Group Account --> WHERE [SolarWindsOrion].[dbo].[Accounts].GroupPriority != 0
I also noticed that AD Group that was added, SolarWinds will expand all the user accounts (in the AD Group) out in the DB table. Is there a way to filter out all the respective groups instead of individual accounts?
If you want to pick those details from Report Writer then go with a 'Advanced SQL' Report , account details that you are looking for would be under 'Accounts' table on the DB.
SELECT * FROM Accounts this would give you all fields available on the table(probably 50+ fields), but then pick only the fields that you require for your report
Hope it helps
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.