Examples of Ad-Hoc SQL Queries › List Users Who Have Been Defined in the Last Thirty Days

List Users Who Have Been Defined in the Last Thirty Days

This query lists the userid and the user name field for every userid that was defined 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 create date for the userid.

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