Client Management Suite

 View Only
  • 1.  MS Security update Policy Execution

    Posted Apr 24, 2012 08:37 AM

    Hi All,

    Can i get a report for the MS Security update Policy Execution status against all my targeted machines in Patch Management Solution 7.1 SP1.

     

    Thanks in Advance.

     

     



  • 2.  RE: MS Security update Policy Execution

    Posted Apr 24, 2012 09:51 PM

    Reports > All Reports, then expand Reports > Software > Patch Management >

    You have Compliance Summary within Compliance, and the Windows Compliance by.. reports as well within this folder.

    The Diagnostics folder contains Software Update Plug-in rollout status and Windows System Assessment (Vulnerability) Scan Summaries.

    You can find a Restart Status report for pending reboots and a Windows Software Update Delivery Details report which shows installation status by bulletin and update in the Remediation Status report.  

    The Software Bulletins report in the Software Bulletins folder may also be of assistance to you.

    Does this answer your question?



  • 3.  RE: MS Security update Policy Execution

    Posted Apr 25, 2012 07:49 AM

    I am well aware about these reports in fact we are using the same reports for our reporting but I am concern about the report for the Software Update Policy execution status like Software Delivery execution status.

     

    Thanks

     

     



  • 4.  RE: MS Security update Policy Execution

    Posted Apr 25, 2012 08:06 AM

    Is it possible to get a report for the machines for the download status of the security updates against a security update policy.

     

    Thanks



  • 5.  RE: MS Security update Policy Execution

    Posted May 01, 2012 05:58 AM

    Hello Friends,

    Any idea or finding for the above mentioned report?

     

    Thanks in advance!

     



  • 6.  RE: MS Security update Policy Execution

    Posted May 04, 2012 11:56 AM

    I am not sure I understand what you are looking for. Are you looking for a report that will report which machines have downloaded the package for the update for a perticular policy? I.E you want to see which machines have downloaded the package for MS12-013 and have the policy named MS12-013 assigned to it?



  • 7.  RE: MS Security update Policy Execution

    Posted May 07, 2012 03:57 AM

    Yes Sean.B,

     

    I am exactly looking for  a same kind of report.

     

    Thanks,

     

     



  • 8.  RE: MS Security update Policy Execution

    Posted May 31, 2012 09:26 AM

    Perhaps this data would be included in TaskInstances for you.

     

    You could use something like this to find the task name (it will have Download in the name):

    select max(i.name) as Name,TaskVersionGuid, count(*) As count from taskinstances ti
    left join itemversions iv
    on ti.TaskVersionguid = iv.Versionguid
    left join item i
    on iv.Itemguid = i.guid
    join Taskinstanceresults tir
    on tir.TaskInstanceGuid = ti.TaskInstanceGuid
    where tir.endtime > getdate() -7
    group by TaskVersionGuid
    order by count DESC
     
    Then after identifying the TaskVersionGuid, use a query like the one below (with the correct GUID) to see who is on the list:
    SELECT vc.Name,COUNT(ti.TaskVersionGuid) as 'Count' 
    FROM vComputer vc
    LEFT JOIN TaskInstances ti ON ti.ResourceGuid=vc.[Guid]
    WHERE ti.TaskVersionGuid='D35591E5-F33D-4BB8-8BA9-616E25A067AD' OR ti.TaskVersionGuid IS NULL
    GROUP BY vc.Name
     
    Keep in mind that you keep only 200,000 rows of task history by default, so this method may break down after a few days if your clients have already downloaded the patch a week or two ago.

     



  • 9.  RE: MS Security update Policy Execution

    Posted Jun 19, 2012 04:47 PM

    Good information McLemson.

    Can it be modified to report:

    Who submitted the Task (The account name that has submitted, when dealing with several administrators doing patches), When was it submitted, Success or Failure ...

    Or any other improvements to the original SQL code?

    Thanks,

     

    V