Report computers running a service.
You'll have to fogive me, my SQL skills are rusty at best. In light of the heartbleed vulnerability, we're working on a report that will show us which machines in our environment have a specific service running. Does anyone have a prebuilt report that they're using for this? Any help is greatly appreciated. Thanks!
Answers (3)
you can use the wizard to create this. And put the name of the service in the filter as equals
Comments:
-
My apologies, I read right over it. Thanks! - GeekSoldier 10 years ago
You shouldn't need a SQL statement, really. The report wizard has a "Computer Services" topic that contains all of the service info which you can filter and sort on, including computer names which have that service. You can even add Computer as a subtopic to get things like IP address, etc.
Comments:
-
My apologies, I read right over it. Thanks! - GeekSoldier 10 years ago
Top Answer
find out the name of the service you want to filter on, I am using appmgmt for this answer.
use this in the wizard:
on page 2 choose product version and service name or service display name under service information and system name under computer.
skip past page 3 and page 4 go to the filter page:
on the filters page under computer services click on the rules to filter button and find service name or service display name (which ever one you checked on page 2), make sure the operator is the = sign and under value put in the name you are searching for. save the filter and then save the query on that page.
the report will look something thing like
Comments:
-
Thanks, I needed to see what was currently running IIS since documentation is always perfect :) - GeekSoldier 10 years ago
