This SQL query can help you, you can also use in the SMP report
SELECT dbo.vComputer.Guid, dbo.vComputer.Name, dbo.vComputer.Domain, dbo.vComputer.[User], dbo.vComputer.[IP Address], dbo.Inv_AeX_AC_Client_Agent.[Agent Name],
dbo.Inv_AeX_AC_Client_Agent.[Product Version], dbo.Inv_AeX_AC_Client_Agent.[Build Number], dbo.Inv_AeX_AC_Client_Agent.[Install Path],
dbo.Inv_AeX_AC_Client_Agent.[Agent Class Guid], dbo.Inv_AeX_AC_Client_Agent.[64 Bit]
FROM dbo.vComputer LEFT OUTER JOIN
dbo.Inv_AeX_AC_Client_Agent ON dbo.vComputer.Guid = dbo.Inv_AeX_AC_Client_Agent._ResourceGuid
where dbo.vComputer.ismanaged = '1'
order by dbo.vComputer.Name,dbo.Inv_AeX_AC_Client_Agent.[Agent Name]