Creating queries, collections and reports for Window Server 2008 Core in System Center Configuration Manager 2007

Hi folks, my name is Sanman Parvalkar and I’d like to share some information regarding the creation of queries, collections and reports for Window Server 2008 Core in System Center Configuration Manager 2007. System Center Configuration Manager 2007 SP2 allows client installation on Windows Server 2008 Core systems* but it does not differentiate between Windows… Read more

Hotfix: Inaccurate software metering reports are generated on a primary System Center Configuration Manager 2007 SP2 site server

Just a quick note to let you know that we just released a new ConfigMgr 2007 SP2 hotfix that addresses and issue where inaccurate software metering reports are generated on a primary System Center Configuration Manager 2007 SP2 site server: The software metering processor on a primary Microsoft Systems Center Configuration Manager 2007 Service Pack… Read more

New KB: Users may be unable to view and execute the System Center Configuration Manager 2007 reports hosted on SQL Reporting Services

Symptoms Users may be unable to view and execute the System Center Configuration Manager 2007 reports hosted on SQL Reporting Services. Problem 1: Trying to access http://<SQLServerName>/reports returns blank window.  Problem 2: When trying to execute one of the reports you get the following error:  An error has occurred during report processing. (rsProcessingAborted) Cannot create… Read more

Announcing the Release of Configuration Manager 2007 SuperFlows!!

The Configuration Manager writing team is very excited to announce the release of the following Configuration Manager 2007 SuperFlows: Software Updates Synchronization SuperFlow: Provides the detailed dataflow for the software updates synchronization process, additional resources related to software updates synchronization, and troubleshooting information. SuperFlow for Configuring Software Updates: Provides detailed steps that help you to… Read more

Create a Robust, Integrated Reporting Solution with SQL Server Reporting Services and System Center Configuration Manager

With the R2 release of System Center Configuration Manager 2007, the product now supports the use of SQL Reporting Services as a reporting solution.  This is the direction for reporting going forward and it offers a good number of exciting possibilities for building great custom reports.  In the January edition of TechNet magazine, our very… Read more

Report to find last logon details of each computer using ConfigMgr 2007

I get asked about this every once in a while so I thought I would post it here in case it’s something you might find helpful as well.  This report will contain the last login time on a particular computer along with the user who logged in to it as well as some additional details…. Read more

FAQ – SQL Reporting Services Integration with System Center Configuration Manager 2007 R2

In case you missed it, last Thursday Bhaskar Krishnan posted a great FAQ on SQL Reporting Services integration with System Center Configuration Manager 2007 R2 over on the Configuration Manager product team blog.  SQL Reporting Services integration, introduced in Configuration Manager 2007 R2, will replace the existing ASP-based reporting feature this is a great time… Read more

ConfigMgr 2007: The report "Computers that have a metered program installed, but have not run the program since a specified date" does not work correctly with most European locale settings

Here’s an interesting one you may run into if you’re working with any of the European languages.  This is something scheduled to be fixed in an upcoming release but for now you can use one of the workaround below if you encounter it. Issue: The report “Computers that have a metered program installed, but have… Read more

One new Configuration Manager Knowledge Base article for the week ending 03/28/2009

We had one new Knowledge Base article published last week.  This one about a hotfix for System Center Configuration Manager 2007 R2 Client Status Reporting that fixes an issue where it fails with a SQL error.  The link and title is below: KB967491 – Hotfix for System Center Configuration Manager 2007 R2 Client Status Reporting… Read more

Creating Custom Reports By Using Configuration Manager 2007 SQL Views

Yesterday we released a new document to help you create custom reports, determine which Configuration Manager 2007 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be used to join them.  I posted the overview below: ======== Overview Microsoft System… Read more