How do I get a timestamp column and sort by that on the database dashlet? I've looked at the available columns and don't see it.
Thank you!
Answer by Rob V. ·
Hi Bennett,
The database dashlet is an "aggregate" dashlet, just like the Web Requests, Methods, etc dashlets. That means that any SQL statement you see there doesn't necessarily represent a single execution of that query. That's why there's not an execution timestamp column - it doesn't apply here.
You can see any statement in the context of its actual PurePath though, by r-click, Drill Down->PurePaths. The PurePath does have a timestamp on it, and from the Elapsed Time column you can get an idea when any particular query executed.
Hope this helps,
Rob
JANUARY 15, 3:00 PM GMT / 10:00 AM ET