Recast Device Collections in the ConfigMgr Console - Queries

This post will walk you through creating Collections to help find machines in your environment that have Recast Software Installed.

Device Collections with Software Installed:

  • Recast Right Click Tools
  • Recast Proxy
  • Recast Management Server

Recommended Pre-Reqs: you have a Collection for Servers and Workstations.  I'd highly recommend using this set of Collections, auto created by a script. [Set of Operational SCCM Collections]
In this example, I'll be using the limiting collection "All Systems" because I know everyone has it.

Recast Right Click Tools

In Device Collections, create a new collection

Recast Right Click Tools Client Properties
Name and Comments are useful, Try to make them meaningful, or copy what I've used.
Recast Right Click Tools Query Rule Properties
Add Query
Recast Right Click Tools Clients Query Statement Properties
In Criteria, Simple Value, click Select. Installed Applications - Display Name
Then "is equal to" which is set to "Right Click Tools"
Recast Right Click Tools Query Rule Properties
As it displays
Recast Right Click Tool Client Properties
Membership Rule will be your Query.

Now Repeat for the Proxy & Management Server

Recast Proxy Service Properties

Recast Proxy Service Properties
Recast Management Server Properties
Recast Management Servers Properties

If you want the queries, here ya go:

Recast Management Server

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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Recast Management Server"

Recast Proxy

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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Recast Proxy"

Recast Right Click Tools

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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Right Click Tools"

Device Collection