Problems with complex relevance

(imported topic written by SystemAdmin)

I’m creating 2 fixlets, #1 for Tivoli Storage Manager 5.5.3.0 and #2 for Tivoli Storage Manager 6.2.2.0

The separate versions are due to compatibility requirements, where #1 is the LAST version of TSM supported on those older OS’s

I need to create 2 relevance statements to evaluate to true only for the following:

#1 TSM version 5.5.3.0

include ONLY “Oracle Enterprise AS release 4”, “Red Hat Enterprise AS 3”, “Red Hat Enterprise AS 4”, “SuSE Enterprise Server 9” and “SunOS 5.9” and not exists file “/usr/bin/dsmc”

#2 TSM version 6.2.2.0

include ONLY “Oracle Enterprise Server 5”, “Red Hat Enterprise Server 5”, “AIX” and “SunOS 5.10” and not exist file “/usr/bin/dsmc”

  • IMPORTANT **

But both need to exclude “win” without picking up any other OS’s

The following kinda works, but picks up AIX and Red Hat Enterprise Server 5, What am I doing wrong???

( (exists (operating system) whose (it as string as lowercase contains “Red Hat Enterprise AS 3” as lowercase)) or (exists (operating system) whose (it as string as lowercase contains “Red Hat Enterprise AS 4” as lowercase)) or (exists (operating system) whose (it as string as lowercase contains “SuSE Enterprise Server 9” as lowercase)) or (exists (operating system) whose (it as string as lowercase contains “Oracle Enterprise AS release 4” as lowercase)) or (not exists (operating system) whose (it as string as lowercase contains “win” as lowercase)) ) and (not exists file “/usr/bin/dsmc”)

(imported comment written by SystemAdmin)

Try these:

#1

(exists (operating system as string as lowercase) whose(it contains “Oracle Enterprise Server 5” as lowercase OR it contains “Red Hat Enterprise Server 5” as lowercase OR it contains “AIX” as lowercase OR it contains “SunOS 5.10” as lowercase)) AND (not exists file “/usr/bin/dsmc”)

#2

(exists (operating system as string as lowercase) whose (it does not contain “win” AND (it contains “Red Hat Enterprise AS 3” as lowercase OR it contains “Red Hat Enterprise AS 4” as lowercase OR it contains “SuSE Enterprise Server 9” as lowercase OR it contains “Oracle Enterprise AS release 4” as lowercase))) and (not exists file “/usr/bin/dsmc”)

I got rid of the ‘it’ case formatting and put it on the original data element (of which I used one). I ANDed the “win” statement for #2 along with the other OR’d strings. I would normally use lowercase strings and skip the repetitive ‘as lowercase’ everywhere, but I left it in as you might prefer it.

Let me know if this works for ya.

-Jim

(imported comment written by SystemAdmin)

That worked… Thanks for the quick reply