database scheme question

Dear Support,

We have faced some issues with reports after the upgrade to 7015.
Most our assets and workstations have a site 'HP' assigned to them (which is obviously the vendor name, not the site or some location).

As I understand, in version 7, site and region data for any asset\workstation comes from the data for the department the owner belongs to. And we do not have such site at all. All departments the owners of the assets come from have correct real site names assigned to them.

We were trying to solve that through creating Query reports, but we were not able to find the 'name' field for the sites at all. We see those names of 'admin' page but there is no any 'sitename' field in sitedefinition table.

Could you please advise on both issues?

Thanks a lot!

Regards,
Tatiana