All Forums Aster
fshpige 4 posts Joined 05/15
22 May 2015
aster table usage

I'm looking for a way to find information about a set of Aster tables- specifically who(userid) queries them.
What would be  the best way to get this info?

shukla2502 3 posts Joined 07/13
25 May 2015

You can have a look at the same using AMC or if you wanna check it with a sql Query you can us the NC_tables.
The data dictionary view nc_all_statements contains information about recently executed statements in Aster Database. By default, the table retains three days worth of statements, but your representative can change the retention policy for you.
you can frame a query where you wanna see tablename like in <statement> and pull out the sessionid and then can relate the sessionids and Userids.
hopefully this helps.

fshpige 4 posts Joined 05/15
27 May 2015

Thank you!

You must sign in to leave a comment.