ÿþ// *********************************************************************************

//

//		Created by SMS Export object wizard

//

//		Sunday, January 27, 2008 created

//

//		File Name: SQLInfoReport.MOF

//

// Comments :

//

// This report displays SQL Server installation information based on the custom SQL

// ServerInformation hardware inventory extension. Make sure you base this on a //collection containing computers with SQL Server in Add/Remove programs!

//

// *********************************************************************************





// ***** Class : SMS_Report *****

[SecurityVerbs(140551)]

instance of SMS_Report

{

	Category = "Software - Companies and Products";

	Comment = "This report displays SQL Server installation information based on the custom SQLServerInformation hardware inventory extension.";

	DrillThroughColumns = {};

	GraphCaption = "";

	GraphXCol = 1;

	GraphYCol = 2;

	MachineDetail = FALSE;

	MachineSource = FALSE;

	Name = "SQL Server Information";

	NumPrompts = 0;

	RefreshInterval = 0;

	

	SecurityKey = "";

	SQLQuery = "SELECT     v_GS_SYSTEM.Name0, v_GS_SYSTEM.Domain0, v_GS_SQLSERVERINFORMATION.Version0, v_GS_SQLSERVERINFORMATION.SPLevel0, 
\n                      v_GS_SQLSERVERINFORMATION.SQLEdition0, v_GS_SQLSERVERINFORMATION.LicenseType0, v_GS_SQLSERVERINFORMATION.Licenses0
\nFROM         v_GS_SQLSERVERINFORMATION INNER JOIN
\n                      v_GS_SYSTEM ON v_GS_SQLSERVERINFORMATION.ResourceID = v_GS_SYSTEM.ResourceID";

	StatusMessageDetailSource = FALSE;

	XColLabel = "";

	YColLabel = "";

};

// ***** End *****