İş ortağı içgörüleri program aracılığıyla erişim için sistem sorgularının listesi
Aşağıdaki sistem sorguları, Rapor Oluşturma API'sinde doğrudan bir QueryId ile kullanılabilir. Sistem sorguları, altı aylık (6M) bir hesaplama dönemi için İş Ortağı Merkezi'ndeki dışarı aktarma raporları gibidir.
Sütun adları, öznitelikleri ve açıklaması hakkında daha fazla ayrıntı için veri tanımlarına bakın.
Aşağıdaki bölümlerde çeşitli raporlar için rapor sorguları sağlanmaktadır.
Müşteriler
Son altı ayın 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,PartnerLocationID,PartnerAttributionType,SalesChannel,
IsDuplicateRowForPGA,AvailableSeats,BilledRevenueUSD,AzureConsumedRevenueUSD
FROM CustomersAndTenants TIMESPAN LAST_6_MONTHS
Lisans Abonelikleri ve Gelir
Son altı aya ait koltuklar, abonelikler 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,PartnerLocationID,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,PartnerLocationID,PartnerAttributionType,SalesChannel,EnrollmentNumber,
IsACRDuplicateAtPGALevel,ResellerID,ResellerName,MonthlySubscriptionLevelACR,TotalACR
FROM AzureUsage TIMESPAN LAST_6_MONTHS
Office Kullanımı
Son altı aya ait OfficeUsage raporu
Sorgu Kimliği: d8349f7b-a7d1-467e-b26d-434d4a50f26a
Rapor sorgusu
SELECT CustomerTenantId,CustomerTpid,WorkloadName,Month,PaidAvailableUnits,MonthlyActiveUsers,CustomerName,
CustomerMarket,CustomerSegment,MPNId,PartnerName,PartnerLocationID,PartnerAttributionType,IsDuplicateRowForPGA
FROM OfficeUsage TIMESPAN LAST_6_MONTHS
Dynamics Kullanımı
Altı ay için DynamicsUsage raporu
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,PartnerLocationID,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,PartnerLocationID,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,PartnerLocationID,PartnerAttachType,PartnerHierarchy,PaidAvailableUnits,
MonthlyActiveUsers,AADPPaidAvailableUnits,IntunePaidAvailableUnits,AzipPaidAvailableUnits,
AADPMonthlyActiveUsers,IntuneMonthlyActiveUsers,AzipMonthlyActiveUsers FROM EMSUsage 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
ALTı ay boyunca CLASAgreementRenewalsPropensity raporu
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,
IsNonProfit,HasGoogle,HasAWS,AzureCluster,D365FOCluster,D365CECluster,D365BCCluster,M365Cluster,
PowerAppsCluster,LicenseProgram,AgreementID,AgreementEndDate,ExpirationType,ExpiringRevenue,HasEA,
HasOpen,M365UpsellCustomer,RevSumDivisionName,TransactedInTheLast36Months
FROM CLASAgreementRenewalsPropensity
CLAS Azure teklifi
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,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 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,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 teklifi
ALTı ay boyunca CLASM365Propensity raporu
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,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 eğilimi
ALTı ay boyunca CLASSurfacePropensity raporu:
Sorgu Kimliği: 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 Kullanımı 3P Uygulamaları
Altı ay boyunca TeamsUsage3PApps raporu
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 kullanım iş yükü
Altı ay boyunca TeamsUsageWorkload raporu
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 kullanım toplantıları ve aramaları
Altı ay boyunca TeamsUsageMeetingsAndCalls raporu
Sorgu Kimliği: b7bd73a8-47e8-4c57-b915-445708cfd7bf
Rapor sorgusu
SELECT CustomerId,CustomerTenantId,DateKey,SubWorkload,MeetingCount,MeetingDuration
FROM TeamsUsageMeetingsAndCalls TIMESPAN LAST_6_MONTHS
Eğitimin tamamlanması
Altı aylık 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
Son altı aya ait Microsoft Learn raporu
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