Symantec Management Platform (Notification Server)

Hi everyone,  Please, I need to add the "Department" field from the "Inv_AeX_EU_Contact_Detail" to the Computer Summary (Model, CPU, Memory, Disk and Network) report.
1- What is the best way to do it? using the Primary User.User  or  Aex_Os_System.Logon Name table/field? and how can I join correctly those tables with the Inv_AeX_EU_Contact_Detail table ?

2- Is there another way to assign some like "Department" directly to the machine (not using the way I say in the point 1... ) and add this to the report I say above?

3- I was trying to do it, but not all the machines shows the data because some of them doesn't have the Inv_AeX_EU_Contact_Detail table. Why this occurs? can I avoid it?

Does someone help me with this issues?

Thanks friends.

I think if I were joining those tables together I might start with the identification table (Inv_AeX_AC_Identification).   Then you wouldn't even need the Logon name table or the primary user table.  You could do something like this:

Select Name,  
            [Last Logon User],
            Department 
from Inv_Aex_Ac_Identification i
Left Join Inv_Aex_EU_Contact_Detail cd
on i._ResourceGuid = cd._ResourceGuid

You can also tie in your hardware stuff to the identification table on _ResourceGuid as well. In most cases the Identification table works very well as sort of a master table to start with.  As far a populating the contact detail stuff, I am not 100% sure where that stuff comes from.  Maybe someone else will have some insight on that one.

Let me know if anything doesn't make sense.  I'd be happy to help you with your SQL statement if you need it.
Have a good one.