Check device boot times using CMPivot Query in SCCM

In this post, I will show you how you can check device boot times using CMPivot query for Windows devices in SCCM. This information will help Configuration Manager administrators to find out the devices with slow boot times and take further measures to address them.

Boot time of a device is the time it takes for a device to be ready to operate after the power has been turned on. Computer boot times typically range from 10 to 30 seconds. Longer boot times can indicate system problems, such as malware, device conflicts, or inefficient hardware configuration.

If your remote SCCM users are complaining about the slow PC boot times, you can run a CMPivot query to find the boot times for these devices. Regularly tracking a device’s boot startup time can help administrators detect issues early and take preventive measures.

If you have never used the CMPivot before, I would recommend reading the CMPivot documentation to understand how it works and how to use it to access the state of your devices. Some popular guides covering the CMPivot query usage are listed below.

• Find BIOS information using CMPivot
• Check antimalware software status with CMPivot
• Find recently used applications in SCCM with CMPivot
• Find installed Windows patches using the CMPivot query

Check device boot times using CMPivot Query

Here’s how you can run a CMPivot query to determine the device boot times. Launch the SCCM console and navigate to Assets and Compliance > Overview > Device Collections. Right-click a device collection and select Start CMPivot.

To see the boot times for devices, switch to the Query tab of the CMPivot tool. Paste the query into the CMPivot query editor and click Run.

SystemBootData
| project Device, BiosDuration, OSVersion, SystemStartTime, BootDuration, OSStart=EventLogStart, GPDuration, UpdateDuration
| order by SystemStartTime desc

Running the above CMPivot Kusto query outputs the following information for each device:

• Device: The computer name for which the query is executed
• BiosDuration: Shows the time for the BIOS to initialize during boot. The values vary for physical laptops and virtual machines.
• OSVersion: Displays the operating system version of the device.
• SystemStartTime: Shows the total startup time for your device.
• BootDuration: Total time taken by device to boot and show the log-in screen.
• GPDuration: Time taken to process Group Policy during system startup or user login.
• UpdateDuration: Time spent on updating Group Policy settings during startup or logon.