troubleshooting Question

Multiple Records Populate of the Same System when Running SCCM Query

Avatar of kulisncc
kulisncc asked on
Microsoft Server OSIT Administration
1 Comment1 Solution491 ViewsLast Modified:
I created an SCCM Query that Vista portables with less than the Cisco VPN 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.
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 < "Cisco Systems VPN Client .0.03.0560" and SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ("8","9","10","14") and SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 6.0" or SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 6.0 (Tablet Edition)"

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros