Software

I am trying to write/find a report to do the following:

Pull the metering data for specific software title from the last 3 months per agent. In this case, I am looking for AutoCAD Architecture 2014 usage (hours used, launches per user). The problem being, using the built-in wizard isn't returning anything but 4x users, which is now down to 2x users. I did find a report that is finally showing me everyone, but I am having problems getting it to only pull the last 3 months. Plus, it looks like this may not be the correct table to pull from?

I am not a SQL guru by any means. I have installed MySQL Workbench and have been "browsing" the database to see what I can see to help me out.

Here is what I have so far:
SELECT COUNT(SMD.ID) as "Launches",
ROUND(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 "%Autocad Architecture 2014%" and

GROUP BY TITLED_APPLICATION_ID, MACHINE_ID

ORDER BY Launches DESC

The problem with this report (or tables? I am pulling from) shows the last date used was back in October. This is incorrect, as it is used everyday by majority of users.