How to Clean Up Custom Inventory

How to Clean Up Custom Inventory

The other day, a friend, emailed me to ask, if I had an article that show you how to clean up Custom Inventory within SCCM. I said that I didn’t but I would try to write an article on How to Clean Up Custom Inventory over the weekend. As a Microsoft Configuration...
Calculating ConfigMgr Custom Inventory Database Size

Calculating ConfigMgr Custom Inventory Database Size

The other day, a good friend of mine reached out and asked if I had an article on Calculating ConfigMgr Custom Inventory Database Size. I told him that I didn’t have an article on the subject. He told he that it would be a good topic, so here is this article. As a...
I want to Learn SQL Querying!

I want to Learn SQL Querying!

As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) administrator, you will be asked to create reports. MECM Reporting really really SQL Server Reporting Services (SSRS) reporting. In some case it is Power BI Desktop or Power BI Report...
Using Datediff & GetDate in WQL

Using Datediff & GetDate in WQL

As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr) Adminstrators. Knowing WQL is important! But How do you use Datediff & GetDate in WQL? This blog will talk about for you. Normally I wouldn’t post a reply to blog post but in this case...
I want to Learn SQL Querying!

Patch Compliance Progression Report

This is the Patch Compliance Progression Report for MECM.  This is one of those Software Update (SU) SQL queries that you want. It will grab the MECM software update status compliance of the device. As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM )...