SCCM 2012 - Exchange Servers Collection

ferrarista
ferrarista used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Enterprise Systems Engineer
Commented:
Hello,

Rather than using SMS_G_System_Service.Name, try using SMS_G_System_Service.DisplayName

Keep everything else the same!  This certainly seems to work better for me.

Author

Commented:
Thanks NG. WIll try that tomorrow!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial