Category: System Management Server

July 25, 2013
Troubleshooting Hardware Inventory for SCCM 2012

NOTE: this blog post has been updated, please see the update blog. https://www.enhansoft.com/blog/updated-troubleshoot-configmgr-hardware-inventory-issues By Garth Jones I thought that it was about time to finally update my article on how…

January 18, 2013
CM12 /CM07 Training

I always get asked about training for CM07/CM12 sometime known as SCCM07 and SCCM12.  So, today when I stumbled across a YouTube channel, TeachMeSCCM, I thought that I would let…

June 22, 2012
Create a Collection with Non-Compliant Servers to Ensure that the No_SMS_On_Drive.SMS File is on All Site Servers

Recently a client asked, “How can I ensure that the No_SMS_On_Drive.SMS file is on all site servers?” You need to use DCM, and over a series of blog posts, we…

June 21, 2012
Assigning a Configuration Baseline to Ensure that the No_SMS_On_Drive.SMS File is on All Site Servers

Recently a client asked, “How can I ensure that the No_SMS_On_Drive.SMS file is on all site servers?” You need to use DCM, and over a series of blog posts, we…

June 19, 2012
Create a Configuration Item to Ensure that the No_SMS_On_Drive.SMS File is on All Site Servers

Recently a client asked, “How can I ensure that the No_SMS_On_Drive.SMS file is on all site servers?” You need to use DCM, and over a series of blog posts, we…

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 31, 2011
Last day to request free SSRS report

Today is the last day to request the winner of this month’s free SSRS report give-away – Advertisement Home Page Report. Please contact info@enhansoft.com for a free license key. Let…