Re: OCC audit question

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Use Run SQL Scripts, not STRSQL as that cannot handle some of the field
types, and give them the following;

*-- Derive the IBM i operating system level and then *
*-- determine the level of currency of PTF Groups*
*--   *With iLevel(iVersion, iRelease) AS
(
select OS_VERSION, OS_RELEASE from sysibmadm.env_sys_info
)
  SELECT P.*
     FROM iLevel, systools.group_ptf_currency P
     WHERE ptf_group_release =
           'R' *CONCAT* iVersion *CONCAT* iRelease *concat* '0'
     ORDER BY ptf_group_level_available -
        ptf_group_level_installed DESC;

If you enabled it, you can right click on the result set and save it as an
Excel spreadsheet.

On Wed, Jan 15, 2025 at 9:27 AM Dean Eshleman via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> If an auditor wants to know the patch version of the operating system and
> the database on the IBM I, what should I tell them?  I'm not a system admin
> so I'm not familiar with how to look at PTF levels, etc..
>
>
> Dean Eshleman Software Development Architect
>
> Everence(r)
> 1110 North Main Street
> PO Box 483
> Goshen, IN 46527
> P: (574) 533-9515
> TF: (800) 348-7468
> W: everence.com<http://www.everence.com/>
>
> Confidentiality Notice: This information is intended only for the
> individual or entity named. If you are not the intended recipient, do not
> use or disclose this information.  If you received this e-mail in error,
> please delete or otherwise destroy it and contact us at (800) 348-7468 so
> we can take steps to avoid such transmission errors in the future. Thank
> you.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.