ferrarista

<div>
Thanks NG. WIll try that tomorrow!
</div>


<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I have a collection that should list all Exchange Servers, but it shows zero members.<br />
The query is the following<br />
<br />
select SMS_R_SYSTEM.ResourceID,SM<wbr />S_R_SYSTEM<wbr />.ResourceT<wbr />ype,SMS_R_<wbr />SYSTEM.Nam<wbr />e,SMS_R_SY<wbr />STEM.SMSUn<wbr />iqueIdenti<wbr />fier,SMS_R<wbr />_SYSTEM.Re<wbr />sourceDoma<wbr />inORWorkgr<wbr />oup,SMS_R_<wbr />SYSTEM.Cli<wbr />ent from SMS_R_System inner join SMS_G_System_SERVICE on &nbsp;SMS_G_System_SERVICE.Resou<wbr />rceId = SMS_R_System.ResourceId &nbsp;where SMS_G_System_SERVICE.Name like &quot;Microsoft Exchange%&quot;<br />
<br />
Do you think the query is wrong ? <br />
<br />
I'm not an SCCM expert. Is there a way to debug these queries in a simple manner ?<br />
<br />
Thanks in advance
</div>
</div>


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 2012 - Exchange Servers Collection

Systems Center Configuration Manager (SCCM, formerly known as Systems Management Server) is Microsoft’s system software for managing large groups of not only Microsoft computers, but those running other operating systems, such as Linux, OS-X, and various mobile technologies.