Active Directory Sites and System Center Configuration Manager Boundaries are hard to keep in sync – especially in an environment where there are regular changes and several team managing each technology separately.
This Power BI dashboard solution will help analyze and reduce down the gaps in SCCM. The dashboard will help SCCM administrators / architects to resolve issues where clients are not covered – this helps in Client Health / Reporting and Compliance.
The dashboard is based off the Powershell script posted on Technet by Scott Breen and can be downloaded from here : https://gallery.technet.microsoft.com/Validate-Boundary-Group-d85ed496
How to use this :
A. The script can be configured to run on schedule via Scheduled Tasks on a server or via System Center Orchestrator.
B. The output CSV can be placed on a network share on local folder.
C. Power BI will read this csv and perform the necessary DAX operations.
D. Power BI can further be used to publish on o365 on the Power BI portal. Power BI gateway can be configured so that the content is autoupdated on a schedule. Embedded Power BI options can be used to inject the dashboard into Sharepoint or any site.
Backend engine :
The output [download csv here] of the script needs some work to be done and looks like this >
The last column is most important in this csv output – the result ‘False’ indicates the machine is not covered by any SCCM Boundary. The other columns provide plenty of information – but its not really presentable or understandable from the get go.
The conversion of the csv data from crude data to human readable format is performed by Power BI and via DAX. The csv file before conversion is available here – BoundaryCheck-csv
The PowerBI dashboard is configured to pull information from C:\PowerBI\adsite-vs-boundaries\Boundarycheck.csv
Get it now !
Download the PBIX.
During the Build process if you encounter any issues you can perform further investigation with the below mandatory information
- Machine model
- Error code with snapshot
- Error stage with snapshot (may be hiding behind the Task Sequence error window)
- Single system failure OR multiple systems failures
- Build Failure Logs (as described below)
- Mention if any HW component has been replaced on the machine
- Do not restart the system when the build failure occurs and shows the Task Sequence error
- Please note the error code with snapshot
- Note the error stage – the stage build got failed (may be behind the Task Sequence error window)
- Press F8 key for Command Prompt
- Refer the below table OSD Logs Path for logs location based on failure stage
- Copy all the log files to the USB drive connected to System
- Attach the gathered logs with incident / email to us for investigation
OSD Logs Path
Smsts.log is found in different locations depending on the stage of failure:
|Build Failure Stage
||Log file location
|WindowsPE, before HDD format
|WindowsPE, after HDD format
|Windows, SCCM agent not installed
|Windows x64, SCCM agent installed
|Task Sequence completed x64
Network Setup and Domain Join
For issues related to Build failure at domain joining step please gather the below logs
% SystemRoot %\debug\netsetup.log