The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to register at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

DWH Report - filter syntax query

wbennett5

I often find I need to filter out similar types of systems like ESX or Backup servers which have multiple Host volumes attached and is easy enough in one way in that they generally have a good naming convention but my issue is to filter them I use something like...

[Source Hosts] not contains ('esxsrv')

Which works find and captures and excludes all esxsrv_xxx servers but I don't know why the following wont work as I do this exact same filter but without the 'not' when wanted to only include certain systems...

[Source Hosts] not contains ('esxsrv','bckp_srv_')

Which won't work however if I only wanted to include the esx and backup servers the follow would be fine...

[Source Hosts] contains ('esxsrv','bckp_srv_')

I work around this by just add each server type as a separate filter but wondered why this won't with when using 'not' in the filter?

1 REPLY 1

moechnig

A Google search for "cognos filter multiple strings" (no quotes) suggests that the proper syntax would be to put OR between the strings: 

CONTAINS( [column], ' " *Ta* " ' OR ' " *Pi* " ')

I haven't tried it yet but if that doesn't work it's likely another page in the search results will contain the answer. 

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public