Category: System Management Server

March 23, 2012
Wild Card Prompts

Q: Can the input variable that is query based be searchable similar to the native SCCM Web Reporting interface?  i.e. Can the Collection ID be searched using a wild card rather than…

List of computers from an AD User Security Group

Use this query to get a list of PCs by user’s security group. For full details see the forum post: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/5180b626-b6c7-4639-a8ff-b2276f1c4cad select CS.Name0, CS.UserName0 from dbo.v_R_User U join dbo.v_RA_User_UserGroupName UGN…

March 19, 2012
SCCM Guru Webcast Follow Up

During my recent SCCM Guru webcast there were a number of questions that came in during the webcast. I will answer most of them within this blog post, however, there…

January 26, 2012
Depended Package

Use this query to get the package name for any depended program. See the TechNet forum post for full details. SELECT Pkg.Name AS ‘Package Name’, ADV.ProgramName AS ‘Program Name’, ADV.AdvertisementName…

March 24, 2011
Thank You MMS-2011

Thank you to everyone who dropped by Enhansoft’s booth at this year’s MMS Conference.   Today is our last day, so if you still haven’t dropped by, please do. It was…