Queries
Category: Queries
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…
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….
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…
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…
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…
