Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

How do I create a report that will show all nodes assigned to an application template?

I want to do just that, create a report that will show all the nodes that are assigned to a specific application template. Any help would be great, I just cannot figure it out.

Thanks,

Alex

Find more posts tagged with

Accepted answers

All comments

monitoringlife

If you just need to spot check you can see it from SAM setting and looking at the 'assigned to' field, which can display all the nodes.

A quick query can display them as well (just replace with the desired application name).

SELECT NodeName, N.Applications.DisplayName
FROM Orion.Nodes N
WHERE N.Applications.DisplayName like '%Application%'

aphillips

Thanks, I will try the query. I'm aware of the display in SAM settings, but was hoping for a way to export the list to an excel sheet or something.

adam.beedell

If you remove the WHERE and GROUP BY the application name in the query above you basically get what you want I think.

Technically to reference the template you're probably joining to another table, but it'll report the same unless people are messing with names a bunch.

If you've not used queries much you can export them to excel

bobmarley

You can modify the above query and it will show all applications

SELECT NodeName, N.Applications.DisplayName
FROM Orion.Nodes N
--WHERE N.Applications.DisplayName like '%Application%'
Where N.Applications.DisplayName IS NOT NULL
Order by DisplayName ASC