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
Step-by-Step: Automate SQL Report in MECM
⚙️ Step-by-Step: Automate SQL Report in MECM Automating a SQL report in Microsoft Endpoint Configuration Manager (MECM) involves creating a custom report in the Reporting Services Point (SSRS) and scheduling it for delivery. Here’s a step-by-step guide to help you automate your report: 1. 🧱 Create the Report in SSRS You’ll use SQL Server Report…
Read more
Automating a SQL Report in MECM
🚀 Automating a SQL Report in MECM Automating a SQL report in Microsoft Endpoint Configuration Manager (MECM) means setting it up to run on a schedule and deliver results—typically via email or file share—using SQL Server Reporting Services (SSRS). Here’s how to do it from start to finish: 🛠️ Step 1: Create the Report in…
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