Recently I was asked to provide some SMS web reports for upcoming budget planning sessions. Specifically, managers wanted computer model reports for machine refresh expenditures. I created a few reports, but these two were well-received by managers. Perhaps some of you may find these reports useful. I have included the MOF code for importing. There are two reports supplied here. (The MOF code does not always import correctly so I have provided a link to the file on MyITForum, where I posted the original article 2/5/2007)
http://www.myitforum.com/inc/arts/11649reports.zip// *********************************************************************************
//
// Created by SMS Export object wizard
//
// Friday, February 02, 2007 created
//
// File Name: models_by_selection.MOF
//
// Comments :
//
// Displays workstations of a selected model: (Machine Name, Serial Number, Mfg, Mo
// del, and OS)
//
// *********************************************************************************
// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
Category = "Hardware - General";
Comment = "";
GraphXCol = 1;
GraphYCol = 2;
MachineDetail = FALSE;
MachineSource = FALSE;
Name = "Count Computer Models by Selection (Show All)";
NumPrompts = 1;
RefreshInterval = 0;
ReportParams = {
instance of SMS_ReportParameter
{
AllowEmpty = FALSE;
DefaultValue = "";
PromptText = "Enter Computer Model";
SampleValueSQL = "SELECT DISTINCT Model0 FROM v_GS_COMPUTER_SYSTEM
\nORDER BY Model0";
VariableName = "variable";
}};
SecurityKey = "";
SQLQuery = "SELECT v_R_System.Name0, v_GS_PC_BIOS.SerialNumber0, v_GS_COMPUTER_SYSTEM.Manufacturer0, v_GS_COMPUTER_SYSTEM.Model0,
\n v_R_System.Operating_System_Name_and0
\nFROM v_R_System INNER JOIN
\n v_GS_COMPUTER_SYSTEM ON v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID INNER JOIN
\n v_GS_PC_BIOS ON v_R_System.ResourceID = v_GS_PC_BIOS.ResourceID
\nWHERE (v_GS_COMPUTER_SYSTEM.Model0 = @variable)
\nORDER BY v_R_System.Name0";
StatusMessageDetailSource = FALSE;
};
// ***** End *****
// *********************************************************************************
//
// Created by SMS Export object wizard
//
// Friday, February 02, 2007 created
//
// File Name: models_by_ADSite.MOF
//
// Comments :
//
// Displays a summary count of all computer models in a particular Site. (selected
// by AD Site)
//
// *********************************************************************************
// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
Category = "Hardware - General";
Comment = "";
GraphCaption = "";
GraphType = 0;
GraphXCol = 2;
GraphYCol = 3;
MachineDetail = FALSE;
MachineSource = FALSE;
Name = "Count Computer Models by Site (AD Boundaries Only)";
NumPrompts = 1;
RefreshInterval = 0;
ReportParams = {
instance of SMS_ReportParameter
{
AllowEmpty = FALSE;
DefaultValue = "";
PromptText = "Enter Site Name";
SampleValueSQL = "SELECT SiteCode, v_Site.SiteName FROM v_Site";
VariableName = "variable";
}};
SecurityKey = "";
SQLQuery = "SELECT v_SiteBoundary_ADSite.SiteCode, v_GS_COMPUTER_SYSTEM.Model0, COUNT(DISTINCT v_GS_COMPUTER_SYSTEM.ResourceID) AS Count
\nFROM v_GS_COMPUTER_SYSTEM INNER JOIN
\n v_R_System ON v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID INNER JOIN
\n v_SiteBoundary_ADSite ON v_R_System.AD_Site_Name0 = v_SiteBoundary_ADSite.ADSiteName
\nWHERE (v_SiteBoundary_ADSite.SiteCode LIKE @variable)
\nGROUP BY v_SiteBoundary_ADSite.SiteCode, v_GS_COMPUTER_SYSTEM.Model0";
StatusMessageDetailSource = FALSE;
XColLabel = "";
YColLabel = "";
};
// ***** End *****
Labels: SMS 2003 - Reports