Hello good folks SELECT eventTimestamp FROM transactions WHERE application = "MyPROD" and eventTimestamp BETWEEN '2020-09-20T10:28:30.186Z' and '2020-09-20T10:28:40.186Z' I get the data successfully, but the time is exactly 6 hours behind. What time zone or format is 2020-09-20T10:28:40.186Z The letters 'T' and 'Z' represent the Zulu time format, but I can't understand the results. The results are exactly 6 hours behind the expected. ... View more

select * from transactions where order-date is between 01/01/2018 12:00:00 to 01/02/2019 12:00:02 ... View more

Hello, New to App Dynamics Analytics. I want to write a query in ADQL for the following situation. In a business transaction if a record appears more than 2 times in 30 seconds, i have to alert. Basically I have consider that they are duplicate records if they happen within 30 seconds duration. I don't find GROUP BY clause in ADQL SELECT COUNT(segments.userData.employeeid) FROM transactions WHERE application = "MSDynamics-PROD" AND transactionName = "Plugs" and segments.userData.EventType = "Authentication"  and segments.userData.EventSubType = "Passcode"  Thank You ... View more

Hello, We use MSD CRM dynamics. MSD has lot of Asyn calls (hops) . We want to chain all these Async hops to be able instrument from end (starting) to end (end). Are there any specific modules that we could use? Thank you ... View more