Software Metering Report showing incorrect information
I am running a metering report to check for Visio installations, however, the outcome shows false information. For example it shows one machine has Visio 2007 and 2010 installed, when in reality it only has Visio 2007 installed. Under the machine's information it only shows Visio 2007 in installed software. Is there anything that might need to be changed to prevent this from happening? Bellow is the report I am running:
SELECT COUNT(SMD.ID) as "Launches",
SUM(SECONDS_USED)/3600 as "Time Used (hours)",
MAX(END) as "Last Used",
MACHINE.NAME as "Computer",
GROUP_CONCAT(DISTINCT(USER_DATA)) AS "Users"
FROM ORG1.SAM_METER_DATA SMD
JOIN MACHINE on SMD.MACHINE_ID = MACHINE.ID
JOIN SAM_VIEW_TITLED_SOFTWARE SVTS on SMD.TITLED_APPLICATION_ID = SVTS.ID
WHERE SVTS.NAME like "%Visio%"
GROUP BY TITLED_APPLICATION_ID, MACHINE_ID
ORDER BY Launches DESC
Please log in to answer
Posted by: chucksteel 6 years ago
I believe you're seeing results for both Visio 2007 and Visio 2010 because you are selecting data from the SAM_METER_DATA table and joining to the SAM_VIEW_TITLED_SOFTWARE view. To really figure out what is going on open MySQL Workbench and look at the SAM_METER_DATA table data for the machine in question. If you only see entries for Visio 2007 in that table then you know that the issue is with how the joins are happening.