Hi Hagai Nachmani!
You can clone existing report, then open cloned report in edit mode and check "Parameterized Query" tab or get a resolved query
--Java JRE execution details
vc.[Name] as 'Computer Name',
vc.[User] [Machine User],
vu.[Name] [App User],
FROM [Evt_Application_Start] appstart
JOIN VComputer vc on vc.[Guid] = appstart.[_ResourceGuid]
LEFT JOIN vUser vu on vu.Guid = appstart.UserGuid
WHERE appstart.[Policy Name] = 'Oracle Java'
ORDER BY appstart.[Start Date] desc
Thanks again Shawn,
By the way, how would you tackle the query if you wish to monitor more that one EXE file at once.
And could you please explain about the monthly metering action you mentioned:
Does this means every month the report resets it's self after collecting a daily info, or it just collects the info once a month every month?
--------------------------------------------------------------------- A member of the Intel Corporation group of companies
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s). Any review or distribution by others is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
,i.Name as [Computer Name]
,ms.[Average CPU Usage]
,ms.[Total Run Time]
,ms.[Total Run Time] / 60 / 60 as [Hours Run Time]
,ms.[Month End Summary]
, u.Surname as [Last]
,u.[Given Name] as [First]
from vAMMonthlySummary ms
join vFile vFile on vFile.Guid = ms.FileResourceGuid
left join vComputer i on i.guid = ms._ResourceGuid
join vUser u on u.Guid = ms.UserGuid
i.IsManaged = 1
and ms.[Month Year] like 'JULY 2021'
Systems Engineer | Baptist Health System | 3451 Beach Blvd. Jacksonville, Florida 32207
904.202.0686 (w) | 904.477.2705 (c)
Thank you Benjamin, this looks promising ��