Symantec Management Platform (Notification Server)

Hi
I'm tring to create a report that shows the computer, last logged on user, the users Common name, and email and address, and help would be great as i'm unable to create a succesful join.

Cheers

select vc.name,ac.[Last Logon User],eu.[Exchange Common User Name],eu.[Exchange Email Address]
from vcomputer vc
join inv_aex_eu_contact_detail eu on eu._resourceguid = vc.guid
join inv_aex_ac_identification ac on ac._resourceguid = vc.guid


see if that gets you started, I'm using an inner join, so the results won't match up with any nulls.