Browse by Tags

SQL reporting services allow null values in the prompt

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...

Published 06-29-2010 9:09 by Kent Agerlund

Filed under: Reporting, SQL Reporting Services, Tips & Tricks

System Center Configuration Manager 2007 Dashboard available for download

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...

Published 04-09-2010 17:39 by Ronni Pedersen

Filed under: Reporting, SQL Reporting Services, Configuration Manager, ConfigMgr, Dashboard

SQL Reporting Services and antivirus settings

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...

Published 03-23-2010 11:15 by Kent Agerlund

Filed under: Reporting, Troubleshooting, SQL Reporting Services

Software installed the last 7 days

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...

Published 10-29-2009 17:57 by Kent Agerlund

Filed under: Inventory, Reporting, Configuration Manager, ConfigMgr

How to get registry information into hardware inventory

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...

Published 10-21-2009 15:11 by Kent Agerlund

Filed under: Inventory, Reporting, Queries

Report all workstations that haven’t rebooted the last 7 days

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...

Published 10-02-2009 12:51 by Kent Agerlund

Filed under: Inventory, Reporting

Status report for Software Update deployments

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...

Published 09-18-2009 20:16 by Kent Agerlund

Filed under: Reporting, Software Updates

Creating a basic Config mgr. report with SQL reporting services

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...

Published 08-18-2009 13:56 by Kent Agerlund

Filed under: Reporting, SQL Reporting Services

Configuring SQL Reportings Services mail subscriptions with Configuration Manager

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...

Published 08-18-2009 9:18 by Kent Agerlund

Filed under: Reporting, SQL Reporting Services

Configuring SQL Reporting Services user permission for Configuration Manager 2007

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...

Published 08-13-2009 21:32 by Kent Agerlund

Filed under: Reporting, SQL Reporting Services

Creating Configuration Manager 2007 Reports - 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...

Published 08-03-2009 15:05 by Kent Agerlund

Filed under: Reporting

Config Mgr prompting for credentials when running report

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...

Published 07-09-2009 21:34 by Kent Agerlund

Filed under: Reporting

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...

Published 07-09-2009 21:28 by Kent Agerlund

Filed under: Inventory, Reporting

Configuration Manager – Find virtual machines

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...

Published 07-09-2009 21:18 by Kent Agerlund

Filed under: Inventory, Reporting, Queries

Config. Mgr Report – List all Maintenance windows

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...

Published 07-09-2009 21:11 by Kent Agerlund

Filed under: Inventory, Reporting

Visitor locations

Syndication

Recent Posts

Archives

Tags

SQL reporting services allow null values in the prompt

System Center Configuration Manager 2007 Dashboard available for download

SQL Reporting Services and antivirus settings

Software installed the last 7 days

How to get registry information into hardware inventory

Report all workstations that haven’t rebooted the last 7 days

Status report for Software Update deployments

Creating a basic Config mgr. report with SQL reporting services

Configuring SQL Reportings Services mail subscriptions with Configuration Manager

Configuring SQL Reporting Services user permission for Configuration Manager 2007

Creating Configuration Manager 2007 Reports - Using Prompt

Config Mgr prompting for credentials when running report

Config mgr report count x86 and x64 operating systems

Configuration Manager – Find virtual machines

Config. Mgr Report – List all Maintenance windows