SELECT SUM(FULLFirstLSN) AS FullFirstLSN
  , SUM(DiffBaseLSN) AS DiffBaseLSN
       , CASE WHEN SUM(FULLFirstLSN) = SUM(DiffBaseLSN) THEN 1 ELSE 0 END AS LSNChainInBalance
FROM
  (
              SELECT MAX(checkpoint_lsn) AS FULLFirstLSN
                     , 0 AS DiffBaseLSN
              FROM   msdb.dbo.backupmediafamily bmf
                     INNER JOIN msdb.dbo.backupset bs ON bmf.media_set_id = bs.media_set_id
                      INNER JOIN msdb.dbo.backupfilegroup bfg ON bs.backup_set_id = bfg.backup_set_id
              WHERE  (CONVERT(datetime, bs.backup_start_date, 102) >= GETDATE() - 14)
                     AND bs.database_name = (SELECT MIN(database_name)
                                               FROM msdb.dbo.backupset bs
                                              , sys.databases db
                                               WHERE bs.database_name = db.name
                                               AND db.recovery_model_desc = 'FULL'
                                               AND database_id > 4)
                     AND LEFT(bmf.physical_device_name, 1) <> '{'
                     AND bs.type IN ('D')
              UNION ALL
              SELECT 0 AS FULLFirstLSN
                     , MAX(differential_base_lsn) AS DiffBaseLSN
              FROM   msdb.dbo.backupmediafamily bmf
                     INNER JOIN msdb.dbo.backupset bs ON bmf.media_set_id = bs.media_set_id
                      INNER JOIN msdb.dbo.backupfilegroup bfg ON bs.backup_set_id = bfg.backup_set_id
              WHERE  (CONVERT(datetime, bs.backup_start_date, 102) >= GETDATE() - 14)
                     AND bs.database_name = (SELECT MIN(database_name)
                                                FROM msdb.dbo.backupset bs
                                                , sys.databases db
                                                WHERE bs.database_name = db.name
                                                 AND db.recovery_model_desc = 'FULL'
                                                 AND database_id > 4)
                     AND LEFT(bmf.physical_device_name, 1) <> '{'
                     AND bs.type IN ('I')
       ) a