Assign machines based on filter to department

Assign machines based on filter to department

I have used the inventory model and now 500 machines have come up. Now when i want to assign all these machines to particular department how can i do it. In the AD the computers are all in one OU and not in department wise OU. We have names of machine starting with department name like HR-John, HR-Joseph, ME-javed,ME-Shakir etc. Is there an easy way to either extract the data into excel and then import it back.

                    New to ADSelfService Plus?