MECM – Software install for a specific user
SCCM can report software by user, but only if you structure the query around user-to-device relationships, because SCCM fundamentally inventories software per device, not per AD user. The trick is to join: AD user → SCCM user resource User resource → primary devices (User Device Affinity or logon history) Device → installed software inventory Device…
Read more
MECM: SQL query for a report by collection, model, count
Wanted to create a SQL query to get a count of every model, per vendor like Dell based on the collection being used for creating a report in SSRS. This is a start. SELECT coll.Name AS [Collection Name], sys.Model0 AS [Model], COUNT(DISTINCT sys.ResourceID) AS [Model Count] FROM v_FullCollectionMembership fcm JOIN v_Collection coll ON fcm.CollectionID =…
Read more
SSRS Prerequisites for MECM Reporting
🧰 SSRS Prerequisites for MECM Reporting 🖥️ 1. SQL Server with SSRS Installed SSRS must be installed on the same server as SQL Server or a dedicated reporting server. You’ll need a compatible version of SQL Server (e.g., SQL Server 2019 or 2022). During installation, choose “Install and Configure” to set up the Report Server…
Read more
SQL – To track percentage completion of OS upgrades
To track percentage completion of OS upgrades from Windows 10 22H2 to Windows 11 24H2 in SCCM SELECT COUNT(*) AS TotalDevices, SUM(CASE WHEN os.Caption0 LIKE ‘%Windows 11%’ AND os.BuildNumber0 >= 26100 THEN 1 ELSE 0 END) AS UpgradedDevices, CAST(SUM(CASE WHEN os.Caption0 LIKE ‘%Windows 11%’ AND os.BuildNumber0 >= 26100 THEN 1 ELSE 0 END) * 100.0…
Read more