Query and report all workstations that haven’t rebooted the last 7 days
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 [...]
Category: Config Mgr. Inventory and Reporting, Inventory, Software distribution | 9 Comments
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 each update deployment, with a count of the [...]
Category: Config Mgr. Inventory and Reporting, Software Updates | 6 Comments
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 Builder 1.0 SQL Server Report Builder 2.0 (requires SQL Server 2008) Business [...]
Category: Config Mgr. Inventory and Reporting, SQL Reporting services | 3 Comments
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 in the Configuration Manager Administrator console. Prerequisites SQL Reporting Services requirements Execution account. Windows user [...]
Category: Config Mgr. Inventory and Reporting, SQL Reporting services | 2 Comments
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 Services is installed and configured. Accounts to be created Execution Account (Configured [...]
Category: Config Mgr. Inventory and Reporting | 2 Comments
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.Name AS [MW Name], sw.Description, sw.StartTime, sw.Duration AS ‘Duration Minutes’, sw.IsEnabled AS ‘MW Enabled’, dbo.v_R_System.Name0, dbo.v_R_System.Operating_System_Name_and0 FROM dbo.v_ServiceWindow [...]
Category: Config Mgr. Inventory and Reporting | 1 Comment
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.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 [...]
Category: Config Mgr. Inventory and Reporting | Comment
Query to find computers without .Net Framework 3.5 SP1 installed
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 [...]
Category: Config Mgr. Inventory and Reporting | 2 Comments
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 Windows Components. In Windows 2008 you will find the setting in Computer Management, [...]
Category: Config Mgr. Inventory and Reporting, Tips and tricks | 1 Comment
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 system, server name etc. Once you have created the two [...]
Category: Config Mgr. Inventory and Reporting | 1 Comment
