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...
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, DATEDIFF ( Day , CONVERT (date,dbo.v_GS_ADD_REMOVE_PROGRAMS...
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 yet part of WMI on the client. This post will guide...
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.Name0, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0...
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...
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...
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,...
Accindently deleting computer objects in the Config Mgr. console has happened in the past and it will most likely happen again in the future. This post will hopefully help you understand what’s going on in the background and how Configuration Manager recovers the deleted objects. Components involved...