I am trying to create a report of all of our database servers that have an application template applied to them, AND to show the servers that have NO template applied to them.
I only have 3 basic templates that get applied to DB servers.
1. SQL Browser - this is an out of the box template and gets auto applied when the server is tagged as "SQL" in the custom properties.
2. <servername SQL> - this template monitors all SQL Agents and Instances (services) on each server. Since our instances naming schema is unique, each server has its own template.
***FEATURE REQUEST: allow adding windows services in templates with variables instead of exact service names.***
3. <servername Oracle> - same as the SQL template. Only monitors production oracle windows services.
I am able to filter out any of these using report filters. However, since services variables are NOT allowed in the template, creating/adding these templates is a manual process. I have to have some kind of audit to know which server in SAM have templates and which dont.
When I create my report, it will only show me server that have app templates assigned.
It seems simple enough using these rules.
Report on: Application
Where > ServerType is equal to "Database Server" < ServerType is a custom property i assign
AND
Name does not contain "SQL" <SQL is what I include in the template name when I know they are SQL servers.
AND
Name does not contain "Oracle" <Oracle is what I include in the template name when I know they are Oracle server.
AND
Name is "Empty" <I am assuming this means if the server has NO templates assigned?
The results dont give anything though. If I remove the "Name is Empty" i get all of my servers, with all of their app templates.
If I remove SQL I get all of the Oracle
If I remove Oracle, I get all of the SQL.
How can I show the servers in SW that do not have any templates assigned though?
I have even tried just filtering on the ServerType to show EVERYTHING, but it only shows app templates that are currently assigned. The servers that have NONE, are not shown...
Im guessing this is failing because SW only monitors what IS applied, not what ISNT applied? Any tricks to get around this?
