Query on sysevent table in a Scheduled job with run as System Administrator returns incorrect value

[Amit Kumar21]

when run this query returns different set of records, which upon checking on table shows that all the records with "name=impersonation.start" is returned.

but when i run the same query with Run as my name(which also had admin role), it returns the correct values i.e "name=impersoantion.start" and created yesterday.

Has anyone faced this and how can it be resolved?

[Saurabh Gupta · Accepted solution]

Hi,
Time zone of both users is same?

[Amit Kumar21]

Hi,

No, Timezones are different. I think that is the issue. Since few records were create late in the night with CET and they are showing in created today, for my user(in IST).

Thanks.