-
This report will list all software registrered in Add/Remove programs and installed during the last 7 days. The SQL code SELECT TOP (100) PERCENT dbo.v_R_System.Name0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, DATEDIFF(Day, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0...
-
When the hardware inventory agent is running it’s looking after values in the local WMI database on the client. By default WMI contains much valuable information that is “easy” to collect. But from time to time we need to gather information that’s not yet part of WMI on the client. This post will guide...
-
This report will list all workstations (XP, Vista and Windows 7) that hasn’t restarted the last 7 days. The report The SQL statement Create a new empty report and copy this SQL code into the SQL statement box: SELECT TOP ( 100 ) PERCENT dbo.v_R_System.Name0, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0...
-
Spending some time in other communities often gives me a lot of good ideas to reports and queries. A little while ago in the System Center Technet community I stumbled over a very need report created by a user called Qu4rk. His report shows a status of each update deployment, with a count of the each...
-
Converting the Configuration manager ASP reports to SRS reports (SQL Reporting Services) is a really easy task. Once you want to modify or create new the reports you need to a little more work. I create reports using these applications. SQL Server Report Builder 1.0 SQL Server Report Builder 2.0 (requires...
-
In this post I’ll describe how you configure mail subscriptions with Configuration Manager 2007 R2. I assume that SQL Reporting Services is installed and configured on a remote database. I also assume that the Reporting Services Site system is configured in the Configuration Manager Administrator console...
-
Using SQL Reporting Services is really a “blast”. If you want to use the reporting feature with Configuration Manager 2007 R2 (and you do!), you need to configure a few accounts, groups and configure permissions. In this post I assume that SQL Reporting Services is installed and configured. Accounts...
-
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...
-
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...
-
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...
-
Keeping track of the the virtual machines can be a little pain. Here is a query and a report that hopefully will make it a bit easier to keep track of those virtual machines and their corresponding physical hosts. The Query select distinct SMS_R_System.Name, SMS_G_System_OPERATING_SYSTEM.Caption, SMS_G_System_VIRTUAL_MACHINE...
-
Configuration Manager ships with a built-in report showing maintenance windows for a single computer. I have just done a few modifications to that report (added a few columns and removed the prompt). SELECT TOP (100) PERCENT sw.Name AS [MW Name], sw.Description, sw.StartTime,...