queries
Creates, updates, deletes, gets or lists a queries resource.
Overview
| Name | queries |
| Type | Resource |
| Id | azure.cost_management.queries |
Fields
The following fields are returned by SELECT queries:
SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
usage | exec | scope, type, timeframe, dataset | Query the usage data for scope defined. | |
usage_by_external_cloud_provider_type | exec | externalCloudProviderType, externalCloudProviderId, type, timeframe, dataset | Query the usage data for external cloud provider type defined. |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
externalCloudProviderId | string | This can be '{externalSubscriptionId}' for linked account or '{externalBillingAccountId}' for consolidated account used with dimension/query operations. |
externalCloudProviderType | string | The external cloud provider type associated with dimension/query operations. This includes 'externalSubscriptions' for linked account and 'externalBillingAccounts' for consolidated account. |
scope | string | The scope associated with query and export operations. This includes '/subscriptions/{subscriptionId}/' for subscription scope, '/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}' for resourceGroup scope, '/providers/Microsoft.Billing/billingAccounts/{billingAccountId}' for Billing Account scope and '/providers/Microsoft.Billing/billingAccounts/{billingAccountId}/departments/{departmentId}' for Department scope, '/providers/Microsoft.Billing/billingAccounts/{billingAccountId}/enrollmentAccounts/{enrollmentAccountId}' for EnrollmentAccount scope, '/providers/Microsoft.Management/managementGroups/{managementGroupId} for Management Group scope, '/providers/Microsoft.Billing/billingAccounts/{billingAccountId}/billingProfiles/{billingProfileId}' for billingProfile scope, '/providers/Microsoft.Billing/billingAccounts/{billingAccountId}/billingProfiles/{billingProfileId}/invoiceSections/{invoiceSectionId}' for invoiceSection scope, and '/providers/Microsoft.Billing/billingAccounts/{billingAccountId}/customers/{customerId}' specific for partners. |
Lifecycle Methods
- usage
- usage_by_external_cloud_provider_type
Query the usage data for scope defined.
EXEC azure.cost_management.queries.usage
@scope='{{ scope }}' --required
@@json=
'{
"type": "{{ type }}",
"timeframe": "{{ timeframe }}",
"timePeriod": "{{ timePeriod }}",
"dataset": "{{ dataset }}"
}'
;
Query the usage data for external cloud provider type defined.
EXEC azure.cost_management.queries.usage_by_external_cloud_provider_type
@externalCloudProviderType='{{ externalCloudProviderType }}' --required,
@externalCloudProviderId='{{ externalCloudProviderId }}' --required
@@json=
'{
"type": "{{ type }}",
"timeframe": "{{ timeframe }}",
"timePeriod": "{{ timePeriod }}",
"dataset": "{{ dataset }}"
}'
;