I download the the Storage Automation workflow to automate the converison of Snapmirror relationships to Snapvault
http://automationstore.netapp.com/pack-detail.shtml?packUuid=449970c7-0103-4226-ba81-125084621689&packVersion=1.0.2
The workflow does not appear to work. After digging into the script it looks like the workflow was written for MetroCluster. Does anyone have the script for non-Metrocluster.
This is the user inputs for the Destination Cluster:
SELECT
cluster.name AS 'Cluster Name',
cluster.primary_address AS 'Cluster Primary Address',
cluster.version AS 'Cluster Version'
FROM
cm_storage.cluster cluster,
cm_storage.volume volume,
cm_storage.snapmirror_metrocluster snapmirror_metrocluster,
cm_storage.vserver vserver,
cm_storage.cluster_license cluster_license
WHERE
volume.id = snapmirror_metrocluster.secondary_volume_id
AND vserver.id = volume.vserver_id
AND cluster.id = vserver.cluster_id
AND cluster_license.cluster_id = cluster.id
AND cluster_license.license = 'snapmirror'
AND cluster.version >='8.2.0'
AND snapmirror_metrocluster.type = 'data_protection'
AND snapmirror_metrocluster.relationship_control_plane = 'v2'
AND snapmirror_metrocluster.state != 'uninitialized'
GROUP BY
cluster.name