Client Management Suite

 View Only
  • 1.  Unhiding a Hidden Report "Vulnerable Microsoft Updates by Computer"

    Posted May 26, 2010 08:46 AM
    Dear All,

    I have created a report that displays information about Patches and Vulnerability of machines. In the report, the results are driven by two parameters which specify two collections (the patches displayed are only for machines in both collections).

    In the original report that I am basing this upon, it has just ONE collection and the report outputs a "_Collection" parameter to the "Vulnerable Microsoft Updates by Computer" hidden report (I cannot find it ANYWHERE).

    I need to Unhide the  "Vulnerable Microsoft Updates by Computer" or get a copy of the report, so that I can then edit it and include my second collection.

    Can anyone help me with this?

    Thanks in advance.

    Kindest Regards,


    QuietLeni


  • 2.  RE: Unhiding a Hidden Report "Vulnerable Microsoft Updates by Computer"
    Best Answer

    Posted May 26, 2010 10:51 AM

    Leni,
    This report has an "Attributes" value of 19 in the database, which equates to "Hidden, Read-Only":
    http://YOURNS/Altiris/NS/Console.aspx?view=properties&ItemGuid=9A8E7969-5829-40DD-8D07-FD210C736686&ConsoleGuid={3faa8b67-250b-42ad-8186-fe2f49a9e707}
    To unhide the report, run the following SQL:


    UPDATE Item
    SET Attributes = 18
    WHERE Guid = '9a8e7969-5829-40dd-8d07-fd210c736686'

    The report should then be visible in the Compliance and Vulnerability folder under Patch reports.  Interestingly, this report actually contains the raw SQL code within it, rather than calling a stored procedure as most of the other Patch reports do.



  • 3.  RE: Unhiding a Hidden Report "Vulnerable Microsoft Updates by Computer"

    Posted May 26, 2010 11:26 AM
    1. Run the drill down report then select the left hand "Access right click menu for this item" buttom from the toolbar at the top of the report.
    2. Select "Export".
    3. Create a folder under Patch Reports called something like "Hidden Reports" and import the XML; select "OK" at the warning.
    4. It will be unhidden in the new folder and you can clone it and edit the cloned copy.
    5. Edit the drilldown in top level report the call the clone, not the original



  • 4.  RE: Unhiding a Hidden Report "Vulnerable Microsoft Updates by Computer"

    Posted May 26, 2010 06:37 PM
    That works too, but could be problematic if that report is updated by a hotfix, etc (though I suppose the same could be said for my method).  If the goal is to get at the underlying code, either method will work.


  • 5.  RE: Unhiding a Hidden Report "Vulnerable Microsoft Updates by Computer"

    Posted May 27, 2010 08:37 AM
    Yes, that works, Kyle.

    Thanks for the help.
    By the way, that should be useful for other hidden reports...!

    Regards,


    QuietLeni