Hi,

I am trying to adjust the code below to show me what processes haven't been used in 30 days. Can anyone tell me what is wrong with what is below. It is from the inkPad news letters and other bits from here. I just need it to show what processes from metering haven't been used in 30 days.

SELECT COUNT(SMD.ID) as "Launches",

SUM(SECONDS_USED)/360 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

 

and END > DATE_SUB(NOW(),INTERVAL 1 Day)

 

GROUP BY  TITLED_APPLICATION_ID, MACHINE_ID

 

ORDER BY Launches DESC

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity