• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1743
  • Last Modified:

SCCM 2007 query to identify which servers are running microsoft smtp

I am looking for an SCCM query that will display all the servers in my organization that are running microsoft smtp services.

If someone would be so kind as to provide an SCCM 2007 query I can use to get that information, it would be much appreciated.  
0
ACECORP
Asked:
ACECORP
  • 2
1 Solution
 
NJComputerNetworksCommented:
Method 1:  you can run the generic report:  "Services - Computers running a specific service"  and pick the "SNMP Service" to show the computer running SNMP.

Method 2:  You can create a custom query and base a collection from the SQL query:

select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.NetbiosName from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name = "SNMP" and SMS_G_System_SERVICE.State = "Running"

0
 
ACECORPAuthor Commented:
Windows SMTP (not SNMP) is a windows service yes?

So I can use the same query with SMTP? I will try that as soon as I get back in the office from the holiday vacation.
0
 
ACECORPAuthor Commented:
It worked with some modifications as shown below.

select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.NetbiosName from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName like "Simple Mail Tran%" and SMS_G_System_SERVICE.StartName = "LocalSystem"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now