SENDING DATA TO TEAMS FROM SCCM

In this tutorial I show how to send data from SCCM (MEMCM) to Microsoft Teams using the built-in Teams webhook and some PowerShell.

Specifically, I will show how we can get the latest software update deployment information via PowerShell, wrap it in some JSON, and then fire it off to a Teams channel!

Management will be impressed and junior admins may consider you a god. Pretty cool right?

SETTING UP THE WEBHOOK

The first step is that you need to create a Teams channel! If you are unsure how to do this please go away and learn check this article. Once you are setup, hit the … to the right of the channel and click on Connectors

Now search for Incoming Webhook and click Add

Click Add again

You may need to go back in via the three dots but you should now see a Configure button for the connector

Give your webhook a name and choose an image (these will be visible in the channel when the webhook posts something) and then click Create

Copy the unique URL as we will need this for our script and then click on Save

If you now check your channel you should see something like the below which indicates we are good to go!

SCCM AND POWERSHELL – GETTING SET UP

SCCM has its own PowerShell module and this can be accessed from any machine that has the console installed. More information can be found about the module and the available cmdlets here

Set-Location  'C:\Program Files\Microsoft Configuration Manager\AdminConsole\bin'
Import-Module .\ConfigurationManager.psd1

With the module now exposed we need to set up a PSDrive to the site server. Replace ABC with your three letter site code and siteserver.contoso.com with the FQDN of your site server

New-PSDrive -Name "ABC" -PSProvider "CMSite" -Root "siteserver.contoso.com" -Description "Primary site"

To run our cmdlets we now need to change directory to the logical drive (replace ABC with your SCCM site code)

Set-Location ABC:

PULLING THE UPDATE INFORMATION WITH POWERSHELL

With the above prep done we can now pull pretty much anything we want out of SCCM. In this example I am grabbing –

• The Automatic Deployment Rule information (last run time and exit code)
• A specific software update group and the updates it contains
• Deployment details such as the collection the software update group targets
• The status of the update installations on the collection members (two devices in my lab environment).

IMPORTANT – Remember to add in your unique URL at the bottom of the script 😉

### Get some ADR info, last run time and exit code

$ADR = Get-CMSoftwareUpdateAutoDeploymentRule -Name "Windows 11"

$ADRLastRun = $ADR.LastRunTime 
$ADRExitCode = $ADR.LastErrorCode

### Get the Software Update Group

$sugupdates = Get-CMSoftwareUpdateGroup -Name "Windows 11"

### Get the updates inside in the software update group and do a bit of formatting on the results

foreach ($update in $sugupdates.Updates)

{
 $CurrentUpdates += @(Get-CMSoftwareUpdate -Id $update)
}

$CurrentUpdatesName = $CurrentUpdates.LocalizedDisplayName

$CurrentUpdateNameFormatted = [string]::Join('<br>',$CurrentUpdatesName)

### Get the deployment details 

$sudeploy = Get-CMSoftwareUpdateDeployment -Name "Windows 11" -Summary


$CollectionName = $sudeploy.CollectionName
$NumberDevices = $sudeploy.NumberTargeted
$NumberInProgress = $sudeploy.NumberInProgress
$NumberErrors = $sudeploy.NumberErrors
$NumberSuccess = $sudeploy.NumberSuccess

### Prepare the payload

[String]$var = "Text which appears in the message content"
$JSONBody = [PSCustomObject][Ordered]@{
"@type" = "MessageCard"
"@context" = "<http://schema.org/extensions>"
"summary" = "Latest Update Deployment Information"
"themeColor" = '0078D7'
"title" = "Latest Update Deployment Information"

"text" = "
The ADR last ran <strong>$ADRLastRun</strong><br>
The ADR exit code was <strong>$ADRExitCode</strong><br>
<br>
The updates in the software update group are:<br><br>
<strong>$CurrentUpdateNameFormatted
</strong>
<br><br>
The collection name is <strong>$CollectionName</strong><br>
The number of devices is <strong>$NumberDevices</strong><br>
<br>
Successes: <strong>$NumberSuccess</strong><br>
In Progress: <strong>$NumberInProgress</strong><br>
Errors: <strong>$NumberErrors</strong><br>
"
}

### Convert to JSON

$TeamMessageBody = ConvertTo-Json $JSONBody

### POST to URL

$parameters = @{
"URI" = "INSERT YOUR UNIQUE URL"
"Method" = 'POST'
"Body" = $TeamMessageBody
"ContentType" = 'application/json'
}

Invoke-RestMethod @parameters

THE RESULTS

And here we go! A nicely formatted message (thanks to the HTML tags in the JSON) and this is something that can easily be called from a scheduled task on a repeatable basis.