パートナー分析情報にプログラムでアクセスするためのシステム クエリの一覧

  • [アーティクル]

次のシステム クエリは、レポートの作成 API で QueryId を使用して直接使用できます。 システム クエリは、パートナーセンターにおける、6 か月の計算期間のエクスポート レポートに似ています。

列名、属性、および説明の詳細については、 データ定義を参照してください。

以下のセクションでは、さまざまなレポートのレポート クエリについて説明します。

顧客

過去 6 か月間の顧客レポート:

クエリ ID: 6664daf3-c161-423a-92a1-0ea6db2c0384

レポート クエリ

SELECT PGAMpnId,MpnId,PartnerName,CustomerName,CustomerTpid,DUNSNumber,CustomerSegment,TopSegment,
CustomerMarket,CustomerStatus,CustomerTenantId,CustomerTenantName,CustomerTenantCountry,TenantDomainName,
Product,RawProductName,ProductPartNumber,SKU,Month,PartnerLocationID,PartnerAttributionType,SalesChannel,
IsDuplicateRowForPGA,AvailableSeats,BilledRevenueUSD,AzureConsumedRevenueUSD
FROM CustomersAndTenants TIMESPAN LAST_6_MONTHS

シートのサブスクリプションと収益

過去 6 か月間のシート、サブスクリプション、収益レポート:

クエリ ID: c9fc1c79-4408-49ff-97f9-e1aa3f155804

レポート クエリ

SELECT PGAMpnId,MpnId,SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,SubscriptionState,month,
IsAutoRenew,CustomerName,CustomerTenantId,CustomerTpid,DUNSNumber,CustomerSegment,TopSegment,CustomerMarket,
ProductFamily,ReportingProductName,Product,RawProductName,ProductPartNumber,SKU,RevSumDivisionName,PartnerName,
SolutionArea,PartnerLocationID,PartnerAttributionType,SalesChannel,PricingLevel,EnrollmentNumber,
IsDuplicateRowForPGA,SubscriptionStartMonth,TotalSoldSeats,TotalAssignedSeats,BilledRevenueUSD,
AzureConsumedRevenueUSD FROM SeatsSubscriptionsAndRevenue TIMESPAN LAST_6_MONTHS

パートナー プロファイル

プロファイル データ:

クエリ ID: e65f3a4f-fb99-4319-97ff-59e57566a871

レポート クエリ

SELECT MpnId,PartnerName,PGA_MPNId,PGA_PartnerName,City,Country,HierarchyLevel
FROM Profile

Azure の利用状況

過去 6 か月間の AzureUsage レポート

クエリ ID: d1a4d75e-5ca8-4847-845f-ee0a9be6f07b

レポート クエリ

SELECT PGAMpnId,SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,FirstUseDate,SubscriptionState,Month,
ServiceName,MeterCategory,UsageUnits,UsageQuantity,CustomerName,CustomerTenantId,CustomerTpid,CustomerSegment,
CustomerMarket,MpnId,PartnerName,PartnerLocationID,PartnerAttributionType,SalesChannel,EnrollmentNumber,
IsACRDuplicateAtPGALevel,ResellerID,ResellerName,MonthlySubscriptionLevelACR,TotalACR
FROM AzureUsage TIMESPAN LAST_6_MONTHS

Office の利用状況

過去 6 か月間の OfficeUsage レポート

クエリ ID: d8349f7b-a7d1-467e-b26d-434d4a50f26a

レポート クエリ

SELECT CustomerTenantId,CustomerTpid,WorkloadName,Month,PaidAvailableUnits,MonthlyActiveUsers,CustomerName,
CustomerMarket,CustomerSegment,MPNId,PartnerName,PartnerLocationID,PartnerAttributionType,IsDuplicateRowForPGA
FROM OfficeUsage TIMESPAN LAST_6_MONTHS

Dynamics の利用状況

6 か月間の DynamicsUsage レポート

クエリ ID: 6209a8fd-93af-442e-8b3f-3df0f77e8463

レポート クエリ

SELECT SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,SubscriptionStatus,Month,RevSumDivisionName,
RevSumCategoryName,SKU,SKUId,FreeVsPaidSKU,SalesModel,DetailedSalesModel,CustomerName,CustomerTenantId,
CustomerTpid,CustomerSegment,CustomerMarket,MPNId,PartnerName,PartnerLocationID,PartnerAttachType,AvailableSeats,
AssignedSeats,ActiveSeats,DeploymentOpportunity,ActiveUsagePercent
FROM DynamicsUsage TIMESPAN LAST_6_MONTHS

Power BI の利用状況

6 か月間の PowerBIUsage レポート

クエリ ID: 40ebfe2f-7183-4427-a911-5c9b45b6df15

レポート クエリ

SELECT SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,SubscriptionStatus,Month,SKU,SKUId,
FreeVsPaidSKU,SalesModel,DetailedSalesModel,CustomerName,CustomerTenantId,CustomerTpid,CustomerSegment,
CustomerMarket,MPNId,PartnerName,PartnerLocationID,PartnerAttachType,PartnerHierarchy,AvailableSeats,
AssignedSeats,ActiveSeats,DeploymentOpportunity,ActiveUsagePercent
FROM PowerBIUsage TIMESPAN LAST_6_MONTHS

EMS の利用状況

6 か月間の EMSUsage レポート

クエリ ID: d7f20ea4-8751-4d6b-b1d7-821c316acd6a

レポート クエリ

SELECT SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,SubscriptionStatus,Month,SKU,SKUId,
FreeVsPaidSKU,SalesModel,DetailedSalesModel,CustomerName,CustomerTenantId,CustomerTpid,CustomerSegment,
CustomerMarket,MPNId,PartnerName,PartnerLocationID,PartnerAttachType,PartnerHierarchy,PaidAvailableUnits,
MonthlyActiveUsers,AADPPaidAvailableUnits,IntunePaidAvailableUnits,AzipPaidAvailableUnits,
AADPMonthlyActiveUsers,IntuneMonthlyActiveUsers,AzipMonthlyActiveUsers FROM EMSUsage TIMESPAN LAST_6_MONTHS

クラウド製品リセラーのパフォーマンス

レポートの説明

6 か月間の CloudProductsResellerPerformance レポート

クエリ ID: c09c2eda-861b-4664-8ee8-48a14745a26a

レポート クエリ

SELECT ResellerMpnId,ResellerName,ResellerMarket,IndirectProviderMPNId,IndirectProviderName,Month,Product,
SubscriptionID,AvailableSeats,AssignedSeats,BilledRevenueUSD,CustomerName,CustomerTPid,CustomerSegment,
CustomerMarket,ResellerStatus
FROM CloudProductsResellerPerformance TIMESPAN LAST_6_MONTHS

CLAS 契約更新傾向

6 か月間の CLASAgreementRenewalsPropensity レポート

クエリ ID: c4fc87ac-4cca-44cd-bf4d-835ac513f9ee

レポート クエリ

SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,
Area,Subsidiary,SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,
IsNonProfit,HasGoogle,HasAWS,AzureCluster,D365FOCluster,D365CECluster,D365BCCluster,M365Cluster,
PowerAppsCluster,LicenseProgram,AgreementID,AgreementEndDate,ExpirationType,ExpiringRevenue,HasEA,
HasOpen,M365UpsellCustomer,RevSumDivisionName,TransactedInTheLast36Months
FROM CLASAgreementRenewalsPropensity

CLAS Azure の傾向

6 か月間の CLASAzurePropensity レポート

クエリ ID: 9a18bd70-8f90-4bd2-8266-5f6e453e3ee7

レポート クエリ

SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,Area,Subsidiary,
SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,IsNonProfit,
DataAIInnovatewithAIandcloudscaledatabasesineveryappBuildnewintelligentcloudnativeapplications,
DataAIMigrateandmodernizeyourdatacenterSQLServerIBCurrentVersion,DataAIMigrateandmodernizeyourdatacenterSQLServerIBEOS,
DataAIMigrateandmodernizeyourdatacenterSQLServer2012IBEOS,DataAIMigrateandmodernizeyourdatacenterHomogenousmigrationofPostgreSQLandMySQLtoAzure,
DataAIMigrateandmodernizeyourdatacenterMigrateSQLServertoAzureSQLManagedInstanceandVMs,
RealtimeanalyticswithSynapseLinkPBIforlandeddataplatformworkloads,DataAIPowerbusinessdecisionswithCloudScaleAnalyticsMigrationOnPremDWMigrationtoAzureSynapse,
DataAIPowerbusinessdecisionswithCloudScaleAnalyticsMigrationOnPremHadoopMigrationtoAzureDatabricks,
NetNewWinNewAnalyticUseCaseswithSynapseandPBIandAML,DigitalAppInnovationAccelerateinnovationwithLowCodeBuildandmodernizelineofbusinessapplications,
AcceleratesoftwaredeliverythroughDevSecOpswithGitHubandVisualStudio,DigitalAppInnovationEnabledeveloperproductivityandAccelerateDeliveryDrivedeveloperengagement,
BuildcloudnativeappswithKubernetesServerlessanddataModernizeAppswAKS,BuildcloudnativeappswithKubernetesServerlessanddataModernizeAppswRHOpenShiftHighConsumingLinuxIBISV,
DigitalAppInnovationInnovateandscalewithcloudnativeappsDrivedeveloperengagement,DigitalAppInnovationModernizeenterpriseapplicationsModernizeNETappswithdata,
DigitalAppInnovationModernizeenterpriseapplicationsModernizeJavaappswithdata,HighPropensityHighPropensity,
DevelopoperateandsecurewithAzureArcArcenabledservicesandAzureStackHCI,InfraMigrateandModernizeyourInfrastructureandworkloadsAttachMonitorStorageNetworkingandSecurity,
InfraMigrateandModernizeyourInfrastructureandworkloadsWindowsServerIBCurrentVersion,InfraMigrateandModernizeyourInfrastructureandworkloadsWindowsServerIBEOS,
InfraMigrateandModernizeyourInfrastructureandworkloadsWindowsServer2012IBEOS,InfraMigrateandModernizeyourInfrastructureandworkloadsMigrateandmodernizeLinuxOSSDBtoAzure,
InfraMigrateandModernizeyourInfrastructureandworkloadsMigrateandmodernizeVMwaretoAVS,
InfraMigrateandModernizeyourInfrastructureandworkloadsMigrateandmodernizeWindowsServerSQLtoAzure,
InfraMigrateandModernizeyourInfrastructureandworkloadsModernizeVDItoAVDMigrateCitrixIB,
InfraMigrateandModernizeyourInfrastructureandworkloadsModernizeVDItoAVDMigrateVMWareIB,
InfraMigrateandModernizeyourInfrastructureandworkloadsModernizeVDItoAVDCrossSellMWtoAzureWVD,InfraMigrateandModernizeyourInfrastructureandworkloadsModernizeVDItoAVDRDSIB,
InfraModernizeSAPontheMicrosoftCloudExtendandinnovateSAPwithMicrosoftCloudservices,
InfraModernizeSAPontheMicrosoftCloudMigrateandmodernizetoS4HANAviaRISEwithSAPorAzurenative,ExtendEdgeInferencingwithcloudbasedmodeltrainingusingAzureAIInfrastructure,
InfraModernizeyourworkloadswithAzureatanyscalewithHPCAIExtendtoAVDworkloadsrequiringGPUrendering,
InfraModernizeyourworkloadswithAzureatanyscalewithHPCAIModernizeHPCworkloadswithAzureHPCAI,AttachAzureBackupandASRtoeveryproductionVMnewandgoback,
InfraProtectyourdataandensurebusinessresiliencywithBCDRBackuponpremdataandSaaSdatatoAzure,SecurityDefendAgainstThreatswithSIEMXDRDriveSIEMXDRtomodernizesecurityopcenter,
SecuritySecureMultiCloudInfrastructureCloudworkloadprotectionDefenderAttachinWindowsMigration,
SecuritySecureMultiCloudInfrastructureCloudworkloadprotectionWellArchitectedSecurityGoBack,AzureFit,AzureIntent,AzureCluster,WindowsServerDataCenter_HasOpenRenewal,
WindowsServerStandard_HasOpenRenewal,HasGoogle,HasAWS,HasEA,HasOpen,NumberofExistingWorkloads,ExistingWorkloads,NumberofRecommendedWorkloads,RecommendedWorkloads,
Transactedinthelast36months
FROM CLASAzurePropensity

CLAS Dynamics 365傾向

6 か月間の CLASD365Propensity レポート

クエリ ID: 258fdcac-6e9c-4072-af27-b1b3d97be16c

レポート クエリ

SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,Area,
Subsidiary,SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,IsNonProfit,
AccelerateInnovationwithLowCodeDynamicsCompeteBaseMendixOutsystemsSalesforcePowerAppsPowerAutomateModel,ConnectedSalesMarketingUnlockDatatoMaximizeSalesImpact,
EnableaResilientSustainableSupplyChainCrossSellD365SupplyChainAndOrRetailCommercetoexistingD365Sales,
CrossSellD365SupplyChainAndOrRetailCommercetoexistingD365SalesandOracleorSAPCustomers,WinandActivateFirstD365WorkloadasD365SupplyChainwithNonOracleSAPERPCustomers,
ModernizetheServiceExperienceD365CustomerServicesandD365FieldServicesD365SalesPropensity,
OptimizeFinancialOperatingModelsDynamicsOnPremInstallBaseGreatPlainsBCFinancePropensityModel,
OptimizeFinancialOperatingModelsDynamicsOnPremInstallBaseNavisionBCFinancePropensityModel,
OptimizeFinancialOperatingModelsDynamicsOnPremInstallBaseOthersBCFinancePropensityModel,
OptimizeFinancialOperatingModelsDynamicsOnPremInstallBaseSolomonBCFinancePropensityModel,OptimizeFinancialOperatingModelsTransformBusinessOperationsExperience,
D365BCCluster,D365BCFit,D365BCIntent,D365FOCluster,D365FOFit,D365FOIntent,D365CECluster,D365CEFit,D365CEIntent,PowerAppsCluster,PowerAppsFit,PowerAppsIntent,
DynamicsOnPremAXorCRM_HasOpenRenewal,M365UpsellCustomer,HasGoogle,HasAWS,HasEA,HasOpen,Transactedinthelast36months
FROM CLASD365Propensity

CLAS Microsoft 365 の傾向

6 か月間の CLASM365Propensity レポート

クエリ ID: fbe00e32-fdde-4465-b3e4-41bbd021a130

レポート クエリ

SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,Area,
Subsidiary,SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,IsNonProfit,DigitalWorkforce3rdPartyHostingService,
DigitalWorkforceAcquirenewcustomerstoMicrosoftHighPropensityProspectforM365ActNowEvaluate,DigitalWorkforceM365A3targetedforA5,DigitalWorkforceSkypeforBusiness,
DigitalWorkforceOnPremAcquisitionCurrentVersion,DigitalWorkforceOnPremAcquisitionEOS,DigitalWorkforceTransitionCustomerCompeteZoomwithM365,
DigitalWorkforceTransitionCustomerCompeteZoomwithoutM365,DigitalWorkforceTransitionCustomerCompeteGoogleWorkspace,DigitalWorkforceUpsellexistingcloudcustomerIntune,
DigitalWorkforceUpsellexistingcloudcustomerM365BBBScustomerstargetedforM365BP,DigitalWorkforceUpsellexistingcloudcustomerM365E3targetedforM365E5,
DigitalWorkforceUpsellexistingcloudcustomerTargetExchangeonline,NextGenWindowsExperiencesCompeteAmazonWorkspaceAWSWorkspaces,NextGenWindowsExperiencesCompeteCitrix,
NextGenWindowsExperiencesCompeteGoogleDaaScompeteitopiaNutanixFrameWorkspot,NextGenWindowsExperiencesCompeteVmwareHorizons,
NextGenWindowsExperiencesCustomerhashardwareandalsoaddlastHWpurchase3years,NextGenWindowsExperiencesCustomerhasW10ProorearlierversionsW11ProTargetW365,
CustomerswithWindowsProendpointsWindows10EnterpriseE3EMSE3orMicrosoft365F3E3E5BPTargetforW365,NextGenWindowsExperiencesGoogleWorkspacecustomerswithoutWindows,
UserswithnonWindowsProendpointsWindowsVDAE3EMSE3orMicrosoft365F3E3F5BPTargetW365,RefreshyourDevicesBusinessPremiumESKUAttach50,RefreshyourDevicesEDUforSurface,
RefreshyourDevicesSurfaceDevices25purchasedinthelast3years,RefreshyourDevicesTargetSurfaceforBS,RefreshyourDevicesTeamsMeetingPresence50,
SeamlessSecurityTransitionCustomerCompeteEndpointSecurityMDB,SeamlessSecurityUpsellexistingcloudcustomerCompeteEndpointSecurityMDB,
SeamlessSecurityUpsellexistingcloudcustomerCompeteGoogleWorkspace,SeamlessSecurityUpsellexistingcloudcustomerM365BBBScustomerstargetedforM365BP,
SeamlessSecurityUpsellexistingcloudcustomerOnPremAcquisitionCurrentVersion,SeamlessSecurityUpsellexistingcloudcustomerTargetExchangeOnline,M365Cluster,M365Fit,M365Intent,
SurfaceCluster,SurfaceFit,SurfaceIntent,M365UpsellCustomer,HasGoogle,HasAWS,HasEA,HasOpen,Transactedinthelast36months
FROM CLASM365Propensity

CLAS Surface の傾向

6 か月間の CLASSurfacePropensity レポート:

クエリ ID: ba339743-7594-439f-bb01-1a2e754df7b7

SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,Area,
Subsidiary,SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,IsNonProfit,DigitalWorkforce3rdPartyHostingService,
DigitalWorkforceAcquirenewcustomerstoMicrosoftHighPropensityProspectforM365ActNowEvaluate,DigitalWorkforceM365A3targetedforA5,DigitalWorkforceSkypeforBusiness,
DigitalWorkforceOnPremAcquisitionCurrentVersion,DigitalWorkforceOnPremAcquisitionEOS,DigitalWorkforceTransitionCustomerCompeteZoomwithM365,
DigitalWorkforceTransitionCustomerCompeteZoomwithoutM365,DigitalWorkforceTransitionCustomerCompeteGoogleWorkspace,DigitalWorkforceUpsellexistingcloudcustomerIntune,
DigitalWorkforceUpsellexistingcloudcustomerM365BBBScustomerstargetedforM365BP,DigitalWorkforceUpsellexistingcloudcustomerM365E3targetedforM365E5,
DigitalWorkforceUpsellexistingcloudcustomerTargetExchangeonline,NextGenWindowsExperiencesCompeteAmazonWorkspaceAWSWorkspaces,NextGenWindowsExperiencesCompeteCitrix,
NextGenWindowsExperiencesCompeteGoogleDaaScompeteitopiaNutanixFrameWorkspot,NextGenWindowsExperiencesCompeteVmwareHorizons,
NextGenWindowsExperiencesCustomerhashardwareandalsoaddlastHWpurchase3years,NextGenWindowsExperiencesCustomerhasW10ProorearlierversionsW11ProTargetW365,
CustomerswithWindowsProendpointsWindows10EnterpriseE3EMSE3orMicrosoft365F3E3E5BPTargetforW365,NextGenWindowsExperiencesGoogleWorkspacecustomerswithoutWindows,
UserswithnonWindowsProendpointsWindowsVDAE3EMSE3orMicrosoft365F3E3F5BPTargetW365,RefreshyourDevicesBusinessPremiumESKUAttach50,RefreshyourDevicesEDUforSurface,
RefreshyourDevicesSurfaceDevices25purchasedinthelast3years,RefreshyourDevicesTargetSurfaceforBS,RefreshyourDevicesTeamsMeetingPresence50,
SeamlessSecurityTransitionCustomerCompeteEndpointSecurityMDB,SeamlessSecurityUpsellexistingcloudcustomerCompeteEndpointSecurityMDB,
SeamlessSecurityUpsellexistingcloudcustomerCompeteGoogleWorkspace,SeamlessSecurityUpsellexistingcloudcustomerM365BBBScustomerstargetedforM365BP,
SeamlessSecurityUpsellexistingcloudcustomerOnPremAcquisitionCurrentVersion,SeamlessSecurityUpsellexistingcloudcustomerTargetExchangeOnline,M365Cluster,M365Fit,M365Intent,
SurfaceCluster,SurfaceFit,SurfaceIntent,M365UpsellCustomer,HasGoogle,HasAWS,HasEA,HasOpen,Transactedinthelast36months
FROM CLASSurfacePropensity

Teams の使用状況 3P アプリ

6 か月間の TeamsUsage3PApps レポート

クエリ ID: 42d287be-cc76-4109-a066-f3140ad97fe2

レポート クエリ

SELECT CustomerId,CustomerTenantId,CustomerName,CustomerCountry,DateKey,AppName,UserCount
FROM TeamsUsage3PApps TIMESPAN LAST_6_MONTHS

Teams の利用状況のワークロード

6 か月間の TeamsUsageWorkload レポート

クエリ ID: 817fe875-acb0-4c45-9201-b7a35a60235a

レポート クエリ

SELECT CustomerId,CustomerTenantId,MonthKey,SubWorkload,DesktopUsers,WebUsers,MobileUsers,AllUpPartiticipants
FROM TeamsUsageWorkload TIMESPAN LAST_6_MONTHS

Teams の利用状況の会議と通話

6 か月間の TeamsUsageMeetingsAndCalls レポート

クエリ ID: b7bd73a8-47e8-4c57-b915-445708cfd7bf

レポート クエリ

SELECT CustomerId,CustomerTenantId,DateKey,SubWorkload,MeetingCount,MeetingDuration
FROM TeamsUsageMeetingsAndCalls TIMESPAN LAST_6_MONTHS

トレーニング完了

6 か月間のトレーニング完了レポート

クエリ ID: 20f5da57-3c2a-481b-b6a0-ec34d6db14e2

レポート クエリ

SELECT TrainingActivityId,TrainingTitle,TrainingType,AADUserId,TrainingCompletionDate,Month,IcMCP,MCPID,MPNID,
PartnerName,PartnerCityLocation,PartnerCountryLocation
FROM TrainingCompletions TIMESPAN LAST_6_MONTHS

Microsoft Learn

6 か月間の Microsoft Learn レポート

クエリ ID: 0e06c7c3-75ab-4cd5-8178-8cf1a2de49cc

レポート クエリ

SELECT UserName,UserId,TrainingName,TrainingType,Products,Roles,CompletionDate,MPNId,PartnerName,CustomerMarket
FROM MSLearn TIMESPAN LAST_6_MONTHS

次のステップ