SSIS Components for Azure Resource Management

Build 21.0.7930


Gets all subscriptions for a tenant.

Table Specific Information

The component will use the Azure Resource Management APIs to process filters that refer to SubscriptionId and will process other filters client-side within itself.

For example, the following query is processed server side:

SELECT * FROM Subscriptions WHERE SubscriptionId='abcd-abcd-abcd'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.


Name Type Description
SubscriptionId [KEY] String The subscription ID.
Id String The fully qualified ID for the subscription.
DisplayName String The subscription display name.
AuthorizationSource String The authorization source of the request. Valid values are one or more combinations of Legacy, RoleBased, Bypassed, Direct and Management. For example, 'Legacy, RoleBased'.
State String The subscription state. Possible values are Enabled, Warned, PastDue, Disabled, and Deleted.
SubscriptionLocationPlacementId String The subscription location placement ID. The ID indicates which regions are visible for a subscription. For example, a subscription with a location placement Id of Public_2014-09-01 has access to Azure public regions.
SubscriptionQuotaId String The subscription quota ID.
SubscriptionSpendingLimit String The subscription spending limit.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930