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

//

//		Created by SMS Export object wizard

//

//		Friday, April 03, 2009 created

//

//		File Name: All collections for a specific computer (custom).mof

//

// Comments :

//

//

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





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

[SecurityVerbs(140551)]

instance of SMS_Report

{

	Category = "Software Distribution - Collections";

	Comment = "";

	GraphXCol = 1;

	GraphYCol = 2;

	MachineDetail = FALSE;

	MachineSource = FALSE;

	Name = "All collections for a specific computer (custom)";

	NumPrompts = 1;

	RefreshInterval = 0;

	

	ReportParams = {

instance of SMS_ReportParameter

{

	AllowEmpty = FALSE;

	DefaultValue = "";

	PromptText = "Enter computer name";

	VariableName = "name";

}};

	SecurityKey = "";

	SQLQuery = "SELECT\t\tfcm.Name, 
\n\t\tcol.Name, 
\n\t\tadv.AdvertisementName, 
\n\t\tcol.CollectionID
\n
\nFROM\t\tv_Collection col JOIN 
\n\t\tv_FullCollectionMembership fcm ON col.CollectionID=fcm.CollectionID LEFT JOIN 
\n\t\tv_Advertisement adv ON col.CollectionID=adv.CollectionID
\n
\nWHERE\t\tfcm.Name LIKE @name
\nORDER BY\tcol.Name";

	StatusMessageDetailSource = FALSE;

};

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