Example: Join Data Set

Updated

On this page

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