Software Metering Report showing incorrect information
Hello,
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",
SVTS.NAME,
VERSION,
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
1 Comment
[ + ] Show comment
-
Do you know whether this machine has had Visio 2010 installed in the past? Have you checked the program files (x86) folder for any evidence that Visio 2010 might be installed? It is possible that the apps have been installed "per user" so that you only see the one installed for the user account you are currently logged in as, whereas in fact there is a second version on there but installed for another user. The audit client, running as localsystem, would of course see both versions. - EdT 9 years ago
Answers (1)
Please log in to answer
Posted by:
chucksteel
9 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.
