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
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”
See how Right Click Tools are changing the way systems are managed.
Immediately boost productivity with our limited, free to use, Community Edition.
Get started with Right Click Tools today:
English 
Spanish 
German 
French 
Swedish 
Portuguese 
Finnish 
Italian