// ********************************************************************************* // // Created by SMS Export object wizard // // den 19 januari 2012 created // // File Name: Patch_complilance_report.MOF // // Comments : // // This report will give you the status(failed,installed,reboot pending etc) of giv // en KB numbers. this report is created by eswar koneti www.eskonr.com // // ********************************************************************************* // ***** Class : SMS_Report ***** [SecurityVerbs(140551)] instance of SMS_Report { Category = "SMS Operations"; Comment = ""; GraphCaption = ""; GraphXCol = 1; GraphYCol = 2; MachineDetail = FALSE; MachineSource = FALSE; Name = "patch report"; NumPrompts = 0; RefreshInterval = 0; ReportGUID = "{78636723-CACA-4434-9502-854048ACDEA8}"; SecurityKey = ""; SQLQuery = "select summ.ID,summ.QNumbers as 'Q Number', \nCOUNT(distinct ps.ResourceID) as 'Requested', \nCOUNT(distinct case when ps.LastState=107 or ps.laststate=102 or ps.laststate=105 then ps.ResourceID else NULL End) as 'Installed', \nROUND(100.0*COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or ps.laststate=105 then ps.ResourceID else NULL End) \n/count(distinct ps.ResourceID),2) as 'Success %' \nfrom v_GS_PatchStatusEx ps \njoin v_ApplicableUpdatesSummaryEx summ on \n ps.UpdateID=summ.UpdateID \n where (summ.ID='MS11-075') and \n (summ.Type='Microsoft Update') \ngroup by summ.ID,summ.QNumbers \n \norder by summ.ID"; StatusMessageDetailSource = FALSE; UnicodeData = FALSE; XColLabel = ""; YColLabel = ""; }; // ***** End *****