SCCM

Automaticcaly Uninstall software when user isn’t member of a group

The below script will automaticcaly uninstall software if user is no longer member of the group, and the software is installed on the computer. replace Software Installed with your software display name and “DOMAIN\\GROUP” with your local security group that is used for installing the software [code language=”SQL”] 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 …