Active IQ and AutoSupport Discussions

Active IQ UM - API and Powershell

connoisseur
3,298 Views

Hi

 

We are currently working on writing a simple integration using the Active IQ Unified Manager API and Powershell for extracting volume specific attributes. We have found most of the information using simple queries as follows:

$NetAppVolumeRecordsAll = Invoke-RestMethod -Method Get -UseBasicParsing -Uri "https://<NETAPP IP>/api/datacenter/storage/volumes?order_by=name&max_records=100000" -Headers $authheader
$NetAppVolumeRecord = $NetAppVolumeRecordsAll.records | Where-Object name -eq "<VOLUME NAME>"
$NetAppGatewayVolumeRecords = Invoke-RestMethod -Method Get -UseBasicParsing -Uri "https:// <NETAPP IP>/api/v2/gateways/ $($NetAppVolumeRecord.cluster.uuid)/storage/volumes?name=$($NetAppVolumeRecord.name)&fields=**&return_records=true&return_timeout=15" -Headers $authheader

 

We are trying to replicate the same behavior as our current reporting code, which is based on an imported BIRT report built in Eclipse a while back:

select cluster.name as Cluster, vserver.name as SVM, volume.name as Volume, 
volume.size/POW(1024,3) as size_gb, 
volume.sizeUsed/POW(1024,3) as used_gb, 
(volume.deduplicationSpaceSaved+compressionSpaceSaved)/POW(1024,3) as saved_gb, 
volume.sizeUsedBySnapshots/POW(1024,3) as snapshot_gb,
(volume.sizeUsed+volume.deduplicationSpaceSaved+compressionSpaceSaved+sizeUsedBySnapshots)/POW(1024,3) as total_gb,
volume.isEncrypt as Encrypted, volume.qosPolicyGroupId as QoS

from cluster
join vserver
          on vserver.clusterId = cluster.objid
join volume
          on volume.vserverId = vserver.objid
    AND volume.name NOT LIKE 'MDV_%'
            AND volume.name NOT LIKE 'vol0'
            AND (volume.junctionPath != '/' OR volume.junctionPath IS NULL)
ORDER BY SVM, Volume asc;

 

But we have a hard time working out the correct way to query for the volume.deduplicationSpaceSaved and compressionSpaceSaved attributes. We have so far been unable to find these using the API documentation and trial and error, could you please help us with pointer to the correct endpoint or method for also requesting information for these attributes for a given volume?

 

Best regards

 

/Henrik

4 REPLIES 4

andris
3,233 Views

AIQ UM and ONTAP versions?

connoisseur
3,192 Views

Sorry, forgot to mention that

 

Active IQ Unified Manager

Version: 9.7P1

 

ONTAP

NetApp Release 9.6P6:

mbeattie
3,187 Views

Hi Henrik,

 

You might be interested in this PowerShell Module I've developed for Active IQ 

 

/Matt

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

connoisseur
3,096 Views

Thank you very much.

 

Allthough I can only see:

If($SavingsGB){
[String]$uri += $("&space.efficiency.savings=" + ($SavingsGB * (1024 * 1024 * 1024)))
[Bool]$query = $True

 

Wich only os for global space saving (datacenter/storage/aggregates)

Nothing on volume level. 

Public