SolarWinds Orion is great at collecting information but kinda not so great at presenting that data in a cohesive way; however, it stores all of that data in SQL. This is GREAT! We can leverage that to create powerful reports. I thought I would share a SQL Query to present this data well. The attached example shows the installation status of McAfee across the enterprise you are monitoring. Preparing SolarWids Have scheduled tasks that scan VLANs to find new devices Enable Asset Inventory collection on all Nodes Linux can do this with SNMP Windows will do this with WMI Update Node polling to something more reasonable than 1 hour, unless thats your requirements You have all of the data you need, NOW do something with it! My example is used to determine the status of McAfee Agent, VSE, and MOVE deployment across the enterprise. This is a great way to validate McAfee deployment versus just using the ePO console. The goal is to use this as an example and alter it for your own requirements. Deployment Download the attached docuemnt McAfee_Installation_Report.OrionReport Copy the document to a location that is accessible by your SolarWinds server Log into your SolarWinds server Open Orion Report Write Select Open Select Execute SQL Query button You should see values populate the Lower Window In the broader Orion Report Write Window, Select Save Open SolarWinds Website Goto a View (You will want to create a new tab or column) Select Customize Page Select Add Tab or Add New Column Within the new Column, select the + symbol In the Search all resources, type report and select Search Check the box next to Report from Orion Report Writer Select A dd Selected Resources button Select Done in the Customize view page Select Configure this resource in the newly added Report from Orion Report Writer section In the Select a Report drop down menu, select McAfee Installation Report Select Submit button You will not see a better formatted view of the data from Step 6.1 This data will update in real time as SolarWinds polls the enterprise, you may uncover servers or workstations that do not have the software installed. Following installation of the software and a poll of SolarWinds, the report will be updated. Overall, this is very straight forward but I wanted to share these steps in the hopes that others that may wonder if SolarWinds can do more for them will know that it can or to help those who are trying to figure out something similar. Screen shot of the SQL Query If you have any questions, please let me know.

This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Software Installation Report (using McAfee VSE Example)

serco.paul over 7 years ago

SolarWinds Orion is great at collecting information but kinda not so great at presenting that data in a cohesive way; however, it stores all of that data in SQL. This is GREAT! We can leverage that to create powerful reports. I thought I would share a SQL Query to present this data well. The attached example shows the installation status of McAfee across the enterprise you are monitoring.

Preparing SolarWids

Have scheduled tasks that scan VLANs to find new devices
Enable Asset Inventory collection on all Nodes
- Linux can do this with SNMP
- Windows will do this with WMI
Update Node polling to something more reasonable than 1 hour, unless thats your requirements
You have all of the data you need, NOW do something with it!

My example is used to determine the status of McAfee Agent, VSE, and MOVE deployment across the enterprise. This is a great way to validate McAfee deployment versus just using the ePO console. The goal is to use this as an example and alter it for your own requirements.

Deployment

Download the attached docuemnt McAfee_Installation_Report.OrionReport
Copy the document to a location that is accessible by your SolarWinds server
Log into your SolarWinds server
Open Orion Report Write
Select Open
Select Execute SQL Query button
1. You should see values populate the Lower Window
In the broader Orion Report Write Window, Select Save
Open SolarWinds Website
Goto a View (You will want to create a new tab or column)
Select Customize Page
Select Add Tab or Add New Column
Within the new Column, select the + symbol
In the Search all resources, type report and select Search
Check the box next to Report from Orion Report Writer
Select Add Selected Resources button
Select Done in the Customize view page
Select Configure this resource in the newly added Report from Orion Report Writer section
In the Select a Report drop down menu, select McAfee Installation Report
Select Submit button
You will not see a better formatted view of the data from Step 6.1
1. This data will update in real time as SolarWinds polls the enterprise, you may uncover servers or workstations that do not have the software installed. Following installation of the software and a poll of SolarWinds, the report will be updated.

Overall, this is very straight forward but I wanted to share these steps in the hopes that others that may wonder if SolarWinds can do more for them will know that it can or to help those who are trying to figure out something similar.

Screen shot of the SQL Query

If you have any questions, please let me know.

McAfee_Installation_Report.OrionReport