ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Library Last Used Date ??

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Library Last Used Date ??

    Is it possible to find out when a library was last used ? What that really means, is when the last time an object in a library was last used .

    DSPOBJD has a "Last Used" date field, but it is blank for libraries.

  • #2
    Code:
    SELECT * FROM TABLE (QSYS2.OBJECT_STATISTICS('library-name', '*ALL') ) as a
    order by LAST_USED_TIMESTAMP desc
    fetch first 1 row only

    Comment


    • jtaylor___
      jtaylor___ commented
      Editing a comment
      P.S. Probably need to add "where LAST_USED_TIMESTAMP is not null".

  • #3
    Thanks ! I am also going to check the value of OBJCREATED because I found some libraries with recently created objects that I want to treat as "Last Used", even though they may not have been used since creation date.

    Comment

    Working...
    X