<div>
<div class="content wysiwyg-content">
I created an SCCM Query that Vista portables with less than the Cisco VPN 5.0.03.0560 Client. It works well but it lists multiple records of the same systems. For instance when I run the query system xyz will be listed around 8 times or so when I just want it to be listed once. My query code is listed below. If anyone can help me out I would appreciate it. Thanks. <br />

<pre><code id="code-439225">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, SMS_R_System.OperatingSystemNameandVersion from  SMS_R_System inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_AF_ADDREMPROGS on SMS_G_System_AF_ADDREMPROGS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_AF_ADDREMPROGS.DisplayName &lt; &quot;Cisco Systems VPN Client .0.03.0560&quot; and SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in (&quot;8&quot;,&quot;9&quot;,&quot;10&quot;,&quot;14&quot;) and SMS_R_System.OperatingSystemNameandVersion = &quot;Microsoft Windows NT Workstation 6.0&quot; or SMS_R_System.OperatingSystemNameandVersion = &quot;Microsoft Windows NT Workstation 6.0 (Tablet Edition)&quot;
</code></pre>
</div>
</div>


I created an SCCM Query that Vista portables with less than the Cisco VPN 5.0.03.0560 Client. It works well but it lists multiple records of the same systems. For instance when I run the query system xyz will be listed around 8 times or so when I just want it to be listed once. My query code is listed below. If anyone can help me out I would appreciate it. Thanks. 

Multiple Records Populate of the Same System when Running SCCM Query

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.

Microsoft Server OS

IT Administration is the processes and best practices for programming and development, and incorporates methodologies for managing activities and projects. Common methodologies include waterfall, prototyping, iterative and incremental development, spiral development, rapid application development, extreme programming and various types of agile methodology. The life-cycle "model" is a more general term for a category of methodologies, and a software development "process" a more specific term to refer to a specific process chosen by a specific organization.