Re: Retrive libray last date used

Check out the OBJECT_STATISTICS() SQL function https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqudfobjectstat.htm

For the library:

select LAST_USED_TIMESTAMP

from table(QSYS2.OBJECT_STATISTICS('QSYS','*ALL', 'TIM1')) X
;;

For the objects in the library:

select max(LAST_USED_TIMESTAMP)

from table(QSYS2.OBJECT_STATISTICS('LIBRARY','*ALL')) X
;;

Tim.

________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of gio.cot via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Sent: 25 November 2019 12:52
To: midrange-l@xxxxxxxxxxxxxxxxxx <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Subject: Retrive libray last date used

Hi all

I would need to retrive the last date that a library or one object inside
it, that was used ; can some suggest which command, in can use

Thanks in advance

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&amp;data=02%7C01%7C%7C7120a820af654c5416b008d7719dec63%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637102795393139054&amp;sdata=FeolUIsVtX3K%2FMi3rI%2FLsbnBoWwZcfs39qW7vfvSnzU%3D&amp;reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&amp;data=02%7C01%7C%7C7120a820af654c5416b008d7719dec63%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637102795393139054&amp;sdata=pn1o%2F%2FTAvK1eNEkH4uIf%2FgQ11Wt6ZDh1DRLGoyLiSxY%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com&amp;data=02%7C01%7C%7C7120a820af654c5416b008d7719dec63%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637102795393139054&amp;sdata=rwUkkJkHgPpt4myKYppb6HBH65hE0BinELU7E9a01zU%3D&amp;reserved=0