Tips & Tricks
How a Not Equal To Query is Processed
During and building on yesterday’s blog post about how a query is processed this post will show you how a query processes the Not Equal To operator. I should start out by saying Not Equal to is also shown with query as "Not (...=...)" or as "!=". I should also start...
Enable Workstation Logon Audit Policy in Order to Collect Top Console User Details
Last month I was asked how to get top console user details into a report. My first answer was to tell them to enable the Asset Intelligence (AI) class. However this was already done, so I asked if the auditing policy was enabled. It wasn’t. If you want to capture the...
Disabled Software Metering Rules Are a Good Thing!
In a previous blog post entitled, “Total Usage for All Metered Software Programs Query Matches the Executable Name,”. Reporting will show results for Disabled Software Metering Rules rules. I closed off that blog post by saying that this was in fact a good thing. So...
What is a Management Information Format (MIF) File?
It does matter what version of Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM ) you are using MIF files are something that you need to know about. There are two different types of Management Information Format (MIF) files (sort of). What are Management...
How to Avoid Receiving Inventory Re-Sync Requests for Snapshot VMs
In Wednesday’s and Thursday’s blog posts I showed you easy ways to force a full hardware inventory on a PC or multiple PCs. We use Hyper-v to make snapshots of the VMs in our test lab. This is done so that we can quickly revert a VM to a known state. In this case, the...
Inventory Cycle Version Numbers
Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM ). These questions come up from time to time. “Why is my inventory out of date for PC X,”. “Why am I getting bad Management Information Format (MIF) files for PC X?”. There are many reasons why this can...
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...
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...
How Much Is the Carbon Offset Cost for My Flight?
Earlier this year, before any travel restrictions were in place and virtual conferences became the norm. I was curious about carbon offset costs. With all of the discussion lately about climate change and how air travel produces a lot of carbon. I wanted to know:...
How to Create a SSRS Date Range Prompt
Hi Everyone! In this blog post, I am going to talk more about the SSRS date range prompt epiphany I had after creating my first Power BI date range slicer. In a new Power BI version of a Warranty Information Reporting report, I created a slicer in order for users to...