Database SQL

I would like to get a custom query report with following details

TableSchema: All computers

WorkstationID

ResourceOwnerID

DeptID (for ResourceOwnerID)