<div>
Also I assume that BUS isn't inside the name by default but you could be more specific, also wouldn't worry about the upper. &nbsp;Use something like<br />
&quot;LIB-BUS-%&quot; this makes it more specific<br />
<br />
Cheers
</div>


Also I assume that BUS isn't inside the name by default but you could be more specific, also wouldn't worry about the upper.  Use something like
"LIB-BUS-%" this makes it more specific

Cheers

<div>
Thanks Matrixnz that has worked
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I'm having trouble with an SCCM query not returning the correct information.<br />
<br />
I'm trying to do a dynamic collection of computers based on their hostname. My computers are named LIB-&lt;Building&gt;-&lt;number&gt;<br />
<br />
Examples: LIB-HSS-01, LIB-BUS-15<br />
<br />
What I am trying to do is get a list of all computers in a building. So I've run the SMS query below but I don't get any results. Can someone please point me in the right direction fo where I am going wrong.<br />
<br />
The criteria I set up to generate the query was &quot;System Resource.Name uppercase is equal to &quot;%BUS%&quot;&quot;<br />
<br />
Regards<br />
<br />
Mat<br />
<br />
<br />
<br />
<br />

<pre><code id="code-249966">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 UPPER(SMS_R_System.Name) = &quot;%BUS%&quot;
</code></pre>
</div>
</div>


Hi

I'm having trouble with an SCCM query not returning the correct information.

I'm trying to do a dynamic collection of computers based on their hostname. My computers are named LIB-<Building>-<number>

Examples: LIB-HSS-01, LIB-BUS-15

What I am trying to do is get a list of all computers in a building. So I've run the SMS query below but I don't get any results. Can someone please point me in the right direction fo where I am going wrong.

The criteria I set up to generate the query was "System Resource.Name uppercase is equal to "%BUS%""

Regards

Mat





SCCM query help

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.