Patch Management Solution

 View Only
  • 1.  Is there a way to run Patch Management Compliance Reports in SSMS?

    Posted Aug 25, 2014 12:21 PM

    I need full acess to the compliance reports outside of the altiris console for more advanced reporting purposes. I want to run (copies of) them in Sql Server Management Studio and make adjustments where needed. Do I have to attempt reverse engineering the console reports or has someone already done it and can provide the sql for me?

     



  • 2.  RE: Is there a way to run Patch Management Compliance Reports in SSMS?

    Posted Aug 25, 2014 09:36 PM

    The Patch Compliance Reports are stored procedures.

    Just simple run the stored procedures with the applicable parameters...

    as shown below within SQL Mgmt Studio from your CMDB

     

    PM StoreProcedure_0.png



  • 3.  RE: Is there a way to run Patch Management Compliance Reports in SSMS?

    Posted Aug 26, 2014 12:38 PM

    WDRAIN1, your screen shot is a bit of an eye chart.  Is it possible for you to paste the contents of the SQL query directly into this thread?  Thanks!



  • 4.  RE: Is there a way to run Patch Management Compliance Reports in SSMS?

    Broadcom Employee
    Posted Aug 26, 2014 01:40 PM

    You can clone any of existing default reports via mouse right click menu on report, within SMP Console ⇒ open cloned report and click "edit" ⇒ now you can see what sql query is there, with what parameters, etc.



  • 5.  RE: Is there a way to run Patch Management Compliance Reports in SSMS?

    Broadcom Employee
    Posted Aug 26, 2014 01:54 PM

    And here is another thread where is shown, how to catch required GUID(s) via Altiris Profiler during report data refresh on SMP Console



  • 6.  RE: Is there a way to run Patch Management Compliance Reports in SSMS?

    Posted Oct 16, 2014 01:13 PM