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 Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

0

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

Answered 04/11/2014 by: SMal.tmcc
Red Belt

  • Thanks, I needed to see what was currently running IIS since documentation is always perfect :)
Please log in to comment

Answers

1

you can use the wizard to create this.  And put the name of the service in the filter as equals

Answered 04/11/2014 by: SMal.tmcc
Red Belt

  • My apologies, I read right over it. Thanks!
Please log in to comment
1

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.

Answered 04/11/2014 by: BHC-Austin
Fourth Degree Black Belt

  • My apologies, I read right over it. Thanks!
Please log in to comment
Answer this question or Comment on this question for clarity

Share