// ********************************************************************************* // // Created by SMS Export object wizard // // Thursday, October 07, 2010 created // // File Name: colandadv.mof // // Comments : // // // ********************************************************************************* // ***** 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, as well as each advertisement assigned to those collections while also including the last known status time from the targeted machine."; GraphCaption = ""; GraphXCol = 1; GraphYCol = 2; MachineDetail = FALSE; MachineSource = FALSE; Name = "All collections and advertisements for a specific 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\", adv.advertisementname as \"Advertisement name\", adv.advertisementID as \"Advertisement ID\" \nFROM v_R_System SYS \nJOIN v_FullCollectionMembership FCM on SYS.ResourceID = FCM.ResourceID \nLEFT JOIN v_Collection COL on FCM.CollectionID=COL.CollectionID \nJoin v_Advertisement adv on COL.collectionID=adv.CollectionID \nWHERE \nSYS.Netbios_Name0 = @computername"; StatusMessageDetailSource = FALSE; UnicodeData = FALSE; XColLabel = ""; YColLabel = ""; }; // ***** End *****