GOAL: My goal is to be able to scan for a service like MSSQLServer and get a report back on all servers running that service.
I created a DCI table (Services) and applied it to all server nodes. I would like to run a DCI summary table or a Dashboard to scan for a certain service running across all servers in my environment.
I thought a DCI Table for services would collect all services running. Next would be a DCI Summary Table or Dashboard to run across the whole Infrastructure Services. Then I can take that info and make sure the proper templates are being applied.
What would be the best way to accomplish this? Any ideas would be awesome.
Thanks Guys!
Hi,
so ultimately you only need some mark that MS SQL is running on node to be able to apply templates? Then it could be accomplished much easier using configuration poll hook:
1. Create script in script library named Hook::ConfigurationPoll like this:
if ($node->isAgent)
{
state = AgentReadParameter($node, "System.ServiceState(mssqlserver)");
if (state == 0)
{
SetCustomAttribute($node, "sqlServer", "true");
}
}
it will set custom attribute sqlServer to true if service is running. Please note that service name might be different, I cannot remember correct name for SQL Server service.
2. To auto apply templates, use the following auto-apply filter script:
return GetCustomAttribute($node, "sqlServer") == "true";
Best regards,
Victor
This worked great thanks Victor. :)
Cheers!