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

Comments

  • 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.
Please log in to comment

Answers

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.
Answered 12/16/2014 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Five Steps for Easier- and More Effective- IT Inventorying
Having an accurate inventory of all your IT assets is critical to ensuring that users are productive and that every dollar is well spent. This white paper outlines five steps that improve inventorying both hardware and software.

Share