Category: Queries

June 24, 2020
Adding an All Option to Your Prompt

In my blog post, Turning Three Reports into One Report, I said that I would show you how to adjust your prompt to allow for an, “All Option.” Everything you…

June 17, 2020
Where to Find User Name Data Within Configuration Manager – Part 2

In my last blog post, I talked about the four places to find user name data details and how they are collected/inventoried: Hardware Inventory, Heartbeat Discovery, Asset Intelligence and BGB….

June 10, 2020
Where to Find User Name Data Within Configuration Manager – Part 1

A lot has changed since my discussion a few years ago with a fellow Configuration Manager (ConfigMgr) MVP about user names, where to find them, and the pros and cons…

February 5, 2020
Why Am I Getting Incorrect Results in Visual Studio?

When I first encountered this issue, some time ago, I checked all of my queries in SQL Server Management Studio (SSMS) and guess what? As I suspected, the queries were…

September 18, 2019
How to Create a Collection for Workstations

This might seem like an odd blog post to write. Why not simply search for all workstations with “Windows 7%” and “Windows 10%” in your query? Once you have this…