/build/static/layout/Breadcrumb_cap_w.png

Software Question


Report on the individual Microsoft Office Applications

05/20/2020 252 views

I need to run a SQL report that shows the individual Device, user & each application of the Microsoft Office Suite also how often it is used the software is already metered. I need to be able to get information on what part of the suite is being used can anyone help with a report showing all of this information.

4 Comments   [ + ] Show comments

Comments

  • How would you represent "how often it is used"? Last launch? Launches in the past x number of days?
  • I would like to know the entire history if possible so that I can make a report on the need for this software to be installed on a new build
  • Can I suggest that you maybe then need to change your focus of the report? If, for example you need to justify buying the version of Office that has publisher included, you first need to understand how many Devices have publisher installed, and you may want to overlay information about how many of them have used publisher in the last 3-6 months from metering data?

    If you want to know the entire history of Publisher usage then that needs to come from the data regarding metering only, with maybe some added machine data in?
  • I have moved on and been able to use the following report to show some data but I need to know which individual device is used & how many times it has launched from a certain device & how many hours used on each device the report & output is shown below

    SELECT SVTS.NAME AS PRODUCT_NAME,

    SAM_METER_DATA.VERSION,

    (SELECT COUNT(DISTINCT MACHINE_ID) from SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE X

    WHERE X.ID = SVMDS_APPS.ID OR X.ID = SVMDS_SUITES.ID) AS INSTALL_COUNT,

    ROUND(SUM(SAM_METER_DATA.SECONDS_USED) / 3600.0, 3) AS TOTAL_HOURS_USED,

    SUM(SAM_METER_DATA.LAUNCHES) AS TOTAL_LAUNCHES

    FROM SAM_METER_DATA

    LEFT JOIN SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE SVMDS_APPS

    ON SAM_METER_DATA.TITLED_APPLICATION_ID = SVMDS_APPS.ID

    AND SAM_METER_DATA.MACHINE_ID = SVMDS_APPS.MACHINE_ID

    AND SAM_METER_DATA.VERSION = SVMDS_APPS.VERSION

    LEFT JOIN CATALOG.TITLED_SUITE_APPLICATION_JT TSAJT

    ON TSAJT.TITLED_APPLICATION_ID = SAM_METER_DATA.TITLED_APPLICATION_ID

    LEFT JOIN SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE SVMDS_SUITES

    ON SVMDS_SUITES.ID = TSAJT.TITLED_SUITE_ID

    AND SAM_METER_DATA.MACHINE_ID = SVMDS_SUITES.MACHINE_ID

    LEFT JOIN SAM_VIEW_TITLED_SOFTWARE SVTS

    ON SAM_METER_DATA.TITLED_APPLICATION_ID = SVTS.ID

    JOIN MACHINE M ON M.ID = SVMDS_APPS.MACHINE_ID OR M.ID = SVMDS_SUITES.MACHINE_ID

    GROUP BY SAM_METER_DATA.TITLED_APPLICATION_ID

    ORDER BY PRODUCT_NAME


    Data pulled out
    Product Name Version Install Count Total Hours Used Total Launches
    Access 16.x 16.0.4639.1002 197 445.736 398
    Access 2010 14.0.4750.1000 2426 114017.986 92439
    Access 2010 Standalone 14.0.7104.5000 6 39.344 109
    Access 97 8.0.4122 6 2.057 68
    Acrobat Distiller 11.x (Adobe Acrobat) 11.0.0.379 3 40.257 1221
    Acrobat Distiller X (Adobe Acrobat) 10.1.16.13 4 20.642 1354
    Acrobat X Professional 10.1.16.13 3 5701.294 24310
    Acrobat X Standard 10.1.16.13 1 150.178 1150
    Acrobat XI Professional 11.0.0.379 3 5277.923 18795
    Crystal Reports 2016 14.2.3.2132 11 819.176 463
    Excel 16.x 16.0.4654.1000 856 78791.828 42107
    Excel 2010 14.0.6117.5003 2426 1648023.31 1564881
    Excel 2013 15.0.4420.1017 1 912.334 2342

Be the first to answer this question

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ