2020-06 s dispo table cleanup: Difference between revisions

Line 11: Line 11:
GROUP BY s_dispo.location_name, s_dispo.active, s_locations_allowed_collection.Laptop_identifier, sl.RecordStatus;
GROUP BY s_dispo.location_name, s_dispo.active, s_locations_allowed_collection.Laptop_identifier, sl.RecordStatus;
}}
}}
== [[S locations allowed collection table]] entries for inactive records ==
The following were allowed but their corresponding records in [[s_dispo table]] were inactive. They have been removed from [[S locations allowed collection table]]:
*STB_EMIPb - 0 entries, deleted
*STB_E6bB - 0 entries, deleted
*STB_E5b - 0 entries, deleted


== entries with s_location = true but no entry in allowed table ==
== entries with s_location = true but no entry in allowed table ==