I have users departments are being imported from AD
Then I have configured a connector Data source that is a SQL query to get the users department and computer
And using a connector Import/Export Rule I am assigning the users department as the computers department.
I have the rule set to do asset department owners .... Asset-> Department
Looking at the computer assets cmdb history I can see that it appears to be assigning it, but when I run the asset report "Assets by Type, Status, Department..." the department field is blank, also when I show the asset grid or diagram I don't see the association to a department.
Anything I should check or what I might be doing wrong?