When querying SQL directly for the LRT, the format is GMT which i believe is expected behaviour for BES vers 7 and 8. The time zone conversion when viewing the data via the console is handled by the console application.
What im looking to do is create a property that will return the LRT based on the endpoint s time zone (using the local time zone inspector)
Has anyone done this, or know the best way to code it up ?
When I read this, I was just thinking that ‘apparent registration server time’ (as used in the LRT property) could be used, but I suppose that using ‘now’ is a bit simpler.
I did find it amusing that in the inspector description it states that ‘apparent registration server time’ is shorthand for what would be ‘now of registration server’. How can a statement that is longer be described as shorthand?
Or if you wanted to be even more accurate (as to what time the clients ‘report’ landed on the server), would you take the difference between the ARST and the clients now result, halve it and then add that to the clients now time? (Obviously the delivery and reciept times are not the same, but this assumption should be good enough.)