Automatically Set SQL MaxServerMemory on Cluster Failover with PowerShell

On a two-node Windows Failover Cluster, I have two SQL instances installed. Each instance runs on its own node in the cluster, so that it can make maximum use of the available memory on that server. However, when a failover occurs, it is necessary to reduce the maximum server memory setting for both instances, so … Continue reading Automatically Set SQL MaxServerMemory on Cluster Failover with PowerShell

Forcing a ConfigMgr Client to Send a New CCMEval Report

In order to maintain a healthy ConfigMgr environment, it is important to know that your clients have successfully run the Configuration Manager Health Evaluation task and reported the results to the Site server.  Sometimes you will find a number of systems that have not reported any health status to the Site server.  In the Devices … Continue reading Forcing a ConfigMgr Client to Send a New CCMEval Report

New Free App – ConfigMgr Deployment Reporter

Just released a new free application for ConfigMgr admins - ConfigMgr Deployment Reporter.  I developed this app for use in the organisation I currently work for, and it turned out quite well, so I decided to release a public version to the community! I developed this app as an alternative (and IMO easier) way to … Continue reading New Free App – ConfigMgr Deployment Reporter

Reading CCMEval Results Directly from a ConfigMgr Client with PowerShell

Since Configuration Manager 2012, a scheduled task is created by the client installer that runs "CCMEval.exe" periodically to check that the client is healthy and all the components it depends on are functioning as they should be. A number of checks are performed and if anything is found amiss, the default setting is to attempt … Continue reading Reading CCMEval Results Directly from a ConfigMgr Client with PowerShell

Client Health: Find all CCMEval Failed or Unknown

Keeping your ConfigMgr clients healthy is an important task for an SCCM administrator. Here's a SQL query that will find all devices in ConfigMgr that have been active in the last 7 days, but have either failed their CCMEval or have "unknown" status, ie no CCMEval results. I like to add SQL queries to PowerShell functions … Continue reading Client Health: Find all CCMEval Failed or Unknown

Send a Weekly OS Deployment Summary Report with PowerShell

Here's a script I wrote that sends a simple summary of ConfigMgr OS Deployments in the last week as an HTML-formatted email. It gives you the start and finish date/time, duration and model for each computer deployed (where the information is available in SCCM), and a list of any steps in an error state for … Continue reading Send a Weekly OS Deployment Summary Report with PowerShell

Free ConfigMgr Task Sequence Monitoring Tool

Update! (Nov 19 2015 - If you experienced the issue with the app appearing and immediately disappearing again, this has been fixed in the latest release v1.2.1) Today I am pleased to release a new free application for System Center Configuration Manager users: ConfigMgr Task Sequence Monitor 🙂 It is a tool for monitoring or reviewing task … Continue reading Free ConfigMgr Task Sequence Monitoring Tool

Free ConfigMgr Client Health Report

Today I am pleased to make available the first of my free reports for System Center Configuration Manager 2012 and onward - a client health report.  These reports have been created in Microsoft Excel and use data connections to the ConfigMgr database, which allows us to pull a large amount of data into a single … Continue reading Free ConfigMgr Client Health Report

Retrieving Software Inventory for a ConfigMgr Site with PowerShell

In my last post, I demonstrated how we can retrieve software inventory information for a single ConfigMgr client or an array of clients, using PowerShell.  In this post, we will change the scope from the client to the entire site.  Using this script, you can query for all installations of a specific software/s in your ConfigMgr site, … Continue reading Retrieving Software Inventory for a ConfigMgr Site with PowerShell