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

Hello,
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 asterdata.com/support 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.