Is there any way to audit the usage of easy sql queries? We are looking to track when a query is executed and by which user.

Well the first thing I thought of is - how do you handle your device queues? You could always query the device queue table(ttaad320) - pull the session ttadv3180m000, the report name, the run date. From the report name you could probably match it up to a query name in ttadv380. Have not done this myself just something I thought of. Of course this assumes you do not purge the device queue on any kind of regular basis.

Thanks Mark, that looks very promising. We do purge the device queue fairly regularly but I will not do it for a while and see what I get for data.

You can also look in TIME.HIS in $BSE/lib
(only if you activate 'history' in user mangement. )

example :
000|baan |ttadv3480m000|21|09|13|21|43|21|09|13|21|43
100|baan |ttstpsplopen |21|09|13|21|43|21|09|13|21|43
100|baan |rtfsqlopenamnt|21|09|13|21|43|21|09|13|21|43

Line 1 ttadv3480 run query.
Line 2 Then print the report
Line 3 Report name which in most cases contains the name of the query