SQL Query to know how many clients are connected to Internet MP in Endpoint configuration manager

After Implementing CMG, configuration manager management point keeps the ability to allow both the Intranet and Internet traffic. If you have allowed the Internet traffic to your servers then you might be thinking about how many clients machines are approaching the servers through Internet traffic ( CMG ) All these possible by using the SQL … Continue reading SQL Query to know how many clients are connected to Internet MP in Endpoint configuration manager

SQL Query to get all SCCM servers with their roles

Most of the time system administrator struggle to find all the SCCM servers with their roles. I have created one sql query to get the details servers with the roles. Query is below SELECTsrs.ServerName,srs.SiteCode,vs.SiteName,vst.AD_Site_Name0 as ADSite,vs.ReportingSiteCode as Parent,vs.Installdir,MAX(CASE srs.rolename WHEN 'SMS Site System' THEN 'Yes' Else ' ' END) as SiteSys,MAX(CASE srs.rolename WHEN 'SMS Component … Continue reading SQL Query to get all SCCM servers with their roles

SQL Queries for SCCM

Computers that have 30 days or less hardware information SELECT a.ResourceID, a.Netbios_name0 AS[Name], b.LastHWScan FROM v_R_System a INNER JOIN v_GS_WORKSTATION_STATUS b ON a.ResourceID = b.ResourceID WHERE b.LastHWScan >= Dateadd(day, -30, getdate()) Collection of clients not approved SELECT a.ResourceID, a.Netbios_name0 AS[Name], a.ResourceType, a.SMS_Unique_Identifier0 AS[UniqueID], a.Resource_Domain_OR_Workgr0 AS[Domain], a.Client0, b.IsApproved FROM v_R_System a INNER JOIN v_CM_RES_COLL_SMS00001 b ON … Continue reading SQL Queries for SCCM

Power BI : Power BI SCCM Template from Microsoft

This post runs through the process of setting up Power BI and the SCCM template which will give you detailed information on your System Center Configuration Manager including client and server health, malware protection, software updates, and software inventory across your organisation. First things first, to run the Power BI SCCM template you need to running … Continue reading Power BI : Power BI SCCM Template from Microsoft

Getting email alert when imaging is finished

When Rebooting Is Not The Answer

I wanted to get some details every time a machine was imaged for my own details.  Mostly for asset tracking purposes I set up the below script to run at the end of my task sequence.

It is really nice to get all this info.

PC imaged is PCname with Serial R9ZRLB8 and Make and Model LENOVO 23594LU.  Processor is Intel(R) Core(TM) i5-3230M CPU @ 2.60GHz.  Ram is 8.00 GB.  Operating System is Microsoft Windows 10 Pro 10.0.15063

I suppose this could also be modified so that the tech imaging the machine could also get the email.  Maybe basing it off of the machine’s OU.  Hopefully someone finds this useful but I have found it quite handy.  I have also finished a script to gather logs when the task sequence fails and send them to me but I am still testing that out and will save that for my next…

View original post 46 more words

SCUP : Managing 3rd Party Updates in SCCM 2012 using SCUP

This guide will show you how to configure SCUP and deploy 3rd party updates(Adobe, Flash Player) With Microsoft Updates via SCCM 2012 using SCUP plus software update catalogs. Managing 3rd Party Updates in SCCM 2012 using SCUP 1- Installing and configuration SCUP 2011 It’s required to publish the updates to WSUS in order to deploy … Continue reading SCUP : Managing 3rd Party Updates in SCCM 2012 using SCUP

New Tool: ConfigMgr Client Notification



Today I whipped-up a very simple tool for ConfigMgr admins and support staff. It allows you to send client notifications (using the so-called fast channel), such as downloading the computer policy, collecting hardware inventory, checking compliance etc, to remote computers from your local workstation independently of the ConfigMgr console.


The tool connects to your ConfigMgr site server using a Cimsession and PSSession, so you need WsMan operational in your environment. You simply provide some computer name/s in the text box, enter your site server name, select which client notification you want to send and click GO. The tool will get the online status of the clients from the SMS Provider to give you an indication of which systems will receive the client notification. Then it will trigger the client notification on online systems from the site server.

The tool is coded in PowerShell / Xaml and uses the MahApps Metro…

View original post 112 more words

Monitor Content Downloads Between an SCCM Distribution Point and a Client


Sometimes you want to monitor the progress of a content download on an SCCM client from a distribution point. You can use the Get-BitsTransfer PowerShell cmdlet, but it doesn’t currently support running on remote computers, so I wrapped the cmdlet in a bit of extra code that lets you get Bits transfer information from a remote computer, and adds a couple of extra values like the transfer size in megabytes and gigabytes as well as a percent complete value. Run it while there’s an active transfer to monitor the progress.

Simply provide a computer name like so:

Get-BitsTransfers -ComputerName PC001

Function Get-BitsTransfers { [CmdletBinding()] Param ( [Parameter(Mandatory=$true, ValueFromPipelineByPropertyName=$true, Position=0)] $ComputerName ) Invoke-Command -ComputerName $ComputerName -ScriptBlock { $BitsTransfers = Get-BitsTransfer -AllUsers Foreach ($BitsTransfer in $BitsTransfers) { [pscustomobject]@{ DisplayName = $BitsTransfer.DisplayName JobState = $BitsTransfer.JobState OwnerAccount = $BitsTransfer.OwnerAccount FilesTotal = $BitsTransfer.FilesTotal FilesTransferred = $BitsTransfer.FilesTransferred BytesTotal = $BitsTransfer.BytesTotal MegaBytesTotal = [Math]::Round(($BitsTransfer.BytesTotal / 1MB),2) GigaBytesTotal…

View original post 24 more words

SCORCH : Active Directory Cleanup with Orchestrator

Active Directory Cleanup Runbook Automation 6 runbooks – 5 are functional workbooks and 1st runbook calls the rest in sequence. Download the Powershell Scripts - ad cleanup runbook ps   Runbook 1 – AD Cleanup The Master Runbook – which triggers every 7 days 16 hours – call the 5 runbooks and they a ‘wait … Continue reading SCORCH : Active Directory Cleanup with Orchestrator