/build/static/layout/Breadcrumb_cap_w.png

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!


0 Comments   [ + ] Show comments

Answers (3)

Answer Summary:
Posted by: SMal.tmcc 10 years ago
Red Belt
1

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
Posted by: BHC-Austin 10 years ago
4th Degree Black Belt
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.


Comments:
  • My apologies, I read right over it. Thanks! - GeekSoldier 10 years ago
Posted by: SMal.tmcc 10 years ago
Red Belt
0

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ