In preparation for populating the Locations drop down list for use on the tickets logged within the new ITSM System, I downloaded all of Newcastle University’s location data. When compiling this into one list (with attributes: Building Name, Floor Number, Room Number) there were 13242  records. As this entirely defeats the object of a ‘quick’ look up we have decided that it will be best to use only the building name for the drop down list and any other relevant data can be added to the ticket detail.