SOLVED SCCM Collection to list systems that have duplicate software installs of specific software

[kalel]

Good day. Looking to see if someone has a collection query for listing systems that show a particular software installed twice with different versions. We have some systems where by Zoom Meeting shows installed with two different versions and I was able to see it via Add/Remove programs on a couple of computers. The collection I ran below keeps coming back with 0 systems. When I review SCCM Resource Explorer, I can see the duplicate listed in the Installed Application (64).

select * from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId where (SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Zoom (64-bit)" and SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version = "5.16.26186") and (SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Zoom (64-bit)" and SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version = "5.15.19404")

Thx in advance for any help provided.

 

[Garth]

You will need to use a subselect query for this to work.

 

[kalel]

Thx for the feedback. I'll give that a try and see how it goes.