Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

TPAzureSubscription

Data source: AzureDashboardAS

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information'[TPID],
'Geography'[Area],
'Geography'[Subsidiary],
'Azure Subscription'[Subscription GUID],
'Azure Subscription'[Subscription Created Date],
'Azure Subscription'[Subscription Name],
'Azure Subscription'[Subscription Start Date],
'Azure Subscription'[Subscription Status],
'Azure Subscription'[Subscription Canceled Date],
'Azure Subscription'[Subscription End Date],
'Azure Subscription'[Created as Trial Flag],
'Azure Subscription'[Currently in Trial Flag],
'Azure Subscription'[Trial to Paid Conversion Date],
'Azure Subscription'[Trial End Date],
'Offer'[Billing Offer Name],
'Offer'[Offer ID],
'Offer'[Offer Name],
'Offer'[Offer Type],
'Azure Subscription'[CSP Flag],
'Azure Subscription'[MSP Flag],
'Azure Subscription'[Reseller Partner ID],
'Azure Subscription'[Reseller Partner Name],
'Azure Subscription'[Manual Partner Attribution Flag],
'Azure Subscription'[Manual Partner Attribution Date],
'Azure Subscription'[Manual Partner Attribution Partner Id],
'Azure Subscription'[Manual Partner Attribution Partner],
'Azure Subscription'[Tier 1 CSP Flag],
'Azure Subscription'[Tier 1 CSP],
'Azure Subscription'[Tier 2 CSP Flag],
'Azure Subscription'[Tier 2 CSP],
"ACR",[Azure Consumed Revenue],
"# of Subscription",[Subscription Count]
)