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