mreavis
Posts: 767
Score: 77
Joined: 9/10/2002
From: Olathe, Kansas
Status: offline
|
save the text below as a mof and import on your site server, I also included a zip of my mof, not sure which will come through.
// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
Category = "Department Reports";
Comment = "Displays a summary of all computers in a collection with specific software registered in Add Remove Programs.
\nPlease click the Values button, and scroll down to your department collection.";
DrillThroughColumns = {};
GraphCaption = "";
GraphXCol = 1;
GraphYCol = 2;
MachineDetail = FALSE;
MachineSource = FALSE;
Name = "Computers with specific software registered in Add Remove Programs - Collection Based";
NumPrompts = 2;
RefreshInterval = 0;
ReportParams = {
instance of SMS_ReportParameter
{
AllowEmpty = FALSE;
DefaultValue = "";
PromptText = "Software Title";
SampleValueSQL = "begin
\n if (@__filterwildcard = '')
\n Select DISTINCT DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS order by DisplayName0
\n else
\n Select DISTINCT DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS
\n WHERE DisplayName0 like @__filterwildcard
\n order by DisplayName0
\nend";
VariableName = "displayname";
},
instance of SMS_ReportParameter
{
AllowEmpty = FALSE;
DefaultValue = "";
PromptText = "Enter Collection ID";
SampleValueSQL = "begin
\n if (@__filterwildcard = '')
\n select CollectionID, Name from v_Collection order by Name
\n else
\n select CollectionID, Name from v_Collection
\n WHERE CollectionID like @__filterwildcard
\n order by Name
\nend";
VariableName = "CollID";
}};
SecurityKey = "";
SQLQuery = "Select sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0, arp.Version0
\nFROM v_R_System sys
\nJOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID
\nJOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
\nWHERE DisplayName0 = @displayname and fcm.CollectionID=@CollID";
StatusMessageDetailSource = FALSE;
XColLabel = "";
YColLabel = "";
};
// ***** End *****
 Attachment (1)
_____________________________
Michael Reavis
SMS Admin
MCSE, MCDBA, MCDST
Johnson County Goverment
|
Printable Version
Add/Remove Programs Report by Collection - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread