tag:blogger.com,1999:blog-6690994337395244641.post8138600557702368026..comments2022-03-30T14:14:56.448-05:00Comments on Paul Melson's Blog: From The InboxPaulMhttp://www.blogger.com/profile/02530533566781746778noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6690994337395244641.post-65266373150073709012009-06-21T13:26:00.329-05:002009-06-21T13:26:00.329-05:00I will grant you that. As soon as you get into que...I will grant you that. As soon as you get into querying multiple tables beyond just event data, like assets and cases, then the queries get hairy.PaulMhttps://www.blogger.com/profile/02530533566781746778noreply@blogger.comtag:blogger.com,1999:blog-6690994337395244641.post-60010124348162495662009-06-17T04:31:40.260-05:002009-06-17T04:31:40.260-05:00Hi, sorry but the schema structure is not as strai...Hi, sorry but the schema structure is not as straight-forward as you seem to assume. Especially when you have to perform queries mixing events and resources. I've created a script giving you the amount of lag you have per device (by computing differences between the various timestamps : agentReceiptTime / managerReceiptTime / endTime) and the query is 20 lines long...Unknownhttps://www.blogger.com/profile/03382824054676570862noreply@blogger.com