Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Application Metering

Created: 16 Nov 2012 • Updated: 19 Nov 2012 | 9 comments
This issue has been solved. See solution.

Ok so some challenges with this..

we are going through our tests as a dry run for change control and we need to show start times of applications.

I started Winzip, Acrobat Reader and InfoPath.... they didnt check in so was talking with Symantec.. they check in Daily or weekly.. I have it set to daily and he said i have to wait 24hrs... so i did now they show up.. but an issue..

they are off by 5hrs!!!! anyone know why the report would be off by 5hrs? exactly 5hrs

they were ran at 8:xx am not 1:xxpm

Application First Run First Computer Last Run Last Computer
AcroRd32.exe 11/15/12 1:50 PM A226508 11/15/12 1:50 PM A226508
Infopath.exe 11/15/12 1:53 PM A226508 11/15/12 1:53 PM A226508
WinZip.exe 11/15/12 1:47 PM A226508 11/15/12 1:47 PM A226508

Comments 9 CommentsJump to latest comment

JimChud's picture

You may want to check the time and location settings on the 3 points where data is gathered and sent to:

Workstation, NS Server, SQL Server.

I haven't seen that problem before but i removed Application metering and haven't put it back yet. no particular reason why but just not got round to it.

i wouldn't be suprised if its something silly like that.

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.

Andrew Bosch's picture

Yes, the datetime stored in the database is UTC.

------------------------------------
Sr. Principal SQA Engineer
Symantec

TeleFragger's picture

ok it is stored in db that way... well im on the phone with Symantec and they never heard of this issue..

so maybe ill just edit the report to get the time????

Did we help you? Please Mark As Solution those posts which resolve your problem,

TeleFragger's picture

so i took a report from NS 6 and made it work for NS 7.1...

anyone wanna assist on subtracting 5hrs from time?

SELECT DISTINCT

t2.[Application] AS 'Application', t2.[First Run] AS 'First Run', 'First Computer' = (SELECT c.[Name] FROM dbo.vComputer c WHERE c.[Guid] = t2.[_First]),

t2.[Last Run] AS 'Last Run', 'Last Computer' = (SELECT c.[Name] FROM dbo.vComputer c WHERE c.[Guid] = t2.[_Last])

FROM

(SELECT t.[Application],

t.[First Run], '_First' = (SELECT TOP 1 i.[_ResourceGuid]

FROM dbo.Evt_Application_Start i

WHERE i.[Start Date] = t.[First Run] AND i.[Policy Name] = t.[Application]

ORDER BY i.[_id]),

t.[Last Run],

'_Last' = (SELECT TOP 1 i.[_ResourceGuid]

FROM dbo.Evt_Application_Start i

WHERE i.[Start Date] = t.[Last Run] AND i.[Policy Name] = t.[Application]

ORDER BY i.[_id] DESC)

FROM

(SELECT i.[Policy Name] AS 'Application', MIN(i.[Start Date]) AS 'First Run', MAX(i.[Start Date]) AS 'Last Run'

FROM dbo.Evt_Application_Start i

GROUP BY

i.[Policy Name]

)

t)

t2

ORDER BY

t2.[Application]

Did we help you? Please Mark As Solution those posts which resolve your problem,

Andrew Bosch's picture

This is just your SELECT stament, modified, to take the UTC dates and put them into the datetime that corresponds with your SQL server.  The rest of you query stays the same...

SELECT DISTINCT t2.[Application] AS 'Application'
,DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), GETDATE()), t2.[First Run]) AS 'First Run'
,'First Computer' = (SELECT c.[Name] FROM dbo.vComputer c WHERE c.[Guid] = t2.[_First])
,DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), GETDATE()), t2.[Last Run]) AS 'Last Run'
,'Last Computer' = (SELECT c.[Name] FROM dbo.vComputer c WHERE c.[Guid] = t2.[_Last])

------------------------------------
Sr. Principal SQA Engineer
Symantec

SOLUTION
TeleFragger's picture

Thank you!

Did we help you? Please Mark As Solution those posts which resolve your problem,

TeleFragger's picture

update for anyone that also runs into this...

Jeff – Product Management and Engineering have confirmed that this is working as designed (does not necessarily mean a "good" design by any means). However, they acknowledged that this is a defect and will submit to be fixed. TBD on a timetable. I will keep you posted. 

Did we help you? Please Mark As Solution those posts which resolve your problem,

JimChud's picture

Thats good news atleast!

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.

TeleFragger's picture

well i was even given a tidbit how to get the 5 minute (demo only) choice for app metering.. but you set it on the settings> application metering configuration page where you can choose 1 day, 2 days, 7 days (recommended), 14 days... 

now i have a 5 minute (demo only) so i set it and saved it..

but the actual policies are still set to daily or weekly... so that sucks.. this is my last script i need to run for us to move on to production.. i have to wait 24hrs then on top of that im off tomorrow... hah..

Did we help you? Please Mark As Solution those posts which resolve your problem,