DescribeBackups SQL Server Example
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
DECLARE @sTmp0 nvarchar(max)
-- This example requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @rest int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Rest', @rest OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
DECLARE @authAws int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.AuthAws', @authAws OUT
EXEC sp_OASetProperty @authAws, 'AccessKey', 'AWS_ACCESS_KEY'
EXEC sp_OASetProperty @authAws, 'SecretKey', 'AWS_SECRET_KEY'
-- Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.)
EXEC sp_OASetProperty @authAws, 'Region', 'us-west-2'
EXEC sp_OASetProperty @authAws, 'ServiceName', 'fsx'
-- SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
EXEC sp_OAMethod @rest, 'SetAuthAws', @success OUT, @authAws
-- URL: https://fsx.us-west-2.amazonaws.com/
-- Use the same region as specified above.
EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'fsx.us-west-2.amazonaws.com', 443, 1, 1
IF @success <> 1
BEGIN
EXEC sp_OAGetProperty @rest, 'ConnectFailReason', @iTmp0 OUT
PRINT 'ConnectFailReason: ' + @iTmp0
EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
RETURN
END
-- The following code creates the JSON request body.
-- The JSON created by this code is shown below.
-- Use this online tool to generate code from sample JSON:
-- Generate Code to Create JSON
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'BackupIds[0]', 'string'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Filters[0].Name', 'string'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'Filters[0].Values[0]', 'string'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'MaxResults', 123
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'NextToken', 'string'
-- The JSON request body created by the above code:
-- {
-- "BackupIds": [
-- "string"
-- ],
-- "Filters": [
-- {
-- "Name": "string",
-- "Values": [
-- "string"
-- ]
-- }
-- ],
-- "MaxResults": number,
-- "NextToken": "string"
-- }
EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'Content-Type', 'application/x-amz-json-1.1'
EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'X-Amz-Target', 'AWSSimbaAPIService_v20180301.DescribeBackups'
DECLARE @sbRequestBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbRequestBody OUT
EXEC sp_OAMethod @json, 'EmitSb', @success OUT, @sbRequestBody
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @rest, 'FullRequestSb', @success OUT, 'POST', '/', @sbRequestBody, @sbResponseBody
IF @success <> 1
BEGIN
EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @respStatusCode OUT
PRINT 'response status code = ' + @respStatusCode
IF @respStatusCode <> 200
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @rest, 'ResponseHeader', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Response Body:'
EXEC sp_OAMethod @sbResponseBody, 'GetAsString', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
DECLARE @jResp int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
-- The following code parses the JSON response.
-- A sample JSON response is shown below the sample code.
-- Use this online tool to generate parsing code from sample JSON:
-- Generate Parsing Code from JSON
DECLARE @BackupId nvarchar(max)
DECLARE @CreationTime int
DECLARE @ActiveDirectoryId nvarchar(max)
DECLARE @DomainName nvarchar(max)
DECLARE @ResourceARN nvarchar(max)
DECLARE @Message nvarchar(max)
DECLARE @FileSystemCreationTime int
DECLARE @DNSName nvarchar(max)
DECLARE @FailureDetailsMessage nvarchar(max)
DECLARE @FileSystemId nvarchar(max)
DECLARE @FileSystemType nvarchar(max)
DECLARE @FileSystemTypeVersion nvarchar(max)
DECLARE @KmsKeyId nvarchar(max)
DECLARE @Lifecycle nvarchar(max)
DECLARE @AutomaticBackupRetentionDays int
DECLARE @CopyTagsToBackups int
DECLARE @DailyAutomaticBackupStartTime nvarchar(max)
DECLARE @DataCompressionType nvarchar(max)
DECLARE @AutoImportPolicy nvarchar(max)
DECLARE @ExportPath nvarchar(max)
DECLARE @ImportedFileChunkSize int
DECLARE @ImportPath nvarchar(max)
DECLARE @DataRepositoryConfigurationLifecycle nvarchar(max)
DECLARE @DeploymentType nvarchar(max)
DECLARE @DriveCacheType nvarchar(max)
DECLARE @Destination nvarchar(max)
DECLARE @Level nvarchar(max)
DECLARE @MountName nvarchar(max)
DECLARE @PerUnitStorageThroughput int
DECLARE @WeeklyMaintenanceStartTime nvarchar(max)
DECLARE @OntapConfigurationAutomaticBackupRetentionDays int
DECLARE @OntapConfigurationDailyAutomaticBackupStartTime nvarchar(max)
DECLARE @OntapConfigurationDeploymentType nvarchar(max)
DECLARE @Iops int
DECLARE @Mode nvarchar(max)
DECLARE @EndpointIpAddressRange nvarchar(max)
DECLARE @InterclusterDNSName nvarchar(max)
DECLARE @ManagementDNSName nvarchar(max)
DECLARE @PreferredSubnetId nvarchar(max)
DECLARE @ThroughputCapacity int
DECLARE @OntapConfigurationWeeklyMaintenanceStartTime nvarchar(max)
DECLARE @OpenZFSConfigurationAutomaticBackupRetentionDays int
DECLARE @OpenZFSConfigurationCopyTagsToBackups int
DECLARE @CopyTagsToVolumes int
DECLARE @OpenZFSConfigurationDailyAutomaticBackupStartTime nvarchar(max)
DECLARE @OpenZFSConfigurationDeploymentType nvarchar(max)
DECLARE @DiskIopsConfigurationIops int
DECLARE @DiskIopsConfigurationMode nvarchar(max)
DECLARE @RootVolumeId nvarchar(max)
DECLARE @OpenZFSConfigurationThroughputCapacity int
DECLARE @OpenZFSConfigurationWeeklyMaintenanceStartTime nvarchar(max)
DECLARE @OwnerId nvarchar(max)
DECLARE @FileSystemResourceARN nvarchar(max)
DECLARE @StorageCapacity int
DECLARE @StorageType nvarchar(max)
DECLARE @VpcId nvarchar(max)
DECLARE @WindowsConfigurationActiveDirectoryId nvarchar(max)
DECLARE @AuditLogDestination nvarchar(max)
DECLARE @FileAccessAuditLogLevel nvarchar(max)
DECLARE @FileShareAccessAuditLogLevel nvarchar(max)
DECLARE @WindowsConfigurationAutomaticBackupRetentionDays int
DECLARE @WindowsConfigurationCopyTagsToBackups int
DECLARE @WindowsConfigurationDailyAutomaticBackupStartTime nvarchar(max)
DECLARE @WindowsConfigurationDeploymentType nvarchar(max)
DECLARE @PreferredFileServerIp nvarchar(max)
DECLARE @WindowsConfigurationPreferredSubnetId nvarchar(max)
DECLARE @RemoteAdministrationEndpoint nvarchar(max)
DECLARE @SelfManagedActiveDirectoryConfigurationDomainName nvarchar(max)
DECLARE @FileSystemAdministratorsGroup nvarchar(max)
DECLARE @OrganizationalUnitDistinguishedName nvarchar(max)
DECLARE @UserName nvarchar(max)
DECLARE @WindowsConfigurationThroughputCapacity int
DECLARE @WindowsConfigurationWeeklyMaintenanceStartTime nvarchar(max)
DECLARE @ProgressPercent int
DECLARE @ResourceType nvarchar(max)
DECLARE @SourceBackupId nvarchar(max)
DECLARE @SourceBackupRegion nvarchar(max)
DECLARE @v_Type nvarchar(max)
DECLARE @VolumeCreationTime int
DECLARE @VolumeFileSystemId nvarchar(max)
DECLARE @VolumeLifecycle nvarchar(max)
DECLARE @LifecycleTransitionReasonMessage nvarchar(max)
DECLARE @Name nvarchar(max)
DECLARE @FlexCacheEndpointType nvarchar(max)
DECLARE @JunctionPath nvarchar(max)
DECLARE @OntapVolumeType nvarchar(max)
DECLARE @SecurityStyle nvarchar(max)
DECLARE @SizeInMegabytes int
DECLARE @StorageEfficiencyEnabled int
DECLARE @StorageVirtualMachineId nvarchar(max)
DECLARE @StorageVirtualMachineRoot int
DECLARE @CoolingPeriod int
DECLARE @TieringPolicyName nvarchar(max)
DECLARE @UUID nvarchar(max)
DECLARE @CopyTagsToSnapshots int
DECLARE @OpenZFSConfigurationDataCompressionType nvarchar(max)
DECLARE @CopyStrategy nvarchar(max)
DECLARE @SnapshotARN nvarchar(max)
DECLARE @ParentVolumeId nvarchar(max)
DECLARE @ReadOnly int
DECLARE @RecordSizeKiB int
DECLARE @StorageCapacityQuotaGiB int
DECLARE @StorageCapacityReservationGiB int
DECLARE @VolumePath nvarchar(max)
DECLARE @VolumeResourceARN nvarchar(max)
DECLARE @VolumeId nvarchar(max)
DECLARE @VolumeType nvarchar(max)
DECLARE @j int
DECLARE @count_j int
DECLARE @AdministrativeActionType nvarchar(max)
DECLARE @RequestTime int
DECLARE @Status nvarchar(max)
DECLARE @TargetFileSystemValues nvarchar(max)
DECLARE @TargetSnapshotValuesCreationTime int
DECLARE @TargetSnapshotValuesLifecycle nvarchar(max)
DECLARE @TargetSnapshotValuesName nvarchar(max)
DECLARE @TargetSnapshotValuesResourceARN nvarchar(max)
DECLARE @SnapshotId nvarchar(max)
DECLARE @TargetSnapshotValuesVolumeId nvarchar(max)
DECLARE @TargetVolumeValuesCreationTime int
DECLARE @TargetVolumeValuesFileSystemId nvarchar(max)
DECLARE @TargetVolumeValuesLifecycle nvarchar(max)
DECLARE @TargetVolumeValuesName nvarchar(max)
DECLARE @OntapConfigurationFlexCacheEndpointType nvarchar(max)
DECLARE @OntapConfigurationJunctionPath nvarchar(max)
DECLARE @OntapConfigurationOntapVolumeType nvarchar(max)
DECLARE @OntapConfigurationSecurityStyle nvarchar(max)
DECLARE @OntapConfigurationSizeInMegabytes int
DECLARE @OntapConfigurationStorageEfficiencyEnabled int
DECLARE @OntapConfigurationStorageVirtualMachineId nvarchar(max)
DECLARE @OntapConfigurationStorageVirtualMachineRoot int
DECLARE @TieringPolicyCoolingPeriod int
DECLARE @OntapConfigurationUUID nvarchar(max)
DECLARE @OpenZFSConfigurationCopyTagsToSnapshots int
DECLARE @OriginSnapshotCopyStrategy nvarchar(max)
DECLARE @OriginSnapshotSnapshotARN nvarchar(max)
DECLARE @OpenZFSConfigurationParentVolumeId nvarchar(max)
DECLARE @OpenZFSConfigurationReadOnly int
DECLARE @OpenZFSConfigurationRecordSizeKiB int
DECLARE @OpenZFSConfigurationStorageCapacityQuotaGiB int
DECLARE @OpenZFSConfigurationStorageCapacityReservationGiB int
DECLARE @OpenZFSConfigurationVolumePath nvarchar(max)
DECLARE @TargetVolumeValuesResourceARN nvarchar(max)
DECLARE @TargetVolumeValuesVolumeId nvarchar(max)
DECLARE @TargetVolumeValuesVolumeType nvarchar(max)
DECLARE @k int
DECLARE @count_k int
DECLARE @strVal nvarchar(max)
DECLARE @Key nvarchar(max)
DECLARE @Value nvarchar(max)
DECLARE @json1 int
DECLARE @i1 int
DECLARE @count_i1 int
DECLARE @Clients nvarchar(max)
DECLARE @j1 int
DECLARE @count_j1 int
DECLARE @Id int
DECLARE @TargetFileSystemValuesCreationTime int
DECLARE @TargetFileSystemValuesDNSName nvarchar(max)
DECLARE @TargetFileSystemValuesFileSystemId nvarchar(max)
DECLARE @TargetFileSystemValuesFileSystemType nvarchar(max)
DECLARE @TargetFileSystemValuesFileSystemTypeVersion nvarchar(max)
DECLARE @TargetFileSystemValuesKmsKeyId nvarchar(max)
DECLARE @TargetFileSystemValuesLifecycle nvarchar(max)
DECLARE @LustreConfigurationAutomaticBackupRetentionDays int
DECLARE @LustreConfigurationCopyTagsToBackups int
DECLARE @LustreConfigurationDailyAutomaticBackupStartTime nvarchar(max)
DECLARE @LustreConfigurationDataCompressionType nvarchar(max)
DECLARE @DataRepositoryConfigurationAutoImportPolicy nvarchar(max)
DECLARE @DataRepositoryConfigurationExportPath nvarchar(max)
DECLARE @DataRepositoryConfigurationImportedFileChunkSize int
DECLARE @DataRepositoryConfigurationImportPath nvarchar(max)
DECLARE @LustreConfigurationDeploymentType nvarchar(max)
DECLARE @LustreConfigurationDriveCacheType nvarchar(max)
DECLARE @LogConfigurationDestination nvarchar(max)
DECLARE @LogConfigurationLevel nvarchar(max)
DECLARE @LustreConfigurationMountName nvarchar(max)
DECLARE @LustreConfigurationPerUnitStorageThroughput int
DECLARE @LustreConfigurationWeeklyMaintenanceStartTime nvarchar(max)
DECLARE @OntapConfigurationEndpointIpAddressRange nvarchar(max)
DECLARE @OntapConfigurationPreferredSubnetId nvarchar(max)
DECLARE @OntapConfigurationThroughputCapacity int
DECLARE @OpenZFSConfigurationCopyTagsToVolumes int
DECLARE @OpenZFSConfigurationRootVolumeId nvarchar(max)
DECLARE @TargetFileSystemValuesOwnerId nvarchar(max)
DECLARE @TargetFileSystemValuesResourceARN nvarchar(max)
DECLARE @TargetFileSystemValuesStorageCapacity int
DECLARE @TargetFileSystemValuesStorageType nvarchar(max)
DECLARE @TargetFileSystemValuesVpcId nvarchar(max)
DECLARE @AuditLogConfigurationAuditLogDestination nvarchar(max)
DECLARE @AuditLogConfigurationFileAccessAuditLogLevel nvarchar(max)
DECLARE @AuditLogConfigurationFileShareAccessAuditLogLevel nvarchar(max)
DECLARE @WindowsConfigurationPreferredFileServerIp nvarchar(max)
DECLARE @WindowsConfigurationRemoteAdministrationEndpoint nvarchar(max)
DECLARE @SelfManagedActiveDirectoryConfigurationFileSystemAdministratorsGroup nvarchar(max)
DECLARE @SelfManagedActiveDirectoryConfigurationOrganizationalUnitDistinguishedName nvarchar(max)
DECLARE @SelfManagedActiveDirectoryConfigurationUserName nvarchar(max)
DECLARE @TargetSnapshotValuesSnapshotId nvarchar(max)
DECLARE @TargetVolumeValues nvarchar(max)
DECLARE @NextToken nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @NextToken OUT, 'NextToken'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'Backups'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @BackupId OUT, 'Backups[i].BackupId'
EXEC sp_OAMethod @jResp, 'IntOf', @CreationTime OUT, 'Backups[i].CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @ActiveDirectoryId OUT, 'Backups[i].DirectoryInformation.ActiveDirectoryId'
EXEC sp_OAMethod @jResp, 'StringOf', @DomainName OUT, 'Backups[i].DirectoryInformation.DomainName'
EXEC sp_OAMethod @jResp, 'StringOf', @ResourceARN OUT, 'Backups[i].DirectoryInformation.ResourceARN'
EXEC sp_OAMethod @jResp, 'StringOf', @Message OUT, 'Backups[i].FailureDetails.Message'
EXEC sp_OAMethod @jResp, 'IntOf', @FileSystemCreationTime OUT, 'Backups[i].FileSystem.CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @DNSName OUT, 'Backups[i].FileSystem.DNSName'
EXEC sp_OAMethod @jResp, 'StringOf', @FailureDetailsMessage OUT, 'Backups[i].FileSystem.FailureDetails.Message'
EXEC sp_OAMethod @jResp, 'StringOf', @FileSystemId OUT, 'Backups[i].FileSystem.FileSystemId'
EXEC sp_OAMethod @jResp, 'StringOf', @FileSystemType OUT, 'Backups[i].FileSystem.FileSystemType'
EXEC sp_OAMethod @jResp, 'StringOf', @FileSystemTypeVersion OUT, 'Backups[i].FileSystem.FileSystemTypeVersion'
EXEC sp_OAMethod @jResp, 'StringOf', @KmsKeyId OUT, 'Backups[i].FileSystem.KmsKeyId'
EXEC sp_OAMethod @jResp, 'StringOf', @Lifecycle OUT, 'Backups[i].FileSystem.Lifecycle'
EXEC sp_OAMethod @jResp, 'IntOf', @AutomaticBackupRetentionDays OUT, 'Backups[i].FileSystem.LustreConfiguration.AutomaticBackupRetentionDays'
EXEC sp_OAMethod @jResp, 'IntOf', @CopyTagsToBackups OUT, 'Backups[i].FileSystem.LustreConfiguration.CopyTagsToBackups'
EXEC sp_OAMethod @jResp, 'StringOf', @DailyAutomaticBackupStartTime OUT, 'Backups[i].FileSystem.LustreConfiguration.DailyAutomaticBackupStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @DataCompressionType OUT, 'Backups[i].FileSystem.LustreConfiguration.DataCompressionType'
EXEC sp_OAMethod @jResp, 'StringOf', @AutoImportPolicy OUT, 'Backups[i].FileSystem.LustreConfiguration.DataRepositoryConfiguration.AutoImportPolicy'
EXEC sp_OAMethod @jResp, 'StringOf', @ExportPath OUT, 'Backups[i].FileSystem.LustreConfiguration.DataRepositoryConfiguration.ExportPath'
EXEC sp_OAMethod @jResp, 'StringOf', @FailureDetailsMessage OUT, 'Backups[i].FileSystem.LustreConfiguration.DataRepositoryConfiguration.FailureDetails.Message'
EXEC sp_OAMethod @jResp, 'IntOf', @ImportedFileChunkSize OUT, 'Backups[i].FileSystem.LustreConfiguration.DataRepositoryConfiguration.ImportedFileChunkSize'
EXEC sp_OAMethod @jResp, 'StringOf', @ImportPath OUT, 'Backups[i].FileSystem.LustreConfiguration.DataRepositoryConfiguration.ImportPath'
EXEC sp_OAMethod @jResp, 'StringOf', @DataRepositoryConfigurationLifecycle OUT, 'Backups[i].FileSystem.LustreConfiguration.DataRepositoryConfiguration.Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @DeploymentType OUT, 'Backups[i].FileSystem.LustreConfiguration.DeploymentType'
EXEC sp_OAMethod @jResp, 'StringOf', @DriveCacheType OUT, 'Backups[i].FileSystem.LustreConfiguration.DriveCacheType'
EXEC sp_OAMethod @jResp, 'StringOf', @Destination OUT, 'Backups[i].FileSystem.LustreConfiguration.LogConfiguration.Destination'
EXEC sp_OAMethod @jResp, 'StringOf', @Level OUT, 'Backups[i].FileSystem.LustreConfiguration.LogConfiguration.Level'
EXEC sp_OAMethod @jResp, 'StringOf', @MountName OUT, 'Backups[i].FileSystem.LustreConfiguration.MountName'
EXEC sp_OAMethod @jResp, 'IntOf', @PerUnitStorageThroughput OUT, 'Backups[i].FileSystem.LustreConfiguration.PerUnitStorageThroughput'
EXEC sp_OAMethod @jResp, 'StringOf', @WeeklyMaintenanceStartTime OUT, 'Backups[i].FileSystem.LustreConfiguration.WeeklyMaintenanceStartTime'
EXEC sp_OAMethod @jResp, 'IntOf', @OntapConfigurationAutomaticBackupRetentionDays OUT, 'Backups[i].FileSystem.OntapConfiguration.AutomaticBackupRetentionDays'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationDailyAutomaticBackupStartTime OUT, 'Backups[i].FileSystem.OntapConfiguration.DailyAutomaticBackupStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationDeploymentType OUT, 'Backups[i].FileSystem.OntapConfiguration.DeploymentType'
EXEC sp_OAMethod @jResp, 'IntOf', @Iops OUT, 'Backups[i].FileSystem.OntapConfiguration.DiskIopsConfiguration.Iops'
EXEC sp_OAMethod @jResp, 'StringOf', @Mode OUT, 'Backups[i].FileSystem.OntapConfiguration.DiskIopsConfiguration.Mode'
EXEC sp_OAMethod @jResp, 'StringOf', @EndpointIpAddressRange OUT, 'Backups[i].FileSystem.OntapConfiguration.EndpointIpAddressRange'
EXEC sp_OAMethod @jResp, 'StringOf', @InterclusterDNSName OUT, 'Backups[i].FileSystem.OntapConfiguration.Endpoints.Intercluster.DNSName'
EXEC sp_OAMethod @jResp, 'StringOf', @ManagementDNSName OUT, 'Backups[i].FileSystem.OntapConfiguration.Endpoints.Management.DNSName'
EXEC sp_OAMethod @jResp, 'StringOf', @PreferredSubnetId OUT, 'Backups[i].FileSystem.OntapConfiguration.PreferredSubnetId'
EXEC sp_OAMethod @jResp, 'IntOf', @ThroughputCapacity OUT, 'Backups[i].FileSystem.OntapConfiguration.ThroughputCapacity'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationWeeklyMaintenanceStartTime OUT, 'Backups[i].FileSystem.OntapConfiguration.WeeklyMaintenanceStartTime'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationAutomaticBackupRetentionDays OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.AutomaticBackupRetentionDays'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationCopyTagsToBackups OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.CopyTagsToBackups'
EXEC sp_OAMethod @jResp, 'IntOf', @CopyTagsToVolumes OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.CopyTagsToVolumes'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationDailyAutomaticBackupStartTime OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.DailyAutomaticBackupStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationDeploymentType OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.DeploymentType'
EXEC sp_OAMethod @jResp, 'IntOf', @DiskIopsConfigurationIops OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.DiskIopsConfiguration.Iops'
EXEC sp_OAMethod @jResp, 'StringOf', @DiskIopsConfigurationMode OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.DiskIopsConfiguration.Mode'
EXEC sp_OAMethod @jResp, 'StringOf', @RootVolumeId OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.RootVolumeId'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationThroughputCapacity OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.ThroughputCapacity'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationWeeklyMaintenanceStartTime OUT, 'Backups[i].FileSystem.OpenZFSConfiguration.WeeklyMaintenanceStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @OwnerId OUT, 'Backups[i].FileSystem.OwnerId'
EXEC sp_OAMethod @jResp, 'StringOf', @FileSystemResourceARN OUT, 'Backups[i].FileSystem.ResourceARN'
EXEC sp_OAMethod @jResp, 'IntOf', @StorageCapacity OUT, 'Backups[i].FileSystem.StorageCapacity'
EXEC sp_OAMethod @jResp, 'StringOf', @StorageType OUT, 'Backups[i].FileSystem.StorageType'
EXEC sp_OAMethod @jResp, 'StringOf', @VpcId OUT, 'Backups[i].FileSystem.VpcId'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationActiveDirectoryId OUT, 'Backups[i].FileSystem.WindowsConfiguration.ActiveDirectoryId'
EXEC sp_OAMethod @jResp, 'StringOf', @AuditLogDestination OUT, 'Backups[i].FileSystem.WindowsConfiguration.AuditLogConfiguration.AuditLogDestination'
EXEC sp_OAMethod @jResp, 'StringOf', @FileAccessAuditLogLevel OUT, 'Backups[i].FileSystem.WindowsConfiguration.AuditLogConfiguration.FileAccessAuditLogLevel'
EXEC sp_OAMethod @jResp, 'StringOf', @FileShareAccessAuditLogLevel OUT, 'Backups[i].FileSystem.WindowsConfiguration.AuditLogConfiguration.FileShareAccessAuditLogLevel'
EXEC sp_OAMethod @jResp, 'IntOf', @WindowsConfigurationAutomaticBackupRetentionDays OUT, 'Backups[i].FileSystem.WindowsConfiguration.AutomaticBackupRetentionDays'
EXEC sp_OAMethod @jResp, 'IntOf', @WindowsConfigurationCopyTagsToBackups OUT, 'Backups[i].FileSystem.WindowsConfiguration.CopyTagsToBackups'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationDailyAutomaticBackupStartTime OUT, 'Backups[i].FileSystem.WindowsConfiguration.DailyAutomaticBackupStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationDeploymentType OUT, 'Backups[i].FileSystem.WindowsConfiguration.DeploymentType'
EXEC sp_OAMethod @jResp, 'StringOf', @PreferredFileServerIp OUT, 'Backups[i].FileSystem.WindowsConfiguration.PreferredFileServerIp'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationPreferredSubnetId OUT, 'Backups[i].FileSystem.WindowsConfiguration.PreferredSubnetId'
EXEC sp_OAMethod @jResp, 'StringOf', @RemoteAdministrationEndpoint OUT, 'Backups[i].FileSystem.WindowsConfiguration.RemoteAdministrationEndpoint'
EXEC sp_OAMethod @jResp, 'StringOf', @SelfManagedActiveDirectoryConfigurationDomainName OUT, 'Backups[i].FileSystem.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.DomainName'
EXEC sp_OAMethod @jResp, 'StringOf', @FileSystemAdministratorsGroup OUT, 'Backups[i].FileSystem.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.FileSystemAdministratorsGroup'
EXEC sp_OAMethod @jResp, 'StringOf', @OrganizationalUnitDistinguishedName OUT, 'Backups[i].FileSystem.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.OrganizationalUnitDistinguishedName'
EXEC sp_OAMethod @jResp, 'StringOf', @UserName OUT, 'Backups[i].FileSystem.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.UserName'
EXEC sp_OAMethod @jResp, 'IntOf', @WindowsConfigurationThroughputCapacity OUT, 'Backups[i].FileSystem.WindowsConfiguration.ThroughputCapacity'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationWeeklyMaintenanceStartTime OUT, 'Backups[i].FileSystem.WindowsConfiguration.WeeklyMaintenanceStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @KmsKeyId OUT, 'Backups[i].KmsKeyId'
EXEC sp_OAMethod @jResp, 'StringOf', @Lifecycle OUT, 'Backups[i].Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @OwnerId OUT, 'Backups[i].OwnerId'
EXEC sp_OAMethod @jResp, 'IntOf', @ProgressPercent OUT, 'Backups[i].ProgressPercent'
EXEC sp_OAMethod @jResp, 'StringOf', @ResourceARN OUT, 'Backups[i].ResourceARN'
EXEC sp_OAMethod @jResp, 'StringOf', @ResourceType OUT, 'Backups[i].ResourceType'
EXEC sp_OAMethod @jResp, 'StringOf', @SourceBackupId OUT, 'Backups[i].SourceBackupId'
EXEC sp_OAMethod @jResp, 'StringOf', @SourceBackupRegion OUT, 'Backups[i].SourceBackupRegion'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'Backups[i].Type'
EXEC sp_OAMethod @jResp, 'IntOf', @VolumeCreationTime OUT, 'Backups[i].Volume.CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @VolumeFileSystemId OUT, 'Backups[i].Volume.FileSystemId'
EXEC sp_OAMethod @jResp, 'StringOf', @VolumeLifecycle OUT, 'Backups[i].Volume.Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @LifecycleTransitionReasonMessage OUT, 'Backups[i].Volume.LifecycleTransitionReason.Message'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'Backups[i].Volume.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @FlexCacheEndpointType OUT, 'Backups[i].Volume.OntapConfiguration.FlexCacheEndpointType'
EXEC sp_OAMethod @jResp, 'StringOf', @JunctionPath OUT, 'Backups[i].Volume.OntapConfiguration.JunctionPath'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapVolumeType OUT, 'Backups[i].Volume.OntapConfiguration.OntapVolumeType'
EXEC sp_OAMethod @jResp, 'StringOf', @SecurityStyle OUT, 'Backups[i].Volume.OntapConfiguration.SecurityStyle'
EXEC sp_OAMethod @jResp, 'IntOf', @SizeInMegabytes OUT, 'Backups[i].Volume.OntapConfiguration.SizeInMegabytes'
EXEC sp_OAMethod @jResp, 'IntOf', @StorageEfficiencyEnabled OUT, 'Backups[i].Volume.OntapConfiguration.StorageEfficiencyEnabled'
EXEC sp_OAMethod @jResp, 'StringOf', @StorageVirtualMachineId OUT, 'Backups[i].Volume.OntapConfiguration.StorageVirtualMachineId'
EXEC sp_OAMethod @jResp, 'IntOf', @StorageVirtualMachineRoot OUT, 'Backups[i].Volume.OntapConfiguration.StorageVirtualMachineRoot'
EXEC sp_OAMethod @jResp, 'IntOf', @CoolingPeriod OUT, 'Backups[i].Volume.OntapConfiguration.TieringPolicy.CoolingPeriod'
EXEC sp_OAMethod @jResp, 'StringOf', @TieringPolicyName OUT, 'Backups[i].Volume.OntapConfiguration.TieringPolicy.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @UUID OUT, 'Backups[i].Volume.OntapConfiguration.UUID'
EXEC sp_OAMethod @jResp, 'IntOf', @CopyTagsToSnapshots OUT, 'Backups[i].Volume.OpenZFSConfiguration.CopyTagsToSnapshots'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationDataCompressionType OUT, 'Backups[i].Volume.OpenZFSConfiguration.DataCompressionType'
EXEC sp_OAMethod @jResp, 'StringOf', @CopyStrategy OUT, 'Backups[i].Volume.OpenZFSConfiguration.OriginSnapshot.CopyStrategy'
EXEC sp_OAMethod @jResp, 'StringOf', @SnapshotARN OUT, 'Backups[i].Volume.OpenZFSConfiguration.OriginSnapshot.SnapshotARN'
EXEC sp_OAMethod @jResp, 'StringOf', @ParentVolumeId OUT, 'Backups[i].Volume.OpenZFSConfiguration.ParentVolumeId'
EXEC sp_OAMethod @jResp, 'IntOf', @ReadOnly OUT, 'Backups[i].Volume.OpenZFSConfiguration.ReadOnly'
EXEC sp_OAMethod @jResp, 'IntOf', @RecordSizeKiB OUT, 'Backups[i].Volume.OpenZFSConfiguration.RecordSizeKiB'
EXEC sp_OAMethod @jResp, 'IntOf', @StorageCapacityQuotaGiB OUT, 'Backups[i].Volume.OpenZFSConfiguration.StorageCapacityQuotaGiB'
EXEC sp_OAMethod @jResp, 'IntOf', @StorageCapacityReservationGiB OUT, 'Backups[i].Volume.OpenZFSConfiguration.StorageCapacityReservationGiB'
EXEC sp_OAMethod @jResp, 'StringOf', @VolumePath OUT, 'Backups[i].Volume.OpenZFSConfiguration.VolumePath'
EXEC sp_OAMethod @jResp, 'StringOf', @VolumeResourceARN OUT, 'Backups[i].Volume.ResourceARN'
EXEC sp_OAMethod @jResp, 'StringOf', @VolumeId OUT, 'Backups[i].Volume.VolumeId'
EXEC sp_OAMethod @jResp, 'StringOf', @VolumeType OUT, 'Backups[i].Volume.VolumeType'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.AdministrativeActions'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @AdministrativeActionType OUT, 'Backups[i].FileSystem.AdministrativeActions[j].AdministrativeActionType'
EXEC sp_OAMethod @jResp, 'StringOf', @FailureDetailsMessage OUT, 'Backups[i].FileSystem.AdministrativeActions[j].FailureDetails.Message'
EXEC sp_OAMethod @jResp, 'IntOf', @ProgressPercent OUT, 'Backups[i].FileSystem.AdministrativeActions[j].ProgressPercent'
EXEC sp_OAMethod @jResp, 'IntOf', @RequestTime OUT, 'Backups[i].FileSystem.AdministrativeActions[j].RequestTime'
EXEC sp_OAMethod @jResp, 'StringOf', @Status OUT, 'Backups[i].FileSystem.AdministrativeActions[j].Status'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValues OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetFileSystemValues'
EXEC sp_OAMethod @jResp, 'IntOf', @TargetSnapshotValuesCreationTime OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesLifecycle OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @LifecycleTransitionReasonMessage OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.LifecycleTransitionReason.Message'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesName OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesResourceARN OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.ResourceARN'
EXEC sp_OAMethod @jResp, 'StringOf', @SnapshotId OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.SnapshotId'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesVolumeId OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.VolumeId'
EXEC sp_OAMethod @jResp, 'IntOf', @TargetVolumeValuesCreationTime OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetVolumeValuesFileSystemId OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.FileSystemId'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetVolumeValuesLifecycle OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @LifecycleTransitionReasonMessage OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.LifecycleTransitionReason.Message'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetVolumeValuesName OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationFlexCacheEndpointType OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.FlexCacheEndpointType'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationJunctionPath OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.JunctionPath'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationOntapVolumeType OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.OntapVolumeType'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationSecurityStyle OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.SecurityStyle'
EXEC sp_OAMethod @jResp, 'IntOf', @OntapConfigurationSizeInMegabytes OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.SizeInMegabytes'
EXEC sp_OAMethod @jResp, 'IntOf', @OntapConfigurationStorageEfficiencyEnabled OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.StorageEfficiencyEnabled'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationStorageVirtualMachineId OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.StorageVirtualMachineId'
EXEC sp_OAMethod @jResp, 'IntOf', @OntapConfigurationStorageVirtualMachineRoot OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.StorageVirtualMachineRoot'
EXEC sp_OAMethod @jResp, 'IntOf', @TieringPolicyCoolingPeriod OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.TieringPolicy.CoolingPeriod'
EXEC sp_OAMethod @jResp, 'StringOf', @TieringPolicyName OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.TieringPolicy.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationUUID OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OntapConfiguration.UUID'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationCopyTagsToSnapshots OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.CopyTagsToSnapshots'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationDataCompressionType OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.DataCompressionType'
EXEC sp_OAMethod @jResp, 'StringOf', @OriginSnapshotCopyStrategy OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.OriginSnapshot.CopyStrategy'
EXEC sp_OAMethod @jResp, 'StringOf', @OriginSnapshotSnapshotARN OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.OriginSnapshot.SnapshotARN'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationParentVolumeId OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.ParentVolumeId'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationReadOnly OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.ReadOnly'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationRecordSizeKiB OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.RecordSizeKiB'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationStorageCapacityQuotaGiB OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.StorageCapacityQuotaGiB'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationStorageCapacityReservationGiB OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.StorageCapacityReservationGiB'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationVolumePath OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.VolumePath'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetVolumeValuesResourceARN OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.ResourceARN'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetVolumeValuesVolumeId OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.VolumeId'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetVolumeValuesVolumeType OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.VolumeType'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.AdministrativeActions'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.AdministrativeActions[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.Tags'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.Tags[k].Key'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetSnapshotValues.Tags[k].Value'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.AdministrativeActions'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.AdministrativeActions[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.NfsExports'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'ObjectOf', @json1 OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.NfsExports[k]'
SELECT @i1 = 0
EXEC sp_OAMethod @json1, 'SizeOfArray', @count_i1 OUT, 'ClientConfigurations'
WHILE @i1 < @count_i1
BEGIN
EXEC sp_OASetProperty @json1, 'I', @i1
EXEC sp_OAMethod @json1, 'StringOf', @Clients OUT, 'ClientConfigurations[i].Clients'
SELECT @j1 = 0
EXEC sp_OAMethod @json1, 'SizeOfArray', @count_j1 OUT, 'ClientConfigurations[i].Options'
WHILE @j1 < @count_j1
BEGIN
EXEC sp_OASetProperty @json1, 'J', @j1
EXEC sp_OAMethod @json1, 'StringOf', @strVal OUT, 'ClientConfigurations[i].Options[j]'
SELECT @j1 = @j1 + 1
END
SELECT @i1 = @i1 + 1
END
EXEC @hr = sp_OADestroy @json1
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.UserAndGroupQuotas'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.UserAndGroupQuotas[k].Id'
EXEC sp_OAMethod @jResp, 'IntOf', @StorageCapacityQuotaGiB OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.UserAndGroupQuotas[k].StorageCapacityQuotaGiB'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.OpenZFSConfiguration.UserAndGroupQuotas[k].Type'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.Tags'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.Tags[k].Key'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'Backups[i].FileSystem.AdministrativeActions[j].TargetVolumeValues.Tags[k].Value'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.NetworkInterfaceIds'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.NetworkInterfaceIds[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.OntapConfiguration.Endpoints.Intercluster.IpAddresses'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.OntapConfiguration.Endpoints.Intercluster.IpAddresses[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.OntapConfiguration.Endpoints.Management.IpAddresses'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.OntapConfiguration.Endpoints.Management.IpAddresses[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.OntapConfiguration.RouteTableIds'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.OntapConfiguration.RouteTableIds[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.SubnetIds'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.SubnetIds[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.Tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'Backups[i].FileSystem.Tags[j].Key'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'Backups[i].FileSystem.Tags[j].Value'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.WindowsConfiguration.Aliases'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @Lifecycle OUT, 'Backups[i].FileSystem.WindowsConfiguration.Aliases[j].Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'Backups[i].FileSystem.WindowsConfiguration.Aliases[j].Name'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.WindowsConfiguration.MaintenanceOperationsInProgress'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.WindowsConfiguration.MaintenanceOperationsInProgress[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].FileSystem.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.DnsIps'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].FileSystem.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.DnsIps[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].Tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'Backups[i].Tags[j].Key'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'Backups[i].Tags[j].Value'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].Volume.AdministrativeActions'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @AdministrativeActionType OUT, 'Backups[i].Volume.AdministrativeActions[j].AdministrativeActionType'
EXEC sp_OAMethod @jResp, 'StringOf', @FailureDetailsMessage OUT, 'Backups[i].Volume.AdministrativeActions[j].FailureDetails.Message'
EXEC sp_OAMethod @jResp, 'IntOf', @ProgressPercent OUT, 'Backups[i].Volume.AdministrativeActions[j].ProgressPercent'
EXEC sp_OAMethod @jResp, 'IntOf', @RequestTime OUT, 'Backups[i].Volume.AdministrativeActions[j].RequestTime'
EXEC sp_OAMethod @jResp, 'StringOf', @Status OUT, 'Backups[i].Volume.AdministrativeActions[j].Status'
EXEC sp_OAMethod @jResp, 'IntOf', @TargetFileSystemValuesCreationTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesDNSName OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.DNSName'
EXEC sp_OAMethod @jResp, 'StringOf', @FailureDetailsMessage OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.FailureDetails.Message'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesFileSystemId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.FileSystemId'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesFileSystemType OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.FileSystemType'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesFileSystemTypeVersion OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.FileSystemTypeVersion'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesKmsKeyId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.KmsKeyId'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesLifecycle OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.Lifecycle'
EXEC sp_OAMethod @jResp, 'IntOf', @LustreConfigurationAutomaticBackupRetentionDays OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.AutomaticBackupRetentionDays'
EXEC sp_OAMethod @jResp, 'IntOf', @LustreConfigurationCopyTagsToBackups OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.CopyTagsToBackups'
EXEC sp_OAMethod @jResp, 'StringOf', @LustreConfigurationDailyAutomaticBackupStartTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DailyAutomaticBackupStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @LustreConfigurationDataCompressionType OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DataCompressionType'
EXEC sp_OAMethod @jResp, 'StringOf', @DataRepositoryConfigurationAutoImportPolicy OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DataRepositoryConfiguration.AutoImportPolicy'
EXEC sp_OAMethod @jResp, 'StringOf', @DataRepositoryConfigurationExportPath OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DataRepositoryConfiguration.ExportPath'
EXEC sp_OAMethod @jResp, 'StringOf', @FailureDetailsMessage OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DataRepositoryConfiguration.FailureDetails.Message'
EXEC sp_OAMethod @jResp, 'IntOf', @DataRepositoryConfigurationImportedFileChunkSize OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DataRepositoryConfiguration.ImportedFileChunkSize'
EXEC sp_OAMethod @jResp, 'StringOf', @DataRepositoryConfigurationImportPath OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DataRepositoryConfiguration.ImportPath'
EXEC sp_OAMethod @jResp, 'StringOf', @DataRepositoryConfigurationLifecycle OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DataRepositoryConfiguration.Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @LustreConfigurationDeploymentType OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DeploymentType'
EXEC sp_OAMethod @jResp, 'StringOf', @LustreConfigurationDriveCacheType OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.DriveCacheType'
EXEC sp_OAMethod @jResp, 'StringOf', @LogConfigurationDestination OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.LogConfiguration.Destination'
EXEC sp_OAMethod @jResp, 'StringOf', @LogConfigurationLevel OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.LogConfiguration.Level'
EXEC sp_OAMethod @jResp, 'StringOf', @LustreConfigurationMountName OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.MountName'
EXEC sp_OAMethod @jResp, 'IntOf', @LustreConfigurationPerUnitStorageThroughput OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.PerUnitStorageThroughput'
EXEC sp_OAMethod @jResp, 'StringOf', @LustreConfigurationWeeklyMaintenanceStartTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.LustreConfiguration.WeeklyMaintenanceStartTime'
EXEC sp_OAMethod @jResp, 'IntOf', @OntapConfigurationAutomaticBackupRetentionDays OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.AutomaticBackupRetentionDays'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationDailyAutomaticBackupStartTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.DailyAutomaticBackupStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationDeploymentType OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.DeploymentType'
EXEC sp_OAMethod @jResp, 'IntOf', @DiskIopsConfigurationIops OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.DiskIopsConfiguration.Iops'
EXEC sp_OAMethod @jResp, 'StringOf', @DiskIopsConfigurationMode OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.DiskIopsConfiguration.Mode'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationEndpointIpAddressRange OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.EndpointIpAddressRange'
EXEC sp_OAMethod @jResp, 'StringOf', @InterclusterDNSName OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.Endpoints.Intercluster.DNSName'
EXEC sp_OAMethod @jResp, 'StringOf', @ManagementDNSName OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.Endpoints.Management.DNSName'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationPreferredSubnetId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.PreferredSubnetId'
EXEC sp_OAMethod @jResp, 'IntOf', @OntapConfigurationThroughputCapacity OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.ThroughputCapacity'
EXEC sp_OAMethod @jResp, 'StringOf', @OntapConfigurationWeeklyMaintenanceStartTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.WeeklyMaintenanceStartTime'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationAutomaticBackupRetentionDays OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.AutomaticBackupRetentionDays'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationCopyTagsToBackups OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.CopyTagsToBackups'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationCopyTagsToVolumes OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.CopyTagsToVolumes'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationDailyAutomaticBackupStartTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.DailyAutomaticBackupStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationDeploymentType OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.DeploymentType'
EXEC sp_OAMethod @jResp, 'IntOf', @DiskIopsConfigurationIops OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.DiskIopsConfiguration.Iops'
EXEC sp_OAMethod @jResp, 'StringOf', @DiskIopsConfigurationMode OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.DiskIopsConfiguration.Mode'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationRootVolumeId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.RootVolumeId'
EXEC sp_OAMethod @jResp, 'IntOf', @OpenZFSConfigurationThroughputCapacity OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.ThroughputCapacity'
EXEC sp_OAMethod @jResp, 'StringOf', @OpenZFSConfigurationWeeklyMaintenanceStartTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OpenZFSConfiguration.WeeklyMaintenanceStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesOwnerId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OwnerId'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesResourceARN OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.ResourceARN'
EXEC sp_OAMethod @jResp, 'IntOf', @TargetFileSystemValuesStorageCapacity OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.StorageCapacity'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesStorageType OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.StorageType'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetFileSystemValuesVpcId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.VpcId'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationActiveDirectoryId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.ActiveDirectoryId'
EXEC sp_OAMethod @jResp, 'StringOf', @AuditLogConfigurationAuditLogDestination OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.AuditLogConfiguration.AuditLogDestination'
EXEC sp_OAMethod @jResp, 'StringOf', @AuditLogConfigurationFileAccessAuditLogLevel OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.AuditLogConfiguration.FileAccessAuditLogLevel'
EXEC sp_OAMethod @jResp, 'StringOf', @AuditLogConfigurationFileShareAccessAuditLogLevel OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.AuditLogConfiguration.FileShareAccessAuditLogLevel'
EXEC sp_OAMethod @jResp, 'IntOf', @WindowsConfigurationAutomaticBackupRetentionDays OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.AutomaticBackupRetentionDays'
EXEC sp_OAMethod @jResp, 'IntOf', @WindowsConfigurationCopyTagsToBackups OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.CopyTagsToBackups'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationDailyAutomaticBackupStartTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.DailyAutomaticBackupStartTime'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationDeploymentType OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.DeploymentType'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationPreferredFileServerIp OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.PreferredFileServerIp'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationPreferredSubnetId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.PreferredSubnetId'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationRemoteAdministrationEndpoint OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.RemoteAdministrationEndpoint'
EXEC sp_OAMethod @jResp, 'StringOf', @SelfManagedActiveDirectoryConfigurationDomainName OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.DomainName'
EXEC sp_OAMethod @jResp, 'StringOf', @SelfManagedActiveDirectoryConfigurationFileSystemAdministratorsGroup OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.FileSystemAdministratorsGroup'
EXEC sp_OAMethod @jResp, 'StringOf', @SelfManagedActiveDirectoryConfigurationOrganizationalUnitDistinguishedName OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.OrganizationalUnitDistinguishedName'
EXEC sp_OAMethod @jResp, 'StringOf', @SelfManagedActiveDirectoryConfigurationUserName OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.UserName'
EXEC sp_OAMethod @jResp, 'IntOf', @WindowsConfigurationThroughputCapacity OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.ThroughputCapacity'
EXEC sp_OAMethod @jResp, 'StringOf', @WindowsConfigurationWeeklyMaintenanceStartTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.WeeklyMaintenanceStartTime'
EXEC sp_OAMethod @jResp, 'IntOf', @TargetSnapshotValuesCreationTime OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.CreationTime'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesLifecycle OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @LifecycleTransitionReasonMessage OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.LifecycleTransitionReason.Message'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesName OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesResourceARN OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.ResourceARN'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesSnapshotId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.SnapshotId'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetSnapshotValuesVolumeId OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.VolumeId'
EXEC sp_OAMethod @jResp, 'StringOf', @TargetVolumeValues OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetVolumeValues'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.AdministrativeActions'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.AdministrativeActions[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.NetworkInterfaceIds'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.NetworkInterfaceIds[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.Endpoints.Intercluster.IpAddresses'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.Endpoints.Intercluster.IpAddresses[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.Endpoints.Management.IpAddresses'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.Endpoints.Management.IpAddresses[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.RouteTableIds'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.OntapConfiguration.RouteTableIds[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.SubnetIds'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.SubnetIds[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.Tags'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.Tags[k].Key'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.Tags[k].Value'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.Aliases'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @Lifecycle OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.Aliases[k].Lifecycle'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.Aliases[k].Name'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.MaintenanceOperationsInProgress'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.MaintenanceOperationsInProgress[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.DnsIps'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetFileSystemValues.WindowsConfiguration.SelfManagedActiveDirectoryConfiguration.DnsIps[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.AdministrativeActions'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.AdministrativeActions[k]'
SELECT @k = @k + 1
END
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.Tags'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.Tags[k].Key'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'Backups[i].Volume.AdministrativeActions[j].TargetSnapshotValues.Tags[k].Value'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].Volume.OpenZFSConfiguration.NfsExports'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'Backups[i].Volume.OpenZFSConfiguration.NfsExports[j].ClientConfigurations'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @Clients OUT, 'Backups[i].Volume.OpenZFSConfiguration.NfsExports[j].ClientConfigurations[k].Clients'
EXEC sp_OAMethod @jResp, 'ObjectOf', @json1 OUT, 'Backups[i].Volume.OpenZFSConfiguration.NfsExports[j].ClientConfigurations[k]'
SELECT @i1 = 0
EXEC sp_OAMethod @json1, 'SizeOfArray', @count_i1 OUT, 'Options'
WHILE @i1 < @count_i1
BEGIN
EXEC sp_OASetProperty @json1, 'I', @i1
EXEC sp_OAMethod @json1, 'StringOf', @strVal OUT, 'Options[i]'
SELECT @i1 = @i1 + 1
END
EXEC @hr = sp_OADestroy @json1
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].Volume.OpenZFSConfiguration.UserAndGroupQuotas'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'IntOf', @Id OUT, 'Backups[i].Volume.OpenZFSConfiguration.UserAndGroupQuotas[j].Id'
EXEC sp_OAMethod @jResp, 'IntOf', @StorageCapacityQuotaGiB OUT, 'Backups[i].Volume.OpenZFSConfiguration.UserAndGroupQuotas[j].StorageCapacityQuotaGiB'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'Backups[i].Volume.OpenZFSConfiguration.UserAndGroupQuotas[j].Type'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'Backups[i].Volume.Tags'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @Key OUT, 'Backups[i].Volume.Tags[j].Key'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'Backups[i].Volume.Tags[j].Value'
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
-- A sample JSON response body parsed by the above code:
-- {
-- "Backups": [
-- {
-- "BackupId": "string",
-- "CreationTime": number,
-- "DirectoryInformation": {
-- "ActiveDirectoryId": "string",
-- "DomainName": "string",
-- "ResourceARN": "string"
-- },
-- "FailureDetails": {
-- "Message": "string"
-- },
-- "FileSystem": {
-- "AdministrativeActions": [
-- {
-- "AdministrativeActionType": "string",
-- "FailureDetails": {
-- "Message": "string"
-- },
-- "ProgressPercent": number,
-- "RequestTime": number,
-- "Status": "string",
-- "TargetFileSystemValues": "FileSystem",
-- "TargetSnapshotValues": {
-- "AdministrativeActions": [
-- "AdministrativeAction"
-- ],
-- "CreationTime": number,
-- "Lifecycle": "string",
-- "LifecycleTransitionReason": {
-- "Message": "string"
-- },
-- "Name": "string",
-- "ResourceARN": "string",
-- "SnapshotId": "string",
-- "Tags": [
-- {
-- "Key": "string",
-- "Value": "string"
-- }
-- ],
-- "VolumeId": "string"
-- },
-- "TargetVolumeValues": {
-- "AdministrativeActions": [
-- "AdministrativeAction"
-- ],
-- "CreationTime": number,
-- "FileSystemId": "string",
-- "Lifecycle": "string",
-- "LifecycleTransitionReason": {
-- "Message": "string"
-- },
-- "Name": "string",
-- "OntapConfiguration": {
-- "FlexCacheEndpointType": "string",
-- "JunctionPath": "string",
-- "OntapVolumeType": "string",
-- "SecurityStyle": "string",
-- "SizeInMegabytes": number,
-- "StorageEfficiencyEnabled": boolean,
-- "StorageVirtualMachineId": "string",
-- "StorageVirtualMachineRoot": boolean,
-- "TieringPolicy": {
-- "CoolingPeriod": number,
-- "Name": "string"
-- },
-- "UUID": "string"
-- },
-- "OpenZFSConfiguration": {
-- "CopyTagsToSnapshots": boolean,
-- "DataCompressionType": "string",
-- "NfsExports": [
-- {
-- "ClientConfigurations": [
-- {
-- "Clients": "string",
-- "Options": [
-- "string"
-- ]
-- }
-- ]
-- }
-- ],
-- "OriginSnapshot": {
-- "CopyStrategy": "string",
-- "SnapshotARN": "string"
-- },
-- "ParentVolumeId": "string",
-- "ReadOnly": boolean,
-- "RecordSizeKiB": number,
-- "StorageCapacityQuotaGiB": number,
-- "StorageCapacityReservationGiB": number,
-- "UserAndGroupQuotas": [
-- {
-- "Id": number,
-- "StorageCapacityQuotaGiB": number,
-- "Type": "string"
-- }
-- ],
-- "VolumePath": "string"
-- },
-- "ResourceARN": "string",
-- "Tags": [
-- {
-- "Key": "string",
-- "Value": "string"
-- }
-- ],
-- "VolumeId": "string",
-- "VolumeType": "string"
-- }
-- }
-- ],
-- "CreationTime": number,
-- "DNSName": "string",
-- "FailureDetails": {
-- "Message": "string"
-- },
-- "FileSystemId": "string",
-- "FileSystemType": "string",
-- "FileSystemTypeVersion": "string",
-- "KmsKeyId": "string",
-- "Lifecycle": "string",
-- "LustreConfiguration": {
-- "AutomaticBackupRetentionDays": number,
-- "CopyTagsToBackups": boolean,
-- "DailyAutomaticBackupStartTime": "string",
-- "DataCompressionType": "string",
-- "DataRepositoryConfiguration": {
-- "AutoImportPolicy": "string",
-- "ExportPath": "string",
-- "FailureDetails": {
-- "Message": "string"
-- },
-- "ImportedFileChunkSize": number,
-- "ImportPath": "string",
-- "Lifecycle": "string"
-- },
-- "DeploymentType": "string",
-- "DriveCacheType": "string",
-- "LogConfiguration": {
-- "Destination": "string",
-- "Level": "string"
-- },
-- "MountName": "string",
-- "PerUnitStorageThroughput": number,
-- "WeeklyMaintenanceStartTime": "string"
-- },
-- "NetworkInterfaceIds": [
-- "string"
-- ],
-- "OntapConfiguration": {
-- "AutomaticBackupRetentionDays": number,
-- "DailyAutomaticBackupStartTime": "string",
-- "DeploymentType": "string",
-- "DiskIopsConfiguration": {
-- "Iops": number,
-- "Mode": "string"
-- },
-- "EndpointIpAddressRange": "string",
-- "Endpoints": {
-- "Intercluster": {
-- "DNSName": "string",
-- "IpAddresses": [
-- "string"
-- ]
-- },
-- "Management": {
-- "DNSName": "string",
-- "IpAddresses": [
-- "string"
-- ]
-- }
-- },
-- "PreferredSubnetId": "string",
-- "RouteTableIds": [
-- "string"
-- ],
-- "ThroughputCapacity": number,
-- "WeeklyMaintenanceStartTime": "string"
-- },
-- "OpenZFSConfiguration": {
-- "AutomaticBackupRetentionDays": number,
-- "CopyTagsToBackups": boolean,
-- "CopyTagsToVolumes": boolean,
-- "DailyAutomaticBackupStartTime": "string",
-- "DeploymentType": "string",
-- "DiskIopsConfiguration": {
-- "Iops": number,
-- "Mode": "string"
-- },
-- "RootVolumeId": "string",
-- "ThroughputCapacity": number,
-- "WeeklyMaintenanceStartTime": "string"
-- },
-- "OwnerId": "string",
-- "ResourceARN": "string",
-- "StorageCapacity": number,
-- "StorageType": "string",
-- "SubnetIds": [
-- "string"
-- ],
-- "Tags": [
-- {
-- "Key": "string",
-- "Value": "string"
-- }
-- ],
-- "VpcId": "string",
-- "WindowsConfiguration": {
-- "ActiveDirectoryId": "string",
-- "Aliases": [
-- {
-- "Lifecycle": "string",
-- "Name": "string"
-- }
-- ],
-- "AuditLogConfiguration": {
-- "AuditLogDestination": "string",
-- "FileAccessAuditLogLevel": "string",
-- "FileShareAccessAuditLogLevel": "string"
-- },
-- "AutomaticBackupRetentionDays": number,
-- "CopyTagsToBackups": boolean,
-- "DailyAutomaticBackupStartTime": "string",
-- "DeploymentType": "string",
-- "MaintenanceOperationsInProgress": [
-- "string"
-- ],
-- "PreferredFileServerIp": "string",
-- "PreferredSubnetId": "string",
-- "RemoteAdministrationEndpoint": "string",
-- "SelfManagedActiveDirectoryConfiguration": {
-- "DnsIps": [
-- "string"
-- ],
-- "DomainName": "string",
-- "FileSystemAdministratorsGroup": "string",
-- "OrganizationalUnitDistinguishedName": "string",
-- "UserName": "string"
-- },
-- "ThroughputCapacity": number,
-- "WeeklyMaintenanceStartTime": "string"
-- }
-- },
-- "KmsKeyId": "string",
-- "Lifecycle": "string",
-- "OwnerId": "string",
-- "ProgressPercent": number,
-- "ResourceARN": "string",
-- "ResourceType": "string",
-- "SourceBackupId": "string",
-- "SourceBackupRegion": "string",
-- "Tags": [
-- {
-- "Key": "string",
-- "Value": "string"
-- }
-- ],
-- "Type": "string",
-- "Volume": {
-- "AdministrativeActions": [
-- {
-- "AdministrativeActionType": "string",
-- "FailureDetails": {
-- "Message": "string"
-- },
-- "ProgressPercent": number,
-- "RequestTime": number,
-- "Status": "string",
-- "TargetFileSystemValues": {
-- "AdministrativeActions": [
-- "AdministrativeAction"
-- ],
-- "CreationTime": number,
-- "DNSName": "string",
-- "FailureDetails": {
-- "Message": "string"
-- },
-- "FileSystemId": "string",
-- "FileSystemType": "string",
-- "FileSystemTypeVersion": "string",
-- "KmsKeyId": "string",
-- "Lifecycle": "string",
-- "LustreConfiguration": {
-- "AutomaticBackupRetentionDays": number,
-- "CopyTagsToBackups": boolean,
-- "DailyAutomaticBackupStartTime": "string",
-- "DataCompressionType": "string",
-- "DataRepositoryConfiguration": {
-- "AutoImportPolicy": "string",
-- "ExportPath": "string",
-- "FailureDetails": {
-- "Message": "string"
-- },
-- "ImportedFileChunkSize": number,
-- "ImportPath": "string",
-- "Lifecycle": "string"
-- },
-- "DeploymentType": "string",
-- "DriveCacheType": "string",
-- "LogConfiguration": {
-- "Destination": "string",
-- "Level": "string"
-- },
-- "MountName": "string",
-- "PerUnitStorageThroughput": number,
-- "WeeklyMaintenanceStartTime": "string"
-- },
-- "NetworkInterfaceIds": [
-- "string"
-- ],
-- "OntapConfiguration": {
-- "AutomaticBackupRetentionDays": number,
-- "DailyAutomaticBackupStartTime": "string",
-- "DeploymentType": "string",
-- "DiskIopsConfiguration": {
-- "Iops": number,
-- "Mode": "string"
-- },
-- "EndpointIpAddressRange": "string",
-- "Endpoints": {
-- "Intercluster": {
-- "DNSName": "string",
-- "IpAddresses": [
-- "string"
-- ]
-- },
-- "Management": {
-- "DNSName": "string",
-- "IpAddresses": [
-- "string"
-- ]
-- }
-- },
-- "PreferredSubnetId": "string",
-- "RouteTableIds": [
-- "string"
-- ],
-- "ThroughputCapacity": number,
-- "WeeklyMaintenanceStartTime": "string"
-- },
-- "OpenZFSConfiguration": {
-- "AutomaticBackupRetentionDays": number,
-- "CopyTagsToBackups": boolean,
-- "CopyTagsToVolumes": boolean,
-- "DailyAutomaticBackupStartTime": "string",
-- "DeploymentType": "string",
-- "DiskIopsConfiguration": {
-- "Iops": number,
-- "Mode": "string"
-- },
-- "RootVolumeId": "string",
-- "ThroughputCapacity": number,
-- "WeeklyMaintenanceStartTime": "string"
-- },
-- "OwnerId": "string",
-- "ResourceARN": "string",
-- "StorageCapacity": number,
-- "StorageType": "string",
-- "SubnetIds": [
-- "string"
-- ],
-- "Tags": [
-- {
-- "Key": "string",
-- "Value": "string"
-- }
-- ],
-- "VpcId": "string",
-- "WindowsConfiguration": {
-- "ActiveDirectoryId": "string",
-- "Aliases": [
-- {
-- "Lifecycle": "string",
-- "Name": "string"
-- }
-- ],
-- "AuditLogConfiguration": {
-- "AuditLogDestination": "string",
-- "FileAccessAuditLogLevel": "string",
-- "FileShareAccessAuditLogLevel": "string"
-- },
-- "AutomaticBackupRetentionDays": number,
-- "CopyTagsToBackups": boolean,
-- "DailyAutomaticBackupStartTime": "string",
-- "DeploymentType": "string",
-- "MaintenanceOperationsInProgress": [
-- "string"
-- ],
-- "PreferredFileServerIp": "string",
-- "PreferredSubnetId": "string",
-- "RemoteAdministrationEndpoint": "string",
-- "SelfManagedActiveDirectoryConfiguration": {
-- "DnsIps": [
-- "string"
-- ],
-- "DomainName": "string",
-- "FileSystemAdministratorsGroup": "string",
-- "OrganizationalUnitDistinguishedName": "string",
-- "UserName": "string"
-- },
-- "ThroughputCapacity": number,
-- "WeeklyMaintenanceStartTime": "string"
-- }
-- },
-- "TargetSnapshotValues": {
-- "AdministrativeActions": [
-- "AdministrativeAction"
-- ],
-- "CreationTime": number,
-- "Lifecycle": "string",
-- "LifecycleTransitionReason": {
-- "Message": "string"
-- },
-- "Name": "string",
-- "ResourceARN": "string",
-- "SnapshotId": "string",
-- "Tags": [
-- {
-- "Key": "string",
-- "Value": "string"
-- }
-- ],
-- "VolumeId": "string"
-- },
-- "TargetVolumeValues": "Volume"
-- }
-- ],
-- "CreationTime": number,
-- "FileSystemId": "string",
-- "Lifecycle": "string",
-- "LifecycleTransitionReason": {
-- "Message": "string"
-- },
-- "Name": "string",
-- "OntapConfiguration": {
-- "FlexCacheEndpointType": "string",
-- "JunctionPath": "string",
-- "OntapVolumeType": "string",
-- "SecurityStyle": "string",
-- "SizeInMegabytes": number,
-- "StorageEfficiencyEnabled": boolean,
-- "StorageVirtualMachineId": "string",
-- "StorageVirtualMachineRoot": boolean,
-- "TieringPolicy": {
-- "CoolingPeriod": number,
-- "Name": "string"
-- },
-- "UUID": "string"
-- },
-- "OpenZFSConfiguration": {
-- "CopyTagsToSnapshots": boolean,
-- "DataCompressionType": "string",
-- "NfsExports": [
-- {
-- "ClientConfigurations": [
-- {
-- "Clients": "string",
-- "Options": [
-- "string"
-- ]
-- }
-- ]
-- }
-- ],
-- "OriginSnapshot": {
-- "CopyStrategy": "string",
-- "SnapshotARN": "string"
-- },
-- "ParentVolumeId": "string",
-- "ReadOnly": boolean,
-- "RecordSizeKiB": number,
-- "StorageCapacityQuotaGiB": number,
-- "StorageCapacityReservationGiB": number,
-- "UserAndGroupQuotas": [
-- {
-- "Id": number,
-- "StorageCapacityQuotaGiB": number,
-- "Type": "string"
-- }
-- ],
-- "VolumePath": "string"
-- },
-- "ResourceARN": "string",
-- "Tags": [
-- {
-- "Key": "string",
-- "Value": "string"
-- }
-- ],
-- "VolumeId": "string",
-- "VolumeType": "string"
-- }
-- }
-- ],
-- "NextToken": "string"
-- }
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
