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
Category: SQL
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