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