Software Management Group

 View Only
  • 1.  Reporting - Installed Software, Need help to modify and meet requirements

    Posted Aug 07, 2013 01:34 PM

    I am tasked to come up with a report that will show aggregate count of software installed and then drilling down for details on which machines it is installed in.

    The out of the box report called Reports>Discovery adn Inventory>Cross-platform>Software/application>Software>"Installed Software" is great, I was planning to use it as the base report for modification. 

     

    Here are the requirements handed to me:

    1) Report by site - I was thinking of using the site filter under AD filters.  This will require adding a dropdown or field for filter in the report

    2) This one is hard to explain.  The out of the box report has a name field, so lets say I would like to report on Visio, I cant put %Visio% and it will result in all kinds of software that includes Visio.  Now I try to be more specific by searching for '%Microsoft Visio%' the result for this report will then not include '%Office Visio%'. Microsoft's naming convention for different version is not consistent. 

    I tried adding another field for a second name search so that It can included all keyword fields in report, but with no luck.

     

    SQL, reporting gurus please help!

     



  • 2.  RE: Reporting - Installed Software, Need help to modify and meet requirements

    Trusted Advisor
    Posted Aug 08, 2013 10:17 AM

    I'm not any good with the built-in Reports and especially the drill-downs but for your second point you can do something like this:

    LIKE 'Microsoft%Visio%' and that should include "Microsoft Visio" and "Microsoft Office Visio".



  • 3.  RE: Reporting - Installed Software, Need help to modify and meet requirements

    Posted Aug 09, 2013 04:16 PM

    Have you looked at IT Analytics for this?  I think you might be able to create a report that is based on site.



  • 4.  RE: Reporting - Installed Software, Need help to modify and meet requirements

    Posted Aug 20, 2013 12:37 PM

    Im going to investigate IT analystics. 



  • 5.  RE: Reporting - Installed Software, Need help to modify and meet requirements

    Broadcom Employee
    Posted Aug 20, 2013 02:34 PM

    I just created a quick pivot table view in the Installed Software cube within IT Analytics and came up with the following:

     

     

    ITA3.png

    Note that I just have 'Organizational Group' as a filter towards the top and you can select any group to change the result set. You can also filter on any dimension in the cube, so I can easily select just the Visio titles I care about out of 'Add/Remove Programs - Display Name' depending on how they are reported by Microsoft:

    ITA2.png

    If you're interested in using IT Analytics, there is a bunch of great conent on Connect to walk you thorugh the install and configuration:

    Hope that helps!