Config mgr report count x86 and x64 operating systems
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 [...]
Category: Config Mgr. Inventory and Reporting | 1 Comment
Creating Configuration Manager 2007 Reports – Part IV Using Prompt
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 [...]
Category: Config Mgr. Inventory and Reporting | 2 Comments
Useful Software Metering Rules
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 Filename Vendor Visio [...]
Category: Config Mgr. Inventory and Reporting | Comment
Creating Configuration Manager 2007 Reports – Part III Using Count
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. [...]
Category: Config Mgr. Inventory and Reporting | 1 Comment
Creating Configuration Manager 2007 Reports – Part II Creating the first report
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 [...]
Category: Config Mgr. Inventory and Reporting | 5 Comments
Creating Configuration Manager 2007 Reports – Part I the basics
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 [...]
Category: Config Mgr. Inventory and Reporting | Comment
