sql_status_query.sql

SELECT [s].[Name0],
       [s].[Full_Domain_Name0],
       [sp].*
       FROM [dbo].[v_HS_sqlpatching] [sp]
            LEFT JOIN [dbo].[v_R_System] [s] ON [s].[ResourceID] = [sp].[resourceid]
ORDER BY [s].[name0],
         [sp].[querytime0];  
--or
SELECT [s].[Name0],
       [s].[Full_Domain_Name0],
       [sp].*
       FROM [dbo].[v_gs_sqlpatching] [sp]
            LEFT JOIN [dbo].[v_R_System] [s] ON [s].[ResourceID] = [sp].[resourceid]
ORDER BY [s].[name0],
         [sp].[querytime0];