Here is your answer (MacAddress is in another table, IPaddress just need to be converted from HexaDecimal): SELECT attrib.macaddress AS macAddress , CONCAT( CONVERT(int, SUBSTRING(iface.[IPAddress], 1,1)), '.', CONVERT(int, SUBSTRING(iface.[IPAddress], 2,1)), '.', CONVERT(int, SUBSTRING(iface.[IPAddress], 3,1)), '.', CONVERT(int, SUBSTRING(iface.[IPAddress], 4,1))) as IP, iface.[Name] AS dest_int_name , iface.[Description] AS dest_int_desc , iface.[IsWLAN] AS dest_int_wlan , dev.* FROM "AirWatch"."dbo"."Device" AS dev LEFT OUTER JOIN [AirWatch].[dbo].[DeviceInterface] AS iface ON dev.DeviceID = iface.DeviceID inner join [AirWatch].[dbo].deviceattributes as Attrib on dev.DeviceID = Attrib.DeviceID ... View more