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

Create Group Based on Installed Software

Hello Everyone,

I am attempting to group my environment and one of the first items that came up is grouping SQL Servers together. I am using the below SWQL to find all the servers in my environment that have SQL Management studio installed but the create Group section seems somewhat inflexible (I was hoping I could put custom queries in there).

select distinct n.Caption
,n.AssetInventory.Software.Name
from orion.Nodes n
where n.AssetInventory.Software.Name is not null
and (n.AssetInventory.Software.name like '%SQL%' AND n.AssetInventory.Software.name like '%Management Studio' )
Order by n.caption

The End goal is to create groups and then assign those groups to Templates. In this case a base template that monitors a few SQL Services on those boxes. My hope is to have this dynamic query find whenever someone installs SQL on a machine and automatically start watching it rather than having to define it through a custom property that people don't keep up on.

Barring that as a direct solution is there a way to schedule tasks to find this query and set a flag on a custom property inside of Solarwinds instead of an external tool? I want to keep the solution as "In the box" as possible for future growth and sustainability.

Find more posts tagged with

Accepted answers

shuth

You would probably need to run a scheduled script against the API or an alert using that query that then updates a custom property value.
The group is then populated with a dynamic query against that custom property.
e.g. script runs each night and if it detects SQL installed, updates a custom property (SQL_Installed = True, or ApplicationRole = 'SQL', whatever). Your dynamic query looks for SQL_Installed = True and will move that node into the group automatically. If you have the SAM templates assigned to the group, the application monitor should also apply. You may run into permission issues with things like AppInsight depending on how you have it configured.

All comments

hansolo

You can go into manage groups and create a new group called SQL. Then make a dynamic query like this:

This is an example and not SQL but you get the point. It will automatically add any new device running a SQL product and update that group with the new member.

SirSquatch80

Thanks HanSolo but the primary part I was looking for isn't in your post (or I missed it). That is the part where I actually create the dynamic request with specific software installed.It seems to only allow a certain number custom fields or generic info but not the software level or the ability to create a group based on a SWQL query.

shuth

hansolo

"My hope is to have this dynamic query find whenever someone installs SQL on a machine and automatically start watching it rather than having to define it through a custom property that people don't keep up on."

So I am guessing I am missing what you are asking. I have a group created on a dynamic query %SQL% and it does pull in any new SQL machine into that group after a poll is done as long as the server is already being monitored. Maybe that is the part I am missing in your question.

Hope you find your answer.