Here is a report we use to track servers that are running on an OS that is on the End of Life (EOL) list. The report uses several different data sets to break things up into groups. The same list can be used as an inventory report by OS.
If there are any questions, or suggestions to improve, please reach out.
I Love the report, you made need to update it for custom properties that you use, or add the missing ones (and use them)
I think I need more coffee, I was trying to say that for people who upload it, they will need to alter the report or add the properties
Thanks for the call out @jm_sysadmin. I too was without my morning cup before posting this.
Ohhhh nice. I am on a project to cut down and clean up our Domain Controller sprawl and was looking for some kind of report to figure out what is what with all of them. I can use this as a starting point and adjust from there. Thanks!!!
Hit me up if I can be of any help @martian_monster !
Hello @the_ben_keen ,
The attached report wasn't quite what I needed, but I am going to use this report. Thank you!I took the information @KMSigma.SWI gave me and applied that logic to a SWQL query and applied it to a custom query that gives me a device count per OS and I have a link there that points to a Group, which shows all the devices for that OS. That took the most time to do.
Glad you were able to get what you needed @s-bolyard !
What if I only want to run a report against a small list of servers? Is there a way to make a query group "on the fly" with a list of server names?
Yes, one method is in swql with a "where caption IN ('abc','def')" clause , alternatively, you can wildcard it "where caption like '%bc' or caption like '%ef'" Custom properties or node groups can make this much easier to do. THe web reporting has similar capability. You can sort nodes by using caption contains def or make an or list of caption equals abc or caption equals def etc. Again - custom properties or node groups can help isolate. If you know the operating system, you can sort on machinetype in the nodes entity too. I dont have the chance to upload or modify the report sample in the thread, so I am just pointing out a few options right now.
Yes, thanks that does work!! I was hoping I could make a dynamic group each time and only run the report against a group. I am not sure that is even an option. But let's say we have 5000 servers and I only want to check 100 of them. Do you think that editing the report each time is the best way to get that? I am open to suggestions :-)
I assume you copy this report to the C:\Program Files (x86)\SolarWinds\Orion\Reports folder corrent?
As I cant see it in my All Reports list?
Any help appreciated
That is the method for the legacy Report Writer application.
For the new reporting engine, navigate to Reports > Manage Reports and select Import
Attach the file and import and you should then see the report in the listing
