Determine last accessed AG

[jsquizz]

I was tasked with doing an inventory of stale data in CMOD (keep in mind, we've never expired) - and management wants me to see how often old data is being retrieved.

Specifically, how often is data that is 7-15 years being retrieved, 15+, etc.

I've been trying to come up with something via querying the system log, to no luck. I figured a good "high level" view would be - at least provide the queries.

....users are querying 1970-2026....

I have an AGID/AID and a DOCNAME- Is this going to boil down to doing some type of query outside of CMOD. We have a very "hands off" approach..

[Mehmet S Yersel]

Hi Jeff,

You are trying to build age-of-document at time-of-retrieval chart. I had done it in one of the recent system review I conducted for a client. System log has retrieval timestamp. Message #66  should look like this:

ARS0066I
ApplGroup DocGet: Name(appl_grp_name) Agid(agid) ApplName(appl_name)Aid(aid)
NodeName(node_name)Nid(nid) Server(server)Time(time) Flds(fields)

If you are lucky and the Flds contains a date field:
ARS0066I User USER1 retrieved 1 document(s) from application group ACCT_GRP,
application ACCT_APPL, folder ACCT_FOLDER.
FLDS=(ACCOUNT=123456789, DATE=20250315, TYPE=STATEMENT)

all you need to do is extract the Msg_Num=66 text fields, and process them with a script to create  "retrieval-time, doc-date, age". age is retrieval-time minus doc-date. Load into MS SQL, let's say T1. Then:

Select age, count(*) from T1 group by age order by age

You can then export into excel and draw a chart to visualize the document-age-at-time-of-retrieval.

if you cannot find any date field in Msg_66, you need to look in more detail in the logs for anyting else that might help you drive to document date. Also, if they are using ODWEK for document retrievals, you need to look at a different message number. Review system logs and there might be some clues there.   You can pull AGID form the message and add it to your query for more granularity.

Good luck.
-Mehmet