One of the most asked question in various newsgroups is: How do I create a query that shows all computers without “something”. To create a query like that you start by creating a query that find the opposite and then a query that finds all computers not part of the first result.
Query to all computers [...]

This is really a top annoying problem, the constant prompt for credentials each time you open a report. All you need to do is disable the Internet Explorer Enhanced security on the reporting server. This is done by running Add/Remove programs, Add/Remove Windows Components. In Windows 2008 you will find the setting in Computer Management, [...]

In this post you will find the code for two reports. The first is a simple report that will count the different system types (x86 etc). The second report can be used as a standard hardware inventory report listing the most basic information like operating system, server name etc. Once you have created the two [...]

In this example I explain how to use the prompt function. I anticipate that you already by now know how to create the report in Configuration Manager and how to start SQL Server Management Studio. This report will list some basic hardware details with a prompt on the Bios Serial number. I am creating the [...]

One way to ensure a really fast ROI with Configuration Manager is usage of Software Metering. Creating the rules is a simple process but gathering the exe names of the software packages can be time consuming. To save you some time I have added some of the most commonly used products.

Application
[...]

In this example I explain how to use the Count function. I anticipate that you already by now know how to create the report in Configuration Manager and how to start SQL Server Management Studio. This report will group all computer objects by Vendor and Model with a count of each unique model.
 

I’ve started SQL [...]

In this part I will walk you through the creation of a report in SQL Server Managmenet Studio. The report will show all clients with SMS 2003 Toolkit installed.

Open SQL Server Management Studio and log on to the server.

Navigate to the Configuration Manager database. The name is most likely SMS_<Sitecode>.

Right click Views and select New [...]

I often hear customers and students complaining about the complexity of creating reports. Statements like; “the database is a mystery” and “I am not a SQL expert. I agree, the database can be a mystery. But using the proper tools and some very basic SQL skills you will be able to create powerful reports.
I will [...]