Sync data and time on dashboard

Discussion created by 1_nimbus.support on Nov 3, 2009
Latest reply on Nov 18, 2009 by 1_tim.moor

Does any body also experienced that the same SQL query results to different values in Enterprise Console and the ADOGTW / SQL_RESPONSE in the Nimbus Manager?

Select DATEADD (s,LastUpdated,'1970-01-01 00:00:00') as  LastUpdated from NMTable where ServerName = 'SERVER' and ProbeName = 'Users'

I want to add the last Sync time on my dashboard but I get always 1257251126 when using the SQL query in the generic database in the enterprise console while I get 11/3/2009 1:30:26 PM in the ADOGTW test on the Nimbus Manager.It's not possible to work via QoS as it return the value NULL.

Is there anybody who know how I can get the sync time on my dashboard?

Many thanks in advance.