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 )...
1st Anniversary

1st Anniversary

Well today is 1st anniversary of me taking steps to upgrade my certifications to Windows 2003 / Windows 2008. As many of you know I have blog about my experiences with all the exams. So this blog post is designed to talk about a few things. Which exam I write and...
365 Posts

365 Posts

Well, with this post I have now officially met my goal of one blog post per day for a year e.g. 365 posts. Sort of. 🙂 The year actually will end on Jan 2 2008. It was a lot of work and I learn a ton while doing this. Least of which is how to pre-post blogs! Reflecting...