Created
March 13, 2020 15:02
-
-
Save Blake-/3c133ec7e42d039d85afbad5b3089eb4 to your computer and use it in GitHub Desktop.
Find Bad Dates In All ArchivesSpace Tables
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * FROM accession WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM active_edit WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM agent_contact WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM agent_corporate_entity WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM agent_family WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM agent_person WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM agent_software WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM archival_object WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM aspace-dts_schema_info WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM assessment WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM assessment_attribute WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM assessment_attribute_definition WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM assessment_attribute_note WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM assessment_reviewer_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM assessment_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM auth_db WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM classification WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM classification_creator_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM classification_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM classification_term WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM classification_term_creator_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM collection_management WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM container_profile WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM custom_report_template WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM date WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM deaccession WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM default_values WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM deleted_records WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM digital_object WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM digital_object_component WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM enumeration WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM enumeration_value WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM event WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM event_link_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM extent WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM external_document WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM external_id WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM file_version WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM group WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM group_permission WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM group_user WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM instance WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM instance_do_link_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM job WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM job_created_record WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM job_input_file WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM job_modified_record WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM linked_agent_term WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM linked_agents_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM location WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM location_function WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM location_profile WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM location_profile_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM name_authority_id WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM name_corporate_entity WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM name_family WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM name_person WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM name_software WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM note WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM note_persistent_id WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM notification WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM oai_config WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM owner_repo_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM permission WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM preference WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM rde_template WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM related_accession_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM related_agents_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM repository WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM required_fields WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_delete WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_ WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_update_via_ao WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_update_via_do WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_update_via_do_ao WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_update_via_doc WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_update_via_doc_do_ao WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_update_via_r WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM resource_updates_schema_info WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM revision_statement WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM rights_restriction WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM rights_restriction_type WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM rights_statement WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM rights_statement_act WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM rights_statement_pre_088 WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM schema_info WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM sequence WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM session WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM spawned_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM sub_container WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM subject WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM subject_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM subject_term WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM subnote_metadata WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM surveyed_by_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM system_event WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM telephone WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM term WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM top_container WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM top_container_housed_at_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM top_container_link_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM top_container_profile_rlshp WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM user WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM user_defined WHERE system_mtime LIKE '2020-03-08 02:00%' | |
| SELECT * FROM vocabulary WHERE system_mtime LIKE '2020-03-08 02:00%' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment