Sheik's Site
Overview In Microsoft SCCM (ConfigMgr), administrators may encounter situations where client heartbeat status appears outdated or incorrect in the console, even though the devices are actively communicating with the Management Point. A quick and effective workaround in such cases is executing the SQL stored procedure: This article explains when and why to use this command, … Read more
If you’re managing a large IT environment and want to generate a report that lists all software installed across systems from a specific company — like Microsoft, Adobe, or Google — you’re in the right place. In this guide, you’ll learn how to build a custom SQL query for SSRS (SQL Server Reporting Services) that … Read more
Monitoring client device uptime is crucial for ensuring system health, stability, and compliance—especially in enterprise environments. In Microsoft Endpoint Configuration Manager (SCCM), you can quickly fetch and export this information using a simple SQL query. In this guide, we’ll walk you through a SQL script that retrieves the hostname, last boot time, and uptime in … Read more
Query for Compliance report include the unknown Device.
SCCM Device collection Query based on the Device name. For devices whose names contain certain patterns or partial matches, you can use multiple LIKE conditions: SCCM Device collection Query for removing inactive devices based on the number of days.