// *********************************************************************************
//
//		Created by SMS Export object wizard
//
//		Monday, March 21, 2005 created
//
//		File Name: wakeonlan.MOF
//
// Comments :
//
//
// *********************************************************************************


// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
	Category = "Wake on LAN";
	Comment = "";
	DrillThroughColumns = {};
	GraphCaption = "";
	GraphXCol = 1;
	GraphYCol = 2;
	MachineDetail = FALSE;
	MachineSource = FALSE;
	Name = "Computers with a 3COM 3C920 NIC";
	NumPrompts = 1;
	RefreshInterval = 0;
	
	ReportParams = {
instance of SMS_ReportParameter
{
	AllowEmpty = FALSE;
	DefaultValue = "";
	PromptText = "Select a Collection Name";
	SampleValueSQL = "begin
\n if (@__filterwildcard = '')
\n  SELECT DISTINCT CollectionID, Name FROM v_Collection ORDER BY Name
\n else
\n  SELECT DISTINCT CollectionID, Name FROM v_Collection
\n  WHERE Name like @__filterwildcard
\n  ORDER BY Name
\nend";
	VariableName = "ID";
}};
	SecurityKey = "";
	SQLQuery = "SELECT DISTINCT dbo.v_R_System.Name0, dbo.v_GS_NETWORK_ADAPTER.Name0 AS NetworkCard
\nFROM         dbo.v_FullCollectionMembership INNER JOIN
\n                      dbo.v_GS_NETWORK_ADAPTER ON dbo.v_FullCollectionMembership.ResourceID = dbo.v_GS_NETWORK_ADAPTER.ResourceID INNER JOIN
\n                      dbo.v_R_System ON dbo.v_GS_NETWORK_ADAPTER.ResourceID = dbo.v_R_System.ResourceID
\nWHERE     (dbo.v_GS_NETWORK_ADAPTER.Name0 LIKE '3COM 3C920%')
\nAND v_FullCollectionMembership.CollectionID = @ID";
	StatusMessageDetailSource = FALSE;
	XColLabel = "";
	YColLabel = "";
};
// ***** End *****


// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
	Category = "Wake on LAN";
	Comment = "";
	DrillThroughColumns = {};
	GraphCaption = "";
	GraphXCol = 1;
	GraphYCol = 2;
	MachineDetail = FALSE;
	MachineSource = FALSE;
	Name = "DELL Computers that Support Remote BIOS Configuration";
	NumPrompts = 1;
	RefreshInterval = 0;
	
	ReportParams = {
instance of SMS_ReportParameter
{
	AllowEmpty = FALSE;
	DefaultValue = "";
	PromptText = "Select a Collection";
	SampleValueSQL = "begin
\n if (@__filterwildcard = '')
\n  SELECT DISTINCT CollectionID, Name FROM v_Collection ORDER BY Name
\n else
\n  SELECT DISTINCT CollectionID, Name FROM v_Collection
\n  WHERE Name like @__filterwildcard
\n  ORDER BY Name
\nend";
	VariableName = "ID";
}};
	SecurityKey = "";
	SQLQuery = "SELECT     dbo.v_R_System.Name0, dbo.v_R_System.Resource_Domain_OR_Workgr0, dbo.v_R_System.Client0
\nFROM         dbo.v_R_System INNER JOIN
\n                      dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN
\n                      dbo.v_FullCollectionMembership ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_FullCollectionMembership.ResourceID
\nWHERE     (dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 = 'Dell Computer Corporation') AND (dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX150' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX50' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX60' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX400' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX240' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX260' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX270' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex SX260' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex SX270' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX280' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex SX280' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C600' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C800' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C500' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C610' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C810' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C400' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C840' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C510' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude L400' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude X200' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C540' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude D600' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude D800' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude D500' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude D400' OR
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude X300') AND (dbo.v_R_System.Client0 = 1) AND (dbo.v_R_System.Obsolete0 = 0)
\nAND v_FullCollectionMembership.CollectionID = @ID";
	StatusMessageDetailSource = FALSE;
	XColLabel = "";
	YColLabel = "";
};
// ***** End *****


// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
	Category = "Wake on LAN";
	Comment = "";
	DrillThroughColumns = {};
	GraphCaption = "";
	GraphXCol = 1;
	GraphYCol = 2;
	MachineDetail = FALSE;
	MachineSource = FALSE;
	Name = "DELL Computers that DO NOT Support Remote BIOS Configuration";
	NumPrompts = 1;
	RefreshInterval = 0;
	
	ReportParams = {
instance of SMS_ReportParameter
{
	AllowEmpty = FALSE;
	DefaultValue = "";
	PromptText = "Select a Collection";
	SampleValueSQL = "begin
\n if (@__filterwildcard = '')
\n  SELECT DISTINCT CollectionID, Name FROM v_Collection ORDER BY Name
\n else
\n  SELECT DISTINCT CollectionID, Name FROM v_Collection
\n  WHERE Name like @__filterwildcard
\n  ORDER BY Name
\nend";
	VariableName = "ID";
}};
	SecurityKey = "";
	SQLQuery = "SELECT DISTINCT dbo.v_R_System.Name0, dbo.v_R_System.Resource_Domain_OR_Workgr0, dbo.v_R_System.Client0
\nFROM         dbo.v_R_System INNER JOIN
\n                      dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN
\n                      dbo.v_FullCollectionMembership ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_FullCollectionMembership.ResourceID
\nWHERE     (dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 = 'Dell Computer Corporation') AND (dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex GX150' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex GX50' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex GX60' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex GX400' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex GX240' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex GX260' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex GX270' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex SX260' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex SX270' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex GX280' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'OptiPlex SX280' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C600' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C800' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C500' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C610' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C810' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C400' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C840' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C510' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude L400' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude X200' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude C540' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude D600' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude D800' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude D500' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude D400' AND
\n                      dbo.v_GS_COMPUTER_SYSTEM.Model0 <> 'Latitude X300') 
\nAND v_FullCollectionMembership.CollectionID = @ID";
	StatusMessageDetailSource = FALSE;
	XColLabel = "";
	YColLabel = "";
};
// ***** End *****