topic Re: Finder based on contains ""? in Active IQ Unified Manager Discussions

Finder based on contains ""?

dblackwe — Wed, 04 Jun 2025 15:19:34 GMT

Because of client naming and multitendency rules, they silo SVMs, an SVM is named $cluster[AB]_$BU. The AB is what node it lives on. I am trying to do a filter by cluster and node name, but I can't figure out a way to do this. I have $cluster, and I have $BU, determined through replace functions because of how they want that presented to end users. However I don't have a way to find out if its on A or on B. Any suggestions?

Re: Finder based on contains ""?

dblackwe — Wed, 15 Mar 2017 19:07:51 GMT

I almost have this.

I have custom filters now to do where blah like '%${variable}%', but in this case it doesn't work.

getVISANode(vserver1)

To find the name of the node I look for which node contians A vs which node contains B, the vserver if its supposed to be on node A has nameA_bu and B_ if its on B. I have a function that looks for the A_ or B_ and returns just A or B (that is getVISANode(str)). I have defined vserver1 in another step in this workflow, but I can't seem to use it inside my fucntion. Any help would be very appricated.

Re: Finder based on contains ""?

sinhaa — Sat, 18 Mar 2017 02:21:21 GMT

@dblackwe

Provide your workflow dar file. Designer solutions are very tedious to work on with just words at your disposal.

sinhaa

Re: Finder based on contains ""?

dblackwe — Sun, 19 Mar 2017 14:21:36 GMT

Sorry I wasn't able to explain myself well. I actually solved this with a custome filter.

SELECT
vserver.name,
vserver.type,
vserver.uuid,
vserver.name_service_switch,
vserver.nis_domain,
vserver.language,
vserver.comment,
vserver.admin_state,
vserver.nfs_allowed,
vserver.cifs_allowed,
vserver.fcp_allowed,
vserver.iscsi_allowed,
cluster.primary_address AS 'cluster.primary_address'
FROM
cm_storage.vserver,
cm_storage.cluster
WHERE
cluster.id = vserver.cluster_id
AND vserver.name like '%${vserver_name}%'
AND (
cluster.name = '${cluster_name}'
OR cluster.primary_address='${cluster_name}'
)

and those variables are filled in in the search with functions