troubleshooting Question

SCCM 2012 - Exchange Servers Collection

Avatar of ferrarista
ferrarista asked on
SCCM
2 Comments1 Solution399 ViewsLast Modified:
Hi guys,

I have a collection that should list all Exchange Servers, but it shows zero members.
The query is the following

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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 like "Microsoft Exchange%"

Do you think the query is wrong ?

I'm not an SCCM expert. Is there a way to debug these queries in a simple manner ?

Thanks in advance
ASKER CERTIFIED SOLUTION
NServer and Systems Technician

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros