Category: ConfigMgr

Windows Server Update Services (WSUS) Service Pack 2 is now RTM and so released. It will work with ConfigMgr, and also fully supported.

With the new release also the Windows Update Agent is improved in reliability and improved scan times. Keep in mind that ConfigMgr will not auto-update the agent. You need to deploy the agent with ConfigMgr, the packages can be found here:

http://download.windowsupdate.com/windowsupdate/redist/standalone/7.4.7600.226/windowsupdateagent30-x64.exe

http://download.windowsupdate.com/windowsupdate/redist/standalone/7.4.7600.226/windowsupdateagent30-x86.exe

Other improvements are:

New Windows Server and Client Version Support
Integration with Windows Server® 2008 R2
Support for Windows 7 clients
Support for the BranchCache feature on Windows Server 2008 R2

WSUS Feature Improvements

Reports
New Update and Computer Status reports provide the ability to report on only the updates you’ve approved for installation. You can run these reports from the WSUS console or use the API to incorporate this functionality into your own reports.

Auto-Approval Rules
Auto-approval rules now include the ability to specify the installation deadline date and time for all computers or specific computer groups.
Update Files and Languages
Improved handling of language selection for downstream servers includes a new warning dialog that appears when you decide to download updates only for specified languages.

Easy Upgrade
WSUS 3.0 SP2 can be installed as an in-place upgrade from earlier versions of WSUS and will preserve all of your settings and approvals. The user interface is compatible between WSUS 3.0 SP1 and SP2 on the client and the server.

Software Updates
Stability and reliability fixes for the WSUS server, such as support for IPV6 addresses.
The approval dialog now sorts computer groups alphabetically by group name.
Computer status report sorting icons are now functional in x64 environments.

More information about this release and the download can be found at the Windows Server Update Services 3.0 SP2 Release Notes.

Last week a couple of new hotfixes have been released:

The Task Sequence Media Wizard incorrectly calculates the required space and generates many CD or DVD images if the task sequence references multiple programs in the same package in System Center Configuration Manager 2007
http://support.microsoft.com/?kbid=971689

Some programs are not executed when the "If an application fails, continue installing other applications in the list" option is enabled in System Center Configuration Manager 2007
http://support.microsoft.com/?kbid=970636

Hardware Inventory data files larger than 50MB may fail to process on a ConfigMgr 2007 site server
http://support.microsoft.com/?kbid=973754

Hotfix 970636 is already included in Service Pack 2 for ConfigMgr. For a complete list of all the 76 hotfixes in Service Pack 2 click here.

The title says it all, Configuration Manager goes Unleashed.

In the past several months, I have been working as a contributing author for the System Center Configuration Manager 2007 Unleashed book. I’m proud to announce that the book is now finished and released to the printer.

The book contains 1224 (index included) pages and delivers a deep dive through designing, deployment, setup, features and components. The book covers Configuration Manager 2007 Service Pack 1 and the R2 add-on, and advance information on Service Pack 2 is included.

The lead author of the book is Kerrie Meyler (MVP OpsMgr) which was also the lead author of the famous System Center Operations Manager 2007 Unleashed book and is starting work on an eBook for System Center Operations Manager 2007 R2.
Other coauthors and contributors of the book are Byron Holt, Greg Ramsey, Jason Sandys, Cameron Fuller, Tony Puca, and Pete Zerger. Steve Rachui was the technical reviewer!

You can already pre-order the book through Amazon at http://tinyurl.com/5gtlkg and find additional information at http://configmgr.spaces.live.com. It will be available early August of this year.

I want to thank Kerrie for the opportunity to work with her!

As mentioned earlier in several posts on my blog the R2 add-on for ConfigMgr delivers integration with Microsoft SQL Server Reporting Services 2008 and 2005 (SSRS). This enables administrators and managers to generate built-in or custom reports with relevant data across the entire enterprise.

The top reasons to use SSRS with ConfigMgr are:
- the ability to configure timeouts on a report basis
- the ability to export reports to PDF, Excel etc
- to create custom reports with SQL Report Builder or BI Development Studio
- the ability to easily import and export SSRS reports
- the use to enable report caching
- the use to enable snapshots
- to enable report subscriptions to file-share or e-mail

Reporting site-system roles
By default all (more than 380) built-in reports are installed and stored in the ConfigMgr database. But to be able to run reports a Reporting Point- or Reporting Service Point site-system role needs to be configured.

The Reporting Service Point role is used for integration with SSRS and so only available when you’re running the R2 version of ConfigMgr. When this role is configured and you access all reports from the SSRS window there is no need to install the regular Reporting Point role.

When you want to run the reports from the console you need a Reporting Point which is configured as the default Reporting Point.

Adding the Reporting Service Point role
Perform the following steps in the ConfigMgr console to install the Reporting Service Point role:

1. Navigate to and expand Site Systems located under Site Database / Site Management / sitecode – site name / Site Settings

2. Right-click the appropriate server and from the menu select ‘New roles’. The New Site Roles Wizard will start.

3. In the General screen click Next

4. In the System Role Selection screen select Reporting Service Point and click Next

5. Type a name for the Report Folder and click Next

During the installation of this role ConfigMgr will query WMI to locate SSRS instances. The folder is installed on the first instance SSRS found by ConfigMgr.

6. In the Summary screen click Next

7. When the installation is finished click Close to close the Wizard

Configuring the Reporting Service Point role
When the role is added successfully you can see a new node under Reporting in the console named; Reporting Services with the site system under it. In my example this is server SR002.

After the role is added it needs to be configured with a so called Data Source. The Data Source is in this case the database of ConfigMgr. Perform the following steps from the ConfigMgr console to configure the datasource:

1. In the console navigate and expand Reporting Services located under Site Database / Computer Management / Reporting

2. Right-click the server and select Properties

3. In the server properties dialog box click the Data Source Settings tab

4. In the Server name text box enter the name and SQL Server instance of the server that is hosting the ConfigMgr database

5. In the Database name text box enter the name of the database. Default this is SMS_sitecode

6. To test the connection click the Test button

7. When the test is successful click OK to close the dialog box.

When the test was unsuccessful you probably need to configure authentication settings under the Data Source Authentication tab.

Upload built-in Reports
Now that the role is added and a Data Source is configured we can upload the built-in reports to SSRS to make them available through SSRS.

Perform the following steps from the ConfigMgr console to upload the built-in Reports:

1. In the console navigate and expand Reporting Services located under Site Database / Computer Management / Reporting

2. Right-click the server and select Copy Reports to Reporting Services. The Copy Reports Wizard will start.

3. In the Data Source Settings screen click Next to accept the earlier configured Data Source or provide an additional Data Source and Database name

4. In the Data Source Authentication screen click Next to accept the earlier configured Data Source Authentication settings or provide additional settings

5. In the Select Reports screen check the boxes of the reports which should be uploaded to SSRS. When done click Next

6. In the Security screen click Next to inherit the settings configured on the site system.
If you want to configure other settings uncheck the box ‘Inheriting rights from parent object’

7. In the summary screen verify your settings and click Next

8. The reports will now be uploaded to SSRS, when this is done click Next followed by Close to close the wizard.

Verify Reports in SSRS
After uploading the reports we can check them in SSRS. From your workstation or server browse to the following URL: http://SSRSservername/reports

At the home page of SSRS you will see a link with the name of your report folder. In my case the name is ConfigMgr_PC1, when clicking this link you will see a similar page as displayed below:

As you can see all reports are stored in folders to group them. These same folders are also located in the ConfigMgr console. You can also drag and drop reports in folders. Be aware that when deleting a folder also the reports will be deleted!

But you probably also think; what is that GUID / SSID kind of thing in the upper left corner. Well this is the data source, clicking on it you can configure the source, the connection string and security settings.

Remove that GUID from the page
Many SSRS users don’t like to see the Data Source in the home page of the reporting folder. Therefore this is often hide. To hide the Data Source perform the following steps from your ConfigMgr Report folder home page:

1. At the Report folder page click the Data Source GUID

2. On the Data Source properties page select Hide in List and click Apply

So now it is gone forever! No just kidding when you want to unhide it you can perform the same steps as described above you only need to click Show Details to see it again.

Generating Reports
Reports can now be generated in two very simple ways. One way is to browse in the Report folder through the SSRS homepage.

The other way is to generate the reports right from the ConfigMgr console. To generate a report perform the following steps from the ConfigMgr console:

1. In the console navigate and select All Reports located under Site Database / Computer Management / Reporting / Reporting Services / Report Server

2. In the All Reports folder right-click the report you want to generate and select Run

3. Provide the information required for the report and click View Report

Custom Reports
Although ConfigMgr comes with a lot of built-in reports it might not meet your needs. When this is the case you can build your own custom reports and upload these to SSRS as well.

There are several applications / tools which allows you to build custom reports:
- SQL report builder 2008 2.0
- SQL Server Business Intelligence development studio
- SQL 2005 report builder

In my opinion the integration is great. It delivers a lot of new possibilities and it is very easy to set up. In the next version of ConfigMgr, SSRS is the only option for reporting.

Enjoy!

Well here is the first post right from the MMS in Las Vegas. I just attended a session named ConfigMgr State of the Union with Bill Anderson and Josh Pointer.

The session was focusing on what happened in the past regarding ConfigMgr like the release of Service Pack 1 and the R2 add-on.
Besides the past it was of course also focusing on the future like the release of Service Pack 2 and the next version of ConfigMgr for now named ConfigMgr.Next.

Service Pack 2
So let’s first take another look at Service Pack 2. The beta is planned for release in June and the RTM is scheduled about 90 days post the RTM release of Windows 7.

The main topics the Service Pack will deliver are:

Support for Windows 7 and Windows Server 2008 R2
P2P support for Windows 7 (Branch cache)
Support for USMT version 4.0 for Operating System Deployment
The certificate for Asset Intelligence is no longer required
Intel Active Management Technology (iAMT)
64 bit performance counters to monitor site running on a 64 bit platform with OpsMgr
Muli select and delete functions in the driver catalog

ConfigMgr.Next

In the session we saw a lot of demonstration on the next version of ConfigMgr 2007. It is currently of course still under development so no guarantees about the new stuff mentioned below.

Console
With the new version the console is completely new and no longer based on the MMC.
The console is like you have now with OpsMgr 2007 and has the following main nodes in it:

Administration
Resources (Collections, Users, Computers)
Deployment
Monitoring (Client Status, Client Health, Client Activity where you can also set SLA’s on them.)
Reporting
Software Updates
Site Hierarchy Management

Role Based Access Control
Other improvement is that security is now based on Role Based Access Control. So now more instance and class rights. You can define roles like; Security admin, OSD admin, Software advertiser etc. The roles can be copied and customized to fit your own specific needs.
Part of the role based access control are scopes. You can for instance create a scope for the deployment of a package.

Desired Configuration Management
New feature in DCM is that you can set thresholds. A threshold could be a percentage of compliancy. So or instance that compliancy must be above the 80%. If it is below that threshold it will generate an alert in the console.
Software Updates
A new improvement for Software Updates is the ability to create Auto Deployment Rules. These rules can be used to deploy updates like definition files on a regular basis.

Distribution Points
Couple of new things here as well. On a distribution point you will have the ability to specify schedules and rate limits like you have with a sender. With this you no longer need an extra site on a branch location so you have a more flatter hierarchy which is of course easier to manage.

A distribution group can now be added to a State Based Distribution Group. So you can create groups with DP’s in it. These groups can be used to update packages to an entire group at once and when a new DP is deployment you make this one a member and it will automatically receive all the applied packages.

Requirements
New things on the requirements as well. To implement ConfigMgr.next you need SQL 2008 x64 and Windows Server 2008 x64, x86 is only supported for a branch DP or a file share DP.

With R2 SQL Reporting Services was introduced which will be the only supported reporting platform for the next version of ConfigMgr.

Overall I’m very much excited about the new look, features and requirements. I hope to see more of the next version upcoming days here in Vegas. We keep in touch!