SCCM SQL Query – Client Push Queue

I was looking into the built-in SSRS report titled 'Client push installation status details'. This report shows the status of all client push attempts, including error codes. I needed to extend this information for a client to include the workstations Active Directory Site name. I looked into SSRS and noticed it used the following stored … Continue reading SCCM SQL Query – Client Push Queue

Gather SCCM Site Code – PowerShell

During a recent ConfigMgr side by side migration project I was asked to provide a reliable way to return AD Site and SCCM site code information for each computer in an OU. The below PowerShell script is what i came up with. https://gist.github.com/danjpadgett/53d5178ef2530eb1075f967301ac695a The script will return Name, ADSite and SCCM site code information for … Continue reading Gather SCCM Site Code – PowerShell