Instant Client Software Inventory with ConfigMgr and PowerShell

Here's a simple but handy PowerShell script I wrote that uses the ConfigMgr database to retrieve software inventory information for any client.  You can return the entire inventory for the client, or search for specific software.  You can also pass the computer name and/or software name along the pipeline to the script, so you can … Continue reading Instant Client Software Inventory with ConfigMgr and PowerShell

Retrieving ConfigMgr Status Messages with PowerShell

Did you know you can retrieve status messages from ConfigMgr, including the message descriptions, using PowerShell? I pieced together some code I found on the internet with some of my own code, and came up with the following script.  Essentially, it's the equivalent of running the "All Status Messages from a Specific System" from the status message … Continue reading Retrieving ConfigMgr Status Messages with PowerShell

Create a Database of Error Codes and Descriptions for Windows and ConfigMgr

In a recent post, I described different ways to translate error codes for Windows and Configuration Manager into their friendly descriptions.  In this post, I will show you how to create a SQL database of known error codes and descriptions that you can join to in your SQL queries, to help simplify your troubleshooting, and … Continue reading Create a Database of Error Codes and Descriptions for Windows and ConfigMgr

WSUS Database Maintenance for SQL Express

To perform database maintenance (defragmentation, re-indexing) on a WSUS database that is installed using SQL Express, I use the following solution.  Because SQL Express has no SQL Server Agent, you cannot create jobs or maintenance plans, but we can use Powershell with a Scheduled Task to perform regular maintenance.  I am using SQL Express 2012. Download … Continue reading WSUS Database Maintenance for SQL Express

Automating the Management of Checked-out Projects in Project Server

If you're a Project Server administrator, you've probably had to deal with Projects that seem to remain checked out for a long time.  Sometimes this could be the result of a check-in failure and sometimes Project Manager forgetfulness, but whatever the cause, as an admin you have to periodically force check-in those Projects for good housekeeping. … Continue reading Automating the Management of Checked-out Projects in Project Server

An Easy Way to Monitor Your ConfigMgr OS Deployments

There are several ways to monitor your OS deployments, since the monitoring service feature was introduced in MDT 2012 and above.  But if you are using ConfigMgr, or MDT-Integrated ConfigMgr, then it's very easy to monitor your OSDs using a connection to the ConfigMgr database.  I made a post about this before, using a Powershell script … Continue reading An Easy Way to Monitor Your ConfigMgr OS Deployments

Monitoring the Project Server Job Queue with PowerShell

!UPDATE! 20-Jan-2015.  Updated the SQL query to also query for jobs that do not have a completion date, as these can also indicate a problem with the queue. Recently we had an issue with our Project Server where there were some jobs stuck in the queue that were preventing other jobs, such as Project checkins, … Continue reading Monitoring the Project Server Job Queue with PowerShell

Creating Dynamic Reports for Configuration Manager with Microsoft Excel

Today I reached 10,000 hits on my blog, very cool, and what better way to celebrate than with a new post 🙂  Thanks to everyone who has stopped by, I hope that you have found something helpful and continue to do so! In today's post, I want to look at how to create dynamic reports for … Continue reading Creating Dynamic Reports for Configuration Manager with Microsoft Excel

Get the Deployment Status of ConfigMgr Packages and Task Sequences with PowerShell

In my last post, we looked at how to report on the deployment status of ConfigMgr Applications using PowerShell.  Of course, you can get this information from the built-in ConfigMgr SSRS reports too, but our aim here is to report this data quickly by using PowerShell to query the ConfigMgr database directly.  It enables you to … Continue reading Get the Deployment Status of ConfigMgr Packages and Task Sequences with PowerShell

How to Get the Deployment Status of ConfigMgr Applications with PowerShell

PowerShell and SQL server.  It's a combination I'm liking more every day 🙂  In this post, I give you a PowerShell script that will query your ConfigMgr SQL server and return the deployment status of a ConfigMgr Application. It will return data for each deployment of the application, giving you the names of the deployment … Continue reading How to Get the Deployment Status of ConfigMgr Applications with PowerShell