Re: OCC audit question

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

There's also

*-- Compare the current Firmware against IBM's *
*-- Fix Level Request Tool (FLRT) to determine if the *
*-- firmware level is current or upgrades are available*
*--   *SELECT *
  FROM SYSTOOLS.FIRMWARE_CURRENCY;

On Wed, Jan 15, 2025 at 9:39 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> 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.