// ********************************************************************************* // // Created by SMS Export object wizard // // Friday, August 27, 2010 created // // File Name: Collectionreport.mof // // Comments : // // This report will prompt for a computer name, and output the the collection names // and ID's for all collections the computer is assigned to. // // ********************************************************************************* // ***** Class : SMS_Report ***** [SecurityVerbs(140551)] instance of SMS_Report { Category = "SMS Site - Client Information"; Comment = "Prompts for a computer name and outputs each collection that the computer is assigned to."; GraphCaption = ""; GraphXCol = 1; GraphYCol = 2; MachineDetail = FALSE; MachineSource = FALSE; Name = "All collections for a given computer"; NumPrompts = 1; RefreshInterval = 0; ReportGUID = "{E472866C-7C0C-4E25-AE32-2F3C282FE206}"; ReportParams = { instance of SMS_ReportParameter { AllowEmpty = FALSE; DefaultValue = ""; PromptText = "Enter your desired computer name here"; SampleValueSQL = "begin \n if (@__filterwildcard = '') \n SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.Client0=1 ORDER By SYS.Netbios_Name0 \n else \n SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.Client0=1 \n and SYS.Netbios_Name0 like @__filterwildcard \n ORDER By SYS.Netbios_Name0 \nend"; VariableName = "Computername"; }}; SecurityKey = ""; SQLQuery = "SELECT COL.Name as \"Collection name\", FCM.CollectionID as \"Collection ID\", SYS.Netbios_Name0 as \"Computer Name\" \nFROM v_R_System SYS \nJOIN v_FullCollectionMembership FCM on SYS.ResourceID = FCM.ResourceID \nLEFT JOIN v_Collection COL on FCM.CollectionID=COL.CollectionID \nWHERE \nSYS.Netbios_Name0 = @computername"; StatusMessageDetailSource = FALSE; UnicodeData = FALSE; XColLabel = ""; YColLabel = ""; }; // ***** End *****