İş ortağı içgörüleri programlı erişimi için sistem sorgularının listesi
Aşağıdaki sistem sorguları doğrudan QueryId ile Rapor Oluşturma API'sinde kullanılabilir. Sistem sorguları, altı aylık (6M) İş Ortağı Merkezi raporları dışarı aktarma raporlarına benzer.
Sütun adları, öznitelikler ve açıklama hakkında daha fazla bilgi için lütfen Veri Tanımları'na bakın
Aşağıdaki bölümlerde çeşitli raporlar için rapor sorguları sağlanmıştır.
Müşteriler
Son altı aya göre Müşteriler raporu
Sorgu Kimliği: 6664daf3-c161-423a-92a1-0ea6db2c0384
Rapor sorgusu
SELECT PGAMpnId,MpnId,PartnerName,CustomerName,CustomerTpid,DUNSNumber,CustomerSegment,TopSegment,
CustomerMarket,CustomerStatus,CustomerTenantId,CustomerTenantName,CustomerTenantCountry,TenantDomainName,
Product,RawProductName,ProductPartNumber,SKU,Month,PartnerLocation,PartnerAttributionType,SalesChannel,
IsDuplicateRowForPGA,AvailableSeats,BilledRevenueUSD,AzureConsumedRevenueUSD
FROM CustomersAndTenants TIMESPAN LAST_6_MONTHS
Seats Subscriptions and Revenue
Son altı ay için yer, abonelik ve gelir raporu
Sorgu Kimliği: c9fc1c79-4408-49ff-97f9-e1aa3f155804
Rapor sorgusu
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,PartnerLocation,PartnerAttributionType,SalesChannel,PricingLevel,EnrollmentNumber,
IsDuplicateRowForPGA,SubscriptionStartMonth,TotalSoldSeats,TotalAssignedSeats,BilledRevenueUSD,
AzureConsumedRevenueUSD FROM SeatsSubscriptionsAndRevenue TIMESPAN LAST_6_MONTHS
İş Ortağı Profili
Profil verileri
Sorgu Kimliği: e65f3a4f-fb99-4319-97ff-59e57566a871
Rapor sorgusu
SELECT MPNId,PartnerName,PGA_MPNId,PGA_PartnerName,City,Country,HierarchyLevel
FROM Profile
Azure Kullanımı
Son altı ay için AzureUsage raporu
Sorgu Kimliği: d1a4d75e-5ca8-4847-845f-ee0a9be6f07b
Rapor sorgusu
SELECT PGAMpnId,SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,FirstUseDate,SubscriptionState,Month,
ServiceName,MeterCategory,UsageUnits,UsageQuantity,CustomerName,CustomerTenantId,CustomerTpid,CustomerSegment,
CustomerMarket,MpnId,PartnerName,PartnerLocation,PartnerAttributionType,SalesChannel,EnrollmentNumber,
IsACRDuplicateAtPGALevel,ResellerID,ResellerName,MonthlySubscriptionLevelACR,TotalACR
FROM AzureUsage TIMESPAN LAST_6_MONTHS
Office Kullanımı
Son altı ay için OfficeUsage raporu
Sorgu Kimliği: d8349f7b-a7d1-467e-b26d-434d4a50f26a
Rapor sorgusu
SELECT CustomerTenantId,CustomerTpid,WorkloadName,Month,PaidAvailableUnits,MonthlyActiveUsers,CustomerName,
CustomerMarket,CustomerSegment,MPNId,PartnerName,PartnerLocation,PartnerAttributionType,IsDuplicateRowForPGA
FROM OfficeUsage TIMESPAN LAST_6_MONTHS
Dynamics Kullanımı
DynamicsUsage raporu altı ay boyunca
Sorgu Kimliği: 6209a8fd-93af-442e-8b3f-3df0f77e8463
Rapor sorgusu
SELECT SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,SubscriptionStatus,Month,RevSumDivisionName,
RevSumCategoryName,SKU,SKUId,FreeVsPaidSKU,SalesModel,DetailedSalesModel,CustomerName,CustomerTenantId,
CustomerTpid,CustomerSegment,CustomerMarket,MPNId,PartnerName,PartnerLocation,PartnerAttachType,AvailableSeats,
AssignedSeats,ActiveSeats,DeploymentOpportunity,ActiveUsagePercent
FROM DynamicsUsage TIMESPAN LAST_6_MONTHS
Power BI kullanımı
Altı ay boyunca PowerBIUsage raporu
Sorgu Kimliği: 40ebfe2f-7183-4427-a911-5c9b45b6df15
Rapor sorgusu
SELECT SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,SubscriptionStatus,Month,SKU,SKUId,
FreeVsPaidSKU,SalesModel,DetailedSalesModel,CustomerName,CustomerTenantId,CustomerTpid,CustomerSegment,
CustomerMarket,MPNId,PartnerName,PartnerLocation,PartnerAttachType,PartnerHierarchy,AvailableSeats,
AssignedSeats,ActiveSeats,DeploymentOpportunity,ActiveUsagePercent
FROM PowerBIUsage TIMESPAN LAST_6_MONTHS
EMS Kullanımı
ALTı ay boyunca EMSUsage raporu
Sorgu Kimliği: d7f20ea4-8751-4d6b-b1d7-821c316acd6a
Rapor sorgusu
SELECT SubscriptionId,SubscriptionStartDate,SubscriptionEndDate,SubscriptionStatus,Month,SKU,SKUId,
FreeVsPaidSKU,SalesModel,DetailedSalesModel,CustomerName,CustomerTenantId,CustomerTpid,CustomerSegment,
CustomerMarket,MPNId,PartnerName,PartnerLocation,PartnerAttachType,PartnerHierarchy,PaidAvailableUnits,
MonthlyActiveUsers,AADPPaidAvailableUnits,IntunePaidAvailableUnits,AzipPaidAvailableUnits,
AADPMonthlyActiveUsers,IntuneMonthlyActiveUsers,AzipMonthlyActiveUsers FROM EMSUsage TIMESPAN LAST_6_MONTHS
Uzmanlık Performansı gereksinim raporu
CompetencyPeformanceRequirement raporu altı ay boyunca
Sorgu Kimliği: 3a0e1adc-f5c1-42ac-9422-8e944bf81ae5
Rapor sorgusu
SELECT CompetencyName,CompetencyAttainmentOptionName,Month,MetricName,MetricMonthlyContribution,TTMAggregate,
AnniversaryYearAggregate,GoldThreshold,SilverThreshold
FROM CompetencyPeformanceRequirement
TIMESPAN LAST_6_MONTHS
Bulut ürünleri kurumsal bayi performansı
Rapor açıklaması
Altı ay boyunca CloudProductsResellerPerformance raporu
Sorgu Kimliği: c09c2eda-861b-4664-8ee8-48a14745a26a
Rapor sorgusu
SELECT ResellerMpnid,ResellerName,ResellerMarket,IndirectProviderMPNId,IndirectProviderName,Month,Product,
SubscriptionID,AvailableSeats,AssignedSeats,BilledRevenueUSD,CustomerName,CustomerTPid,CustomerSegment,
CustomerMarket,ResellerStatus
FROM CloudProductsResellerPerformance TIMESPAN LAST_6_MONTHS
CLAS Sözleşmesi Yenileme eğilimi
CLASAgreementRenewalsPropensity raporu altı ay boyunca
Sorgu Kimliği: c4fc87ac-4cca-44cd-bf4d-835ac513f9ee
Rapor sorgusu
SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,Area,Subsidiary,
SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,TopUnmanagedComputeBase,
TopUnmanagedUserBase,IsNonProfit,HasGoogle,HasAWS,AzureCluster,D365FOCluster,D365CECluster,D365BCCluster,
M365Cluster,LicenseProgram,AgreementID,AgreementEndDate,ExpirationType,ExpiringRevenue,HasEA,HasOpen,
AzureUpsellCustomer,M365UpsellCustomer,RevSumDivisionName
FROM CLASAgreementRenewalsPropensity
CLAS Azure eğilimi
ALTı ay boyunca CLASAzurePropensity raporu
Sorgu Kimliği: 9a18bd70-8f90-4bd2-8266-5f6e453e3ee7
Rapor sorgusu
SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,Area,Subsidiary,
SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,TopUnmanagedComputeBase,
TopUnmanagedUserBase,IsNonProfit,MigrateEOSWinServerWithCLASPropensityAbove5Licenses,
MigrateEOSWinServerWithCLASPropensityBelow5Licenses,
MigrateEOSWinServerWithoutCLASPropensityAbove5Licenses,
MigrateEOSWinServerWithoutCLASPropensityBelow5Licenses,MigrateEOSSQLWithCLASPropensityAbove5Licenses,
MigrateEOSSQLWithCLASPropensityBelow5Licenses,MigrateEOSSQLWithoutCLASPropensityAbove5Licenses,
MigrateEOSSQLWithoutCLASPropensityBelow5Licenses,
MigrateOnPremWinServerCurrentWindowsServerWithCLASPropensityAbove5Licenses,
MigrateOnPremWinServerCurrentWindowsServerWithCLASPropensityBelow5Licenses,
MigrateOnPremWinServerCurrentWindowsServerWithoutCLASPropensityAbove5Licenses,
MigrateOnPremWinServerCurrentWindowsServerIBWithoutCLASPropensityBelow5Licenses,
MigrateToAzureSQLOrSQLVMsCurrentSQLServerWithCLASPropensityAbove5Licenses,
MigrateToAzureSQLOrSQLVMsCurrentSQLServerWithCLASPropensityBelow5Licenses,
MigrateToAzureSQLOrSQLVMsCurrentSQLServerWithoutCLASPropensityAbove5Licenses,
MigrateToAzureSQLOrSQLVMsCurrentSQLServerWithoutCLASPropensityBelow5Licenses,MigrateOSSMigrateToOSSDB,
MigrateOSSLinuxOnAzure,MigrateSAPOnAzure,MigrateWVDRDSIB,MigrateWVDCrossSellModernWorkToAzureWVD,
MigrateVMWareIB,MigrateCitrixIB,InnovateAnalyticsPowerBIIBWithHighAzurepropensity,
EnableDevOpsWithGitHubVisualStudioMSDNIB,WinServerStandardVersion,WinServerStandardLicense,
WinServerDataCenterVersion,WinServerDataCenterLicense,AzureFit,AzureIntent,AzureCluster,
WindowsServerDataCenter_HasOpenRenewal,WindowsServerStandard_HasOpenRenewal,AzureUpsellCustomer,HasGoogle,
HasAWS,HasEA,HasOpen
FROM CLASAzurePropensity
CLAS D365 eğilimi
ALTı ay boyunca CLASD365Propensity raporu
Sorgu Kimliği: 258fdcac-6e9c-4072-af27-b1b3d97be16c
Rapor sorgusu
SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,Area,Subsidiary,
SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,TopUnmanagedComputeBase,
TopUnmanagedUserBase,IsNonProfit,ActivateDigitalSellingM365SeatSizeAbove25SeatsSalesProPropensityModel,
ActivateDigitalSellingD365SalesProPropensityActNowOrEvaluate,
ManagingFinancialRiskAndFraudDynamicsOnPremInstallBaseNavisionBCPropensityModel,
ManagingFinancialRiskAndFraudDynamicsOnPremInstallBaseAXFAndOPropensityModel,
ManagingFinancialRiskAndFraudDynamicsOnPremInstallBaseGreatPlainsBCPropensityModel,
ManagingFinancialRiskAndFraudDynamicsOnPremInstallBaseSolomonBCPropensityModel,
ManagingFinancialRiskAndFraudDynamicsOnPremInstallBaseOthersBCPropensityModel,
ManagingFinancialRiskAndFraudNewCustomerAcquisitionFAndOPropensityModel,
ManagingFinancialRiskAndFraudNewCustomerAcquisitionBCPropensityModel,
BuildAgileBusinessProcessesDynamicsOnPremInstallBaseAXGPSLNAVOtherD365PropensityModel,
BuildAgileBusinessProcessesDynamicsCompeteBaseMendixOutsystemsSalesforceD365PropensityModel,
BuildAgileBusinessProcessesD365FAndOInstallBase,BuildAgileBusinessProcessesD365BCInstallBase,
BuildAgileBusinessProcessesD365CEInstallBase,
BuildaResilientSupplyChainWinandActivateFirstD365WorkloadasD365SupplyChainwithNonOracleSAPERPCustomers,
BuildaResilientSupplyChainCrossSellD365SupplyChainANDORRetailCommercetoExistingD365CECustomers,
BuildaResilientSupplyChainCrossSellD365SupChainANDORRetailCommercetoD365CEANDOracleORSAP,D365BCCluster,
D365BCFit,D365BCIntent,D365FOCluster,D365FOFit,D365FOIntent,D365CECluster,D365CEFit,D365CEIntent,
DynamicsOnPremAXorCRM_HasOpenRenewal,M365UpsellCustomer,HasGoogle,HasAWS,HasEA,HasOpen
FROM CLASD365Propensity
CLAS M365 eğilimi
CLASM365Propensity raporu altı ay boyunca
Sorgu Kimliği: fbe00e32-fdde-4465-b3e4-41bbd021a130
Rapor sorgusu
SELECT MPNID,PartnerName,CustomerID,DUNSNumber,AccountName,Domain,OrgSize,Industry,Vertical,Area,Subsidiary,
SalesTerritory,City,State,PostalCode,Country,Segment,SubSegment,SMCTypeSummary,TopUnmanagedComputeBase,
TopUnmanagedUserBase,IsNonProfit,EnableRemoteWorkTargetExchangeOnline,
EnableRemoteWorkOnPremAcquisitionCurrentVersionwithCLASPropensityAbove10Licenses,
EnableRemoteWorkOnPremAcquisitionCurrentVersionwithCLASPropensityBelow10Licenses,
EnableRemoteWorkOnPremAcquisitionCurrentVersionwithoutCLASPropensityAbove10Licenses,
EnableRemoteWorkOnPremAcquisitionCurrentVersionwithoutCLASPropensityBelow10Licenses,
EnableRemoteWorkOnPremAcquisitionEOSwithCLASPropensityAbove10Licenses,
EnableRemoteWorkOnPremAcquisitionEOSwithCLASPropensityBelow10Licenses,
EnableRemoteWorkOnPremAcquisitionEOSwithoutCLASPropensityAbove10Licenses,
EnableRemoteWorkOnPremAcquisitionEOSwithoutCLASPropensityBelow10Licenses,
EnableRemoteWorkHighPropensityProspectforM365ActNowEvaluate,EnableRemoteWorkCompeteZoomwithM365,
EnableRemoteWorkCompeteZoomwithoutM365,ReduceCostandManageM365E3targetedforM365E5,
ReduceCostandManageM365BBandBScustomerstargetedforM365BP,TransformOrganizationalProductivitySurfacePropensity,
M365Cluster,M365Fit,M365Intent,SurfaceCluster,SurfaceFit,SurfaceIntent,O365Cluster,O365Fit,O365Intent,
M365UpsellCustomer,HasGoogle,HasAWS,HasEA,HasOpen
FROM CLASM365Propensity
Teams Kullanımı 3P Uygulamaları
TeamsUsage3PApps raporu altı ay boyunca
Sorgu Kimliği: 42d287be-cc76-4109-a066-f3140ad97fe2
Rapor sorgusu
SELECT CustomerId,CustomerTenantId,CustomerName,CustomerCountry,DateKey,AppName,UserCount
FROM TeamsUsage3PApps TIMESPAN LAST_6_MONTHS
Teams iş yükü kullanma
TeamsUsageWorkload raporu altı ay boyunca
Sorgu Kimliği: 817fe875-acb0-4c45-9201-b7a35a60235a
Rapor sorgusu
SELECT CustomerId,CustomerTenantId,MonthKey,SubWorkload,DesktopUsers,WebUsers,MobileUsers,AllUpPartiticipants
FROM TeamsUsageWorkload TIMESPAN LAST_6_MONTHS
Teams toplantılarını ve çağrıları kullanma
TeamsUsageMeetingsAndCalls raporu altı ay boyunca
Sorgu Kimliği: b7bd73a8-47e8-4c57-b915-445708cfd7bf
Rapor sorgusu
SELECT CustomerId,CustomerTenantId,DateKey,SubWorkload,MeetingCount,MeetingDuration
FROM TeamsUsageMeetingsAndCalls TIMESPAN LAST_6_MONTHS
Uzmanlık özeti geçmişi
CompetencySummaryHistory raporu altı ay boyunca
Sorgu Kimliği: fddab2aa-523d-47f6-90fe-588557306db4
Rapor sorgusu
SELECT CompetencyName,CompetencyLevel,CompetencyStatus,CompetencyStartDate,CompetencyEndDate
FROM CompetencySummaryHistory TIMESPAN LAST_6_MONTHS
Eğitimin tamamlanması
Altı ay boyunca Eğitim Tamamlamaları raporu
Sorgu Kimliği: 20f5da57-3c2a-481b-b6a0-ec34d6db14e2
Rapor sorgusu
SELECT TrainingActivityId,TrainingTitle,TrainingType,AADUserId,TrainingCompletionDate,Month,IcMCP,MCPID,MPNId,
PartnerName,PartnerCityLocation,PartnerCountryLocation
FROM TrainingCompletions TIMESPAN LAST_6_MONTHS
Microsoft Learn
Microsoft Learn altı aya göre rapor
Sorgu Kimliği: 0e06c7c3-75ab-4cd5-8178-8cf1a2de49cc
Rapor sorgusu
SELECT UserName,UserId,TrainingName,TrainingType,Products,Roles,CompletionDate,MPNId,PartnerName,CustomerMarket
FROM MSLearn TIMESPAN LAST_6_MONTHS