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!
Answer Chosen by the Author
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