Hi,
I am trying to write a report to gather this information from all of our servers so it doesn't have to be done manually. Is there a predefined template already used or would I need to keep working on building this template?
Much of the data in the top section is collected natively by Orion (assuming you have ticked the 'Asset Inventory' box for your servers.
Therefore, you could put together a report or series of reports to extract this data in a form that you desire.
The following resources will help in putting a report/s together:
https://www.youtube.com/watch?v=c_FMsPRQAKk
https://www.solarwinds.com/resources/video/creating-reports-using-reports-builder
The data for firewall configuration and security controls is not natively captured, however the Orion SCM module provides some of it. There is also a SolarWinds solution called Access Rights Manager, which will certainly provide this information, but that is a big box software solution doing WAY more than just reporting.
Some of my reports use data from tables that are all over the Orion Database. Sometimes the data for something like a Mac-Address for one device is in a different table than for another. (We use a lot of custom SNMP Queries for inventory items) One trick I found is to populate custom property through an alert action for specific devices (Such as when you have three models of UPS's that have three different OID pollers for Mac-Address. ) In this case you would create and alert for each specific OID and match it to the UPS Model.
The SQL portion looks like this:
${N=SWQL;M=SELECT TOP 1 N.Interfaces.PhysicalAddress from orion.Nodes N Where Caption like '${N=SwisEntity;M=Caption}'}
This alert will populate all columns in the _MacAddress custom properties table with the Mac-Address of the device that matches you alert trigger.
In this manner you are using the reporting tool to use a single SWQL table for Custom Properties to gather all of your data instead of writing a bunch of SWQL joins in your report.
That's pretty crafty bob!
