I have been creating some reports in SDP using information that DesktopCentral is feeding into SDP workstation assets.  I now want a report that shows what version of the DesktopCentral agent is installed on all In Use workstations.  The report is showing the Windows version of the agent but the Mac version is blank.  I feel like I am not defining the schema correctly for the software version but can not find it in the software schema.

I am on SDP 13.0 Build 13004

 SELECT systeminfo.workstationname "Machine Name",

aaauser.first_name "User",

osinfo.osname "OS",

osinfo.version "OS Version",

softwareinfo.fileversion "Agent Version"

FROM systeminfo

LEFT JOIN resources ON systeminfo.workstationid = resources.resourceid

LEFT JOIN resourceowner ON resources.resourceid = resourceowner.resourceid

LEFT JOIN sduser ON resourceowner.userid = sduser.userid

LEFT JOIN aaauser ON sduser.userid = aaauser.user_id

LEFT JOIN softwareinfo ON systeminfo.workstationid = softwareinfo.workstationid

LEFT JOIN softwarelist ON softwareinfo.softwareid = softwarelist.softwareid

LEFT JOIN osinfo ON systeminfo.workstationid = osinfo.workstationid

WHERE (softwarelist.softwarename = 'ManageEngine Desktop Central - Agent' 

OR softwarelist.softwarename = 'Desktop Central Agent')

AND aaauser.first_name <> 'Unassigned' 

ORDER BY softwareinfo.fileversion, aaauser.first_name, osinfo.version