Due to some duff AD data imported I have some Junk Departments and Sites showing.

I've deleted then in ADMIN, but they aren't going, just become grey.Not a great issue except they show in some filters, like on the HOME, GLOBAL VIEW, REQUEST SUMMARY.

I'm pretty sure they don't appear in any real data as the requesters have been re-imported with corrected data.

What query(s) can I run to check the SITEID and DEPTID aren't in use and then I assume I could remove the offending items from the tables - appreciate this is less than supported action!

Thanks,
Andy