Active IQ Unified Manager Discussions

Finder based on contains ""?

dblackwe
3,521 Views

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?

1 ACCEPTED SOLUTION

dblackwe
3,392 Views

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

View solution in original post

3 REPLIES 3

dblackwe
3,510 Views

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.

sinhaa
3,440 Views

@dblackwe

 

 

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

 

sinhaa

 

 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

dblackwe
3,393 Views

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

Public