IBM i User Profile Analysis Using QSYS2.USER_INFO
IBM i User Profile Analysis Using QSYS2.USER_INFO August 26, 2026 Like many of you, I receive IBM Notifications via email multiple times per day. The IBM Notification Page can be found here . Take advantage of this if you haven't already. Sign up: - Select IBM products in which you are interested. - Choose daily or weekly notifications. - Select a delivery method: e-mail and/or RSS news feed. In a recent notification, a topic and link about "IBM i User Profile Analysis" was presented. There is a lot of good material to review. Many admins already have SQL's and queries relating to this topic. IBM summarizes the page as follows: "IBM i User Profile Analysis Using QSYS2.USER_INFO explains how IBM i security administrators can use SQL services to audit and analyze user profiles across the system". "The document focuses on the QSYS2...
