/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: chucksteel 9 years ago
Red Belt
1
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.
 
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