Re: Check PTFs currency (up-to-date-ness)

Also, ACS version 1.1.9.3.
Both run in ACS SQL Scripts and STRSQL.


Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Office and OnCall: 731.676.4318
Cell: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com
IBM i Personal Blog: https://ibmireference.blogspot.com
"Success is not final. Failure is not fatal. It is the courage to continue that counts".


4. Re: Check PTFs currency (up-to-date-ness) (Michael Mayer)


----------------------------------------------------------------------


message: 4
date: Wed, 1 Nov 2023 16:32:05 +0000
from: Michael Mayer <michael.mayer@xxxxxxxxxxxxx>
subject: Re: Check PTFs currency (up-to-date-ness)

I'm at V7R4 with fairly current PTF's and both of these work (also on my blog site front page)



SQL 1:
with ilevel (iversion, irelease) as (
select os_version, os_release
from sysibmadm.env_sys_info
)
select Row_Number() over (Order by ptf_group_level_available - ptf_group_level_installed desc, ptf_group_id) as "Row #", p.*
from ilevel, systools.group_ptf_currency p
where ptf_group_release = 'R' concat iversion concat irelease concat '0'
order by "Row #"
----------------------------------------------------
SQL 2:
Select Row_Number() over (ORDER BY PTF_GROUP_CURRENCY DESC, PTF_GROUP_ID ASC) as "Row #",
PTF_GROUP_CURRENCY, PTF_GROUP_ID,
PTF_GROUP_TITLE, PTF_GROUP_LEVEL_INSTALLED,
PTF_GROUP_LEVEL_AVAILABLE,PTF_GROUP_LAST_UPDATED_BY_IBM,
PTF_GROUP_RELEASE, PTF_GROUP_STATUS_ON_SYSTEM
From SYSTOOLS.GROUP_PTF_CURRENCY



Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Office and OnCall: 731.676.4318
Cell: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com/
IBM i Personal Blog: https://ibmireference.blogspot.com/
"Success is not final. Failure is not fatal. It is the courage to continue that counts".


----------------------------------------------------------------------