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.

Yes, the datetime stored in the database is UTC.

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????

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]

Thank you!

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. 

Thats good news atleast!