# Example: Join Data Set

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

×

Loading...