SCCM How to create a device collection to know how many workstations have an application

%3CLINGO-SUB%20id%3D%22lingo-sub-2442991%22%20slang%3D%22en-US%22%3ESCCM%20How%20to%20create%20a%20device%20collection%20to%20know%20how%20many%20workstations%20have%20an%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2442991%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20create%20a%20device%20collection%20to%20know%20how%20many%20workstations%20have%20an%20application%20called%20CBT.exe%20regardless%20of%20the%20version%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2445324%22%20slang%3D%22en-US%22%3ERe%3A%20SCCM%20How%20to%20create%20a%20device%20collection%20to%20know%20how%20many%20workstations%20have%20an%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2445324%22%20slang%3D%22en-US%22%3EHi%20KB2030%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20create%20a%20device%20collection%20with%20the%20query%20that%20below.%20The%20number%20of%20devices%20in%20the%20collection%20is%20how%20many%20devices%20have%20the%20CBT.exe%20file.%3CBR%20%2F%3E%3CBR%20%2F%3Eselect%20SMS_R_SYSTEM.ResourceID%2CSMS_R_SYSTEM.ResourceType%2CSMS_R_SYSTEM.Name%2CSMS_R_SYSTEM.SMSUniqueIdentifier%2CSMS_R_SYSTEM.ResourceDomainORWorkgroup%2CSMS_R_SYSTEM.Client%20from%20SMS_R_System%20inner%20join%20SMS_G_System_SoftwareFile%20on%20SMS_G_System_SoftwareFile.ResourceID%20%3D%20SMS_R_System.ResourceId%20where%20SMS_G_System_SoftwareFile.FileName%20%3D%20%22CBT.exe%22%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20Regards%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi all,

 

How to create a device collection to know how many workstations have an application called CBT.exe regardless of the version?

 

Thanks

1 Reply
Hi KB2030,

You can create a device collection with the query that below. The number of devices in the collection is how many devices have the CBT.exe file.

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 inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "CBT.exe"

Best Regards