As you might know SMS/Configmgr; has some secret files that can change the way agents behave. One of the files is called archive_reports.sms. When you add this file to the inventory temp folder (\system32\ccm\inventory\temp\) it will prevent the inventory xml files from being deleted after they are send to the management point. This can be [...]

With this basic report you will be able to monitor any new applications installed and registrered in Add/Remove programs during the last 7 days on a client computer. 
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,
[...]

I recently got a very good question from a student – how can we check the workstations that haven’t restarted during the last 7 days. The intention is to automatically restart the computers. However not until the end-users have been contacted. For that reason I need to create a report and a query.
The report

The SQL [...]

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

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 SQL Server 2008)
Business [...]

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

SQL Reporting Services requirements

Execution account. Windows user account with [...]

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 to be created

Execution Account (Configured in the [...]

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, sw.Duration AS ‘Duration Minutes’, sw.IsEnabled AS ‘MW Enabled’,                       dbo.v_R_System.Name0, [...]

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.PhysicalHostNameFullyQualified from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner [...]

One of the most asked question in various newsgroups is: How do I create a query that shows all computers without “something”. To create a query like that you start by creating a query that find the opposite and then a query that finds all computers not part of the first result.
Query to all computers [...]