The following is an example of the join data set combining data from Customer Membership data set and DR Status data set:
The following is an example of the join data set combining data from TenantSLAFromMetrics data set and Organisation data set:
Query
The following query is used to create the Membership and DR Status data set:
SET @DRbackupURL = (SELECT DRbackupURL FROM :[DR Status]);
SET @UploadStatus = (SELECT UploadStatus FROM :[DR Status]);
SET @DRLastUploadTime = (SELECT DRLastUploadTime FROM :[DR Status]);
SET @ServiceType = (SELECT ServiceType FROM :[Customer Membership]);
SET @RenewDate = (SELECT RenewDate FROM :[Customer Membership]);
SELECT @ServiceType AS ServiceType , @RenewData AS RenewData, @DRbackupURL AS DRbackupURL, @UploadStatus AS UploadSatatus, @DRLastUploadTime AS DRLastUploadTime;
The following query is used to create the OrganisationSLA data set:
select s.*
From :[TenantSLAFromMetrics] s
INNER JOIN :[Organizations] o ON s.TenantName = o.connectName
WHERE s.OverallSLA <> -1
ORDER BY s.TenantName
