Avatar of ferrarista
ferrarista
 asked on

SCCM 2012 - Exchange Servers Collection

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
SCCM

Avatar of undefined
Last Comment
ferrarista

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
N

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ferrarista

ASKER
Thanks NG. WIll try that tomorrow!
Your help has saved me hundreds of hours of internet surfing.
fblack61