-
Like most of you I have been converting classic Configuration Manager reports to SQL reporting services. For most reports it works right out of the box. But for some reports you need to do a little tweaking in the SQL statement or in the report properties. An example of this is the Client Status report...
-
Microsoft System Center Configuration Manager 2007 Dashboard lets customers track application and operating system deployments, security updates, the health status, and IT compliance with key regulations—with an easy to use, customizable Web interface. Because the Dashboard is built on Windows SharePoint...
-
Just installed and configured SQL Reporting Services 2008 with ConfigMgr. 2007 R2 SP2 this morning. Everything went smoothly except for one minor detail; I got an error in my mail subscription: Failure sending mail: The message could not be sent to the SMTP server. The transport error code was 0x800ccc15...
-
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 , CONVERT (date,dbo.v_GS_ADD_REMOVE_PROGRAMS...
-
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,...