Grafana Dashboards for SCCM (Part 2)

Octavian Cordos

Published in

MEM.Zone

3 min readDec 3, 2018

Client, distribution and OS info dashboard.

🚨🚨 IMPORTANT NOTICE🚨🚨
🦄 We moved to our brand new blog at MEM.Zone 🦄
🚨🚨 IMPORTANT NOTICE🚨🚨

Links

SCCM Dashboards with Grafana (Part 1 — Preview, pre-requisites, installation)

SCCM Dashboards with Grafana (Part 2 — Client, distribution and OS info…)

SCCM Dashboards with Grafana (Part 3 — Updates and SCEP Definitions)
…

This part is short and sweet :). We do a quick config for the Telegraf agent on our SQL server, run some queries and feed them to InfluxDB via Telegraf. After that, we import a dashboard to display the data.

Gathered data

Connected clients to local and Cloud Management Points
Installed SCCM client versions
Operating System versions of your clients
Distribution Points and Packages Status
Client Data Sources (Distribution Point, Peer Cache, Branch Cache, Cloud Distribution Point)
Site Systems network Throughput ( see Part 1)

Script

Script parameters

Server
Specifies the SQL server or listener.
Database
Specified the SCCM database name.
Server_Collection
Specifies the server CollectionID.
Workstation_Collection
Specifies the server CollectionID.

Installation

Create a folder for the Telegraf scripts

D:\Scripts\Telegraf_Scripts

Download the script above and set the run parameters

Note
In addition to the initial parameters you can also add an exclusion for Boundary Group Names in the script body.

line 353: and [bg].[Name] not like '%servers%'

Open your telegraf.conf and look for the following section

telegraf.conf

Add a call to clients.ps1

Make sure the account/machine running Telegraf has access to run the queries.
Restart the Telegraf service to load the new configuration.
Check telegraf.log file for errors.
Log into your Grafana instance and import the Pie Chart plugin and the SCCM — Clients dashboard.