Custom Inventory Report

I need a report query that will generate a list of all workstations and assets grouped by the department they belong to. This way when we are on site doing our end of year inventory, I can look at the report and verify that everything is there.