The table view script show the people and how many times they have accessed a particular table in the last three months.
SELECT B.COMMENTSTRING, LOGDATE
FROM DBC.ACCESSLOG A
LEFT JOIN DBC.DBASE B
ON A.USERNAME = B.DATABASENAMEI
WHERE A.DATABASENAME = '\[UD###\]'
AND A.TVMNAME = '\[TABLE NAME\]'
GROUP BY 1, 2
ORDER BY 1, 2;
Hi,
As mentioned above,
(By default, AccessCount and LastAccessTimestamp will be disabled).
ObjectUseCountCollectRate field in DBS Control must be set to a non-zero value.
Then you can check from dbc.tables...
sel * from dbc.tables where tablename like '%%'
and lastaccesstimestamp<=date-180
Hi,
I have the same problem, but when i look into dbc.tables the field lastAccessTimeStamp is null.
Do i have to enable resusgaes? or what else i can do?
Thnks!!