PowerShell script to check on 503 error and sent to IT Support
PowerShell script to run a report in a table on a remote server to check web status is ok, if 503 error, highlight in yellow with a bold red font and send only if error via email to IT Support as html. <### Code Explanation: This PowerShell script is designed to monitor the status of…
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
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