Right Click Tools
Recast Device Collections in the ConfigMgr Console – Queries

Receive notification right in your inbox whenever new content like this is released & sign up for our email list!
We’ll send you the latest updates, how-to’s, and solutions to empower you at every endpoint.
By signing up you agree to our Privacy Policy.
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



Then “is equal to” which is set to “Right Click Tools”


Now Repeat for the Proxy & Management Server




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”

Related Resources


BitLocker Compliance Tool Dashboard: Ensure Compliance Before Loss or Theft













Right Click Tools Management Server 4.1 – Technical Guide to upgrading from 4.0


























































What’s New in Right Click Tools: 4.1 Tech Overview – Hardware Audit Dashboard























































