Examples of Ad-Hoc SQL Queries › List Users Who Have Been Inactive

List Users Who Have Been Inactive

This query lists the userid and user name field for every userid that has been inactive in the last thirty days, for all of the system images represented in the repository.

The USERINFO table contains fields for the system ID, the userid, the user name, and the last accessed date for the userid.

SELECT SYSID, USERID, NAME, LUDATE             
FROM   CIADB01.USERINFO                         
WHERE DAYS(CURRENT DATE) - DAYS(LUDATE) + 1 > 30
ORDER BY SYSID, USERID;