IBM Support

How do you create a report for Users approaching the Maximum Storage defined in their profiles.

Question & Answer


Question

How do you create a report for Users approaching the Maximum Storage defined in their profiles.

Answer

With the introduction of the IBM i SQL Service USER_INFO view table function, you can create an SQL report that lists the user profiles that are approaching the Maximum Storage defined in their profiles

 
Authorization: 
 
Only *USRPRF objects that the user has *OBJOPR and *READ authority to will be returned. To see a non-null value for the USER_DEFAULT_PASSWORD column, the user must have *ALLOBJ and *SECADM authority.
 
1) Open the ACS Run SQL Scripts tool 
2) Run the following SQL:
SELECT USER_NAME as User_name,
       STGUSED as Storage_used,
       MAXSTGLRG as Max_storage,
       DECIMAL(STGUSED * 100 / MAXSTGLRG, 5, 2) AS PERCENTAGE
    FROM qsys2.user_info
    WHERE (STGUSED * 100 / MAXSTGLRG) > 90
image 7362
Note:  The report lists all users that have used more than 90% of their allowed maximum storage. 
More information on the USER_INFO view can be found on the link:

 

[{"Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHyAAM","label":"Security"}],"ARM Case Number":"TS004599667","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0;7.3.0;7.4.0"}]

Document Information

Modified date:
29 September 2025

UID

ibm16375940

Page Feedback