Organisational data - finding departments without users assigned

[Alisha]

Hello,

In System > Organisational Data > Organisation, is there a quick way of pulling up all the departments that have 0 assigned users? We need to delete all the departments that don't have any users assigned.

Many thanks,
Alisha

[Deen]

Not that I can see unfortunately, would probably need to craft an SQL statement to determine which org's have no users and then delete based off the results.

[Victor]

@Alisha also you can use reports such as this one below which will retrieve a list of departments that have no users associated to them

departments-with-no-users.report.txt

[Alisha]

@Victor Thank you so much, that's really helpful and saved us a lot of time. 

Is there a way to see if there were any requests with those departments linked? 

Would deleting the departments affect any of the existing requests in any way?

[Victor]

1 minute ago, Alisha said:

Would deleting the departments affect any of the existing requests in any way?

Requests are not associated to departments, they are associated to users/contacts. As such, deleting a department won't have any influence on requests, especially that you intend to delete departments that have no users associated to them.