Browse by Tags

All Tags » SQL queries (RSS)

Learning New ConfigMgr Versions at the Database Level

Those of us that have been in the ConfigMgr (SCCM/SMS) business for a while have had the joy (and challenge) of learning the new versions as they’re developed...
Posted by pthomsen | with no comments

Checking Client Health for a Large List of Computer Names

One of my pet peeves is reports (of any sort) that are long lists of computers. But the reality is that many people use such reports. I’ve found that people...
Posted by pthomsen | with no comments

ConfigMgr v.Next site settings query

ConfigMgr v.Next has a lot of wonderful improvements, and I look forward to talking about my favorites over time. But often the small ones are very delightful...
Posted by pthomsen | with no comments

ConfigMgr queries grouped by operating system family

If you’ve done ConfigMgr queries for awhile you’ve probably done some reports based on operating system. That has meant using the Caption0 column from...
Posted by pthomsen | with no comments

How long are your SMS 2003 patch scans taking?

Summary: patch scanning is normally a quiet behind-the-scenes activity that computer managers don't have to worry about. But that doesn't mean...
Posted by pthomsen | with no comments

Saving client health (or other) data to a SQL Server

Summary: most computer management specialists write and run SQL queries, but not many save data for later use. Yet saved data can allow you to do historic...

Quick advertisement status

Summary: a few simple queries can give you a quick update on your latest advertisement. You can then react as needed or get on to more important tasks...

Client Activity History - the original queries

Summary: starting at the basics, we need to know how much activity we're seeing from our computer management clients, and thus how much we're likely...

The joys of computer management data analysis

Summary: why do we enjoy computer management? One of my biggest answers is the joy of data analysis. Computer management involves a ton of diverse data...

How Microsoft IT Does Patch Management

Summary: one of the joys of working at Microsoft IT is that we get to talk to customers frequently about what we do (and yes, I am serious when I say it's...

Paul's TechSexy 2: how much time are your collections taking to evaluate?

Summary: computer management is bound to be complex, as I often say, and so SMS is a very busy system. Many subsystems, at multiple levels, process a lot...

Paul's TechSexy 1: great client deployment monitoring, thanks to v_ClientDeploymentState

Summary: client deployments (new installs or upgrades) are a critical part of the life of any SMS administrator. Whether you're rolling out your first...

Favorite SQL tricks: the distribution of recent activity

Summary: most questions that I get that can be answered with SQL queries are 'now' questions - how many Vista clients do we have at this point...
Posted by pthomsen | 1 comment(s)
Filed under:

Favorite SQL tricks: Analyzing SQL Server messages with vbScript

Summary: combining SQL Server query results and vbscript is a powerful tool, and well documented. But what if you want SQL Server error messages returned...
Posted by pthomsen | 1 comment(s)
Filed under: ,

Counting clients - the SQL details

Summary: there are plenty of ways to count SMS clients - which is the best way? I actually use SQL Server Management Studio more than I use the SMS Administrator...