we have a few credentials that we use and seeing if there is an actual report other than using a sql query please to list each node monitored and credentials applied to each node?
sum_giais posted you can easily make it into a widget on a page as long as you are an admin on the system.
Click the pencil in the upper left corner
In the upper right corner click Add Widgets
Type Custom into the search bar and select Custom Query
Drag that onto your dashboard
Click Done Adding Widgets
Then Click Done Editing
Scroll down to wherever you placed your new widget and click Edit
Paste in the SWQL Query and hit Submit
The query results will now show up in the widget
I had to create a custom sql query when I wanted this information for WMI credentials. I couldn't find an out-of-the-box report.
I know you're looking for something that's not a SQL query but I'll just put these right here...
I haven't looked at these for some time but they may be able to be converted to SWQL query at this point which if possible, could be added to a report or dashboard from there.
https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/3018
https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/custom-queries/3019
Thank you, I'll check them out.
So I couldn't help myself... I updated both of those custom queries to SWQL on thwack, accessible at the same links I provided above. Really didn't take too much to do it, but you could take either of those SWQL queries and build it into a modern dashboard, custom report datasource etc. etc.
I didn't include the fancy pieces like n.DetailsUrl AS [_LinkFor_Caption] and/or status info and icons but this is the start!
Cheers.
Thank you so much for this.
