<div>
HI Gaurav, 
 
thanks for this, good side indeed. 
 
But, Ihave this query, which shows me all clients with a SCCM Client installed on it: 
 
&quot;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 where Client = 1&quot; 
 
 
In Addition, I need to know which of these clients found by the above query belongs to a specific site code. I mean Ineed to have two queries with an inner join. 
 
But I have not the second query and if I have I don't know how to put the queries together (with inner join). 
 
Maybe you can help me with this as well. 
 
inis01
</div>

HI Gaurav,

thanks for this, good side indeed.

But, Ihave this query, which shows me all clients with a SCCM Client installed on it:

"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 where Client = 1"


In Addition, I need to know which of these clients found by the above query belongs to a specific site code. I mean Ineed to have two queries with an inner join.

But I have not the second query and if I have I don't know how to put the queries together (with inner join).

Maybe you can help me with this as well.

inis01

<div>
<div class="content wysiwyg-content">
Hi, 
 
I need a SCCM collection query with which I can find computers/workstations who have already a SCCM client installed 
AND who have a specific site code like &quot;&nbsp;abc&quot;. 
 
Many thanks in advance 
Insi01
</div>
</div>

Hi,

I need a SCCM collection query with which I can find computers/workstations who have already a SCCM client installed
AND who have a specific site code like " abc".

Many thanks in advance
Insi01

Looking for SCCM query

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.