Analysis for AIX fileset version

(imported topic written by beasleya)

Hi,

I am trying to create an property on AIX which returns fileset name and latest version

so far I can list all filesets and versions with -

Q: (lpp_name of it, version of it) of filesets of products of object repository

.

.

A: sysmgtlib.framework.core, 5.3.0.30

A: sysmgtlib.framework.core, 5.3.0.50

A: sysmgtlib.framework.core, 5.3.9.0

A: sysmgtlib.libraries.apps, 5.3.0.30

A: sysmgtlib.libraries.apps, 5.3.0.60

A: sysmgtlib.libraries.apps, 5.3.9.0

A: tivoli.tsm.client.api.32bit, 5.5.0.0

A: tivoli.tsm.client.api.64bit, 5.5.0.0

A: tivoli.tsm.client.ba.32bit.base, 5.5.0.0

A: tivoli.tsm.client.ba.32bit.common, 5.5.0.0

A: tivoli.tsm.client.ba.32bit.image, 5.5.0.0

A: tivoli.tsm.client.ba.32bit.nas, 5.5.0.0

A: tivoli.tsm.client.ba.32bit.web, 5.5.0.0

A: vacpp.cmp.rte, 6.0.0.0

A: xlC.aix50.rte, 10.1.0.0

A: xlC.aix50.rte, 10.1.0.2

A: xlC.aix50.rte, 10.1.0.3

A: xlC.cpp, 9.0.0.0

A: xlC.msg.en_US.rte, 10.1.0.0

A: xlC.msg.en_US.rte, 10.1.0.2

A: xlC.msg.en_US.rte, 10.1.0.3

A: xlC.msg.en_US.cpp, 9.0.0.0

A: xlC.rte, 10.1.0.0

A: xlC.rte, 10.1.0.2

A: xlC.rte, 10.1.0.3

but how can I get it to only return the latest version of each fileset ?

Cheers,

Andy.

I’m bumping this question, because I am not relevance-savvy enough to perform this query either.

I am curious why there is not already a property in “AIX Filesets Inventory Result” that is concatenated “lpp_name, latest committed version” of file sets on the system.

Doing filters/queries is complex with name, version, status in 3 separate properties.

I don’t have AIX to test with, but try this:

Q: (lpp_names of it, maxima of versions of it) of filesets of products of object repository

This returns the same as without the maxima argument.

It is odd the older / non-installed versions return at all…

Here is a drilled in example :
Q: (lpp_names of it, maxima of versions of it) of filesets whose (lpp_name of it equals “security.acf”) of products of object repository
A: security.acf, 7.2.1.0
A: security.acf, 7.2.1.1
A: security.acf, 7.2.2.15

Below I’m showing the cli to see this lpp, and the effective data I am trying to capture into a property in relevance :
user@server: $ sudo lslpp -l security.acf
Fileset Level State Description

Path: /usr/lib/objrepos
security.acf 7.2.2.15 COMMITTED ACF/PKCS11 Device Driver

Path: /etc/objrepos
security.acf 7.2.2.15 COMMITTED ACF/PKCS11 Device Driver

Can you try retrieving the ‘state’ for each fileset? https://developer.bigfix.com/relevance/reference/fileset.html#state-of-fileset-string

My AIX client is on a really old version and I can’t check, but I expect you may want filesets whose (state of it = "COMMITTED")

Good idea but looks like AIX considers all of these returned to be committed state:

Q: (lpp_name of it, version of it, state of it) of filesets whose (lpp_name of it equals “security.acf”) of products of object repository
A: security.acf, 7.2.1.0, COMMITTED
A: security.acf, 7.2.1.1, COMMITTED
A: security.acf, 7.2.2.15, COMMITTED
T: 76469