Active IQ Unified Manager Discussions

how to email filter details



I am bulding a workflow to monitor volumes and exapnd vol sizes.


I had written a filter that gets all volumes sizes above "threshold" and i want to mail all these details for approval.


And here my questions are

1)how to get all details returned by filter

2)How to email these details 


Re: how to email filter details




Dump the filtered data in an XCEL.

How you can do it?

Please see the sample code below.

This is the "Create CSV Report-FLI" available in, under the "OFFLine Foreign Lun Import pack".



use strict;
use Getopt::Long;
use WFAUtil;

my $FileName;
my $FileNamePrefix = 'lun_report';

my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime();
$year += 1900;
my $CurrentTime = $mday . "_" . $mon . "_" . $year . "__" . $hour . "_" . $min . "_" . $sec;

#Creating CSV file name
$FileName = $FileNamePrefix . "_" . $CurrentTime . ".csv";

my $wfa_util = WFAUtil->new();
$wfa_util->sendLog('INFO', 'Creating CSV file: ' . $FileName);

my $query="SELECT * FROM lun_import"; -->Here you need to put your volume query.
my $database="playground";
my @data;
my $length;

eval {
@data = $wfa_util->invokeMySqlQuery($query,$database);


$length = @data;

open(FILE, ">$FileName"); # Open for output
print FILE "id,vserver_name,foreign_disk,path,import_home_node,administrative_status,compared_blocks,estimated_remaining_duration,".

for (my $index =0; $index < $length; $index++)
if ($data[$index] ne "\n")
if ($data[$index] eq "")
print FILE "-,";
else {
print FILE "$data[$index]" . ",";
print FILE $data[$index];
close(FILE); # Closing file




Second Step:

Send the File.

Please use the "Send Email" code, which is part of WFA release.


You need to customize "Send Email" for attaching the CSV file created in the above segment.

Sample code here.



Put approval point after that.


Followed by the next command.


2021 NetApp Partner Experience Survey
PES Banner
All Community Forums