Completed Requests by Department Report

I am running this report to determine the departments within our business that are sending requests, however each month about 30% of reqests are coming up as Unassigned, however if I check AD and the Department field of the Organization Tab, and they are all fine.

Help this is annoying me, because I have to manually check 700+ supposedly unassigned requesters and add them to one of maybe 50 offices before repoirting to the CIO, whereby we charge these departments based on usage of SD+ and IT services.

I really need help here, as I am sick of doiung this every month.

Please see query in word document attached

HELP!!!

MSSQL, SD+ Version 7008(not changing until 7.5okay and bedded, so don't suggest :-))

And no this has never worked