SELECT Upper (ComputerName) AS 'Computer Name' ,[AgentVersion] ,[AgentVersionState] ,[State] FROM [dbo].[tbl_ADHC_AgentServer] Order by [ComputerName] asc