Our organization is a City with many physical locations throughout our municipality. Before we ever started using ServiceDesk we had already called each one of these locations Sites. This caused some confusion early on as we started setting ServiceDesk up and unfortunately was never fixed. By ServiceDesk’s definition we should only have one Site, our City name. But as things are each actual location we have is listed under Sites. After time we made a change to what data is found in the Office field in AD and that created even more sites. About 270 in fact.

I’ve turned off the option that syncs the Office field from AD. So that should not be making any more sites when it syncs with ServiceDesk. But we have Site data attached to users and assets now and I’d like to fix it. We’re looking at setting up Organizational Roles and it’s just a mess because ServiceDesk see’s our Parks Department spread out over 60 different Sites and assumes each one has it’s own Department Head.

My question is…what is the best way to clean this up? I want to get all the different Sites changed to “City of Whatever”. That way we’d be using it correctly for once.