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