From the very start of my organization using ServiceDesk, we misunderstood Sites and how they are used. Our AD Sync has created close to 300 Sites so far. That option has been disabled now so no new sites should be created from AD. 

But before I can add or build upon what we have in ServiceDesk, I need to purge all site information from Users/Assets/Request or where ever else it may be found. I've created additional fields for bother Users and Assets named Location and have moved our Site info (Its just Building Codes) to those fields. 

But I'd like to get a query if possible that we can run against our database to remove all site info. We're a City Government. And we DO have many buildings throughout the city, however we support them all. So using Sites as ServiceDesk intended will not work for us. 

Or if Purging is not an option. One better may be to change EVERY instance of a Site to the same thing. So instead of almost 300 different Sites we have only one named after our organization.