try this query
SELECT dbo.Inv_AeX_AC_Identification.[Name][Host Name]
, dbo.Inv_AeX_AC_Identification.[Os Name]
, dbo.Inv_AeX_AC_Identification.[System Type]
, dbo.Inv_AeX_AC_Identification.[Last Logon User]
, dbo.vHWComputerSystem.[manufacturer][CPU Make]
, dbo.vHWComputerSystem.[Model][CPU Model]
, dbo.vHWComputerSystem.[Total Physical Memory (Bytes)][Memory Size (Bytes)]
, dbo.Inv_AeX_AC_TCPIP.[MAC Address]
, dbo.Inv_AeX_AC_TCPIP.[Device]
, dbo.Inv_AeX_AC_TCPIP.[IP Address]
, dbo.Inv_AeX_AC_TCPIP.[DHCPEnabled]
, dbo.Inv_HW_Baseboard.[Serial Number][Motherboard Serial Number]
, dbo.Inv_HW_Baseboard.[Part Number][Motherboard Part Number]
, dbo.Inv_HW_Desktop_Monitor.[Monitor Type]
, dbo.Inv_HW_Desktop_Monitor.[Serial Number][Monitor Serial Number]
, dbo.Inv_HW_Keyboard.[Device ID]
, dbo.Inv_HW_Physical_Memory.[Serial Number][Memory Serial Number]
, dbo.Inv_HW_Physical_Memory.[Capacity (Bytes)][Memory Size (Bytes)]
, dbo.Inv_HW_Pointing_Device.[Device ID][Mouse Device ID]
, dbo.Inv_HW_Printer_Windows.[Port Name][Printer IP]
, dbo.Inv_HW_Printer_Windows.[Device ID][Printer Name]
, dbo.Inv_SW_BIOS_Element.[Manufacturer][BIOS Manufacturer]
, dbo.Inv_SW_BIOS_Element.[Name][BIOS Name]
, dbo.vHWProcessor.[Model][Processor Model]
, dbo.vHWProcessor.[Family][Processor Family]
, dbo.Inv_HW_Processor.[Max Clock Speed (Mega-hertz)][Processor Speed (Mega-hertz)]
FROM
dbo.Inv_AeX_AC_Identification,
dbo.vHWComputerSystem,
dbo.Inv_AeX_AC_TCPIP,
dbo.Inv_HW_Baseboard,
dbo.Inv_HW_Desktop_Monitor,
dbo.Inv_HW_Keyboard,
dbo.Inv_HW_Physical_Memory,
dbo.Inv_HW_Pointing_Device,
dbo.Inv_HW_Printer_Windows,
dbo.Inv_SW_BIOS_Element,
dbo.vHWProcessor,
dbo.Inv_HW_Processor
WHERE
dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.vHWComputerSystem._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_AeX_AC_TCPIP._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Baseboard._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Desktop_Monitor._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Keyboard._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Physical_Memory._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Pointing_Device._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Printer_Windows._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_SW_BIOS_Element._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.vHWProcessor._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Processor._ResourceGuid