## Prerequisite Before you start, please check out the parent epic description to get the full context: https://gitlab.com/groups/gitlab-org/-/epics/19690+ ## Description We ran a search for "archive" and "archival" in the codebase and pulled together the following relevant results for the security domain. We'd need your help with: 1. Review the search results and update the code to use our new ancestor-aware methods and scopes wherever needed 2. Creating new services/workers wherever they're needed 3. **Note:** Not all "archive" mentions are about project archival – feel free to skip anything that's not relevant! ## Archive/Archival Occurrences ### Security / Vulnerabilities 1. ee/app/models/security/project_statistics.rb - [x] [project_ids = ::Vulnerabilities::Statistic.by_group(group).unarchived.select(:project_id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/security/project_statistics.rb#L20) 2. ee/app/models/ee/project.rb - [x] [has_many :vulnerability_archives, class_name: 'Vulnerabilities::Archive'](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/ee/project.rb#L129) 3. ee/app/models/ee/group.rb - [x] [::Vulnerability.where(id: Vulnerabilities::Read.by_group(self).select(:vulnerability_id).unarchived)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/ee/group.rb#L672) - [x] [::Vulnerabilities::Scanner.where(project: Vulnerabilities::Statistic.by_group(self).unarchived.select(:project_id))](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/ee/group.rb#L684) 4. ee/app/models/vulnerabilities/statistic.rb - [x] [scope :unarchived, -\> { where(archived: false) }](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/statistic.rb#L48) - [x] [INSERT INTO %\<table_name\>s AS target (project_id, archived, traversal_ids, latest_pipeline_id, letter_grade, created_at, updated_at)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/statistic.rb#L141) - [x] [VALUES (%{project_id}, %{archived}, %{traversal_ids}, %\<latest_pipeline_id\>d, %\<letter_grade\>d, now(), now())](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/statistic.rb#L142) - [x] [archived: project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/statistic.rb#L157) - [x] [INSERT INTO %\<table_name\>s AS target (project_id, archived, traversal_ids, latest_pipeline_id, letter_grade, created_at, updated_at)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/statistic.rb#L165) - [x] [pipeline.project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/statistic.rb#L182) 5. ee/app/models/vulnerabilities/projects_grade.rb - [x] [.unarchived_projects_for(::Project.id_in(project_ids))](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/projects_grade.rb#L13) - [x] [unarchived_projects_for(projects)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/projects_grade.rb#L124) - [x] [def self.unarchived_projects_for(projects)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/projects_grade.rb#L127) - [x] [projects.non_archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/projects_grade.rb#L130) - [x] [.unarchived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/projects_grade.rb#L139) 6. ee/app/models/vulnerabilities/read.rb - [x] [scope :unarchived, -\> { where(archived: false) }](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/read.rb#L85) - [x] [by_group(group).unarchived.loose_index_scan(column: :traversal_ids)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/read.rb#L197) 7. ee/app/models/vulnerabilities/identifier.rb - [x] [project_ids = ::Vulnerabilities::Statistic.by_group(group).unarchived.select(:project_id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/vulnerabilities/identifier.rb#L60) 8. ee/app/finders/security/vulnerability_elastic_base_finder.rb - [x] [# include_archived_projects: defaulted to `false`. Determines if results will include vulnerabilities](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_elastic_base_finder.rb#L14) - [x] [# associated with archived projects](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_elastic_base_finder.rb#L15) - [x] [include_archived_projects: params\[:include_archived_projects\],](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_elastic_base_finder.rb#L58) 9. ee/app/finders/security/security_policy_projects_finder.rb - [x] [.non_archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/security_policy_projects_finder.rb#L86) 10. ee/app/finders/security/vulnerability_reads_finder.rb - [x] [# include_archived_projects: defaulted to `false`. Determines if results will include vulnerabilities](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_reads_finder.rb#L12) - [x] [# associated with archived projects](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_reads_finder.rb#L13) - [x] [filter_archived_projects](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_reads_finder.rb#L49) - [x] [def filter_archived_projects](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_reads_finder.rb#L89) - [x] [return if params\[:include_archived_projects\] == true](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_reads_finder.rb#L90) - [x] [@vulnerability_reads = vulnerability_reads.unarchived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/security/vulnerability_reads_finder.rb#L94) 11. ee/app/workers/vulnerabilities/update_archived_attribute_of_vulnerability_reads_worker.rb - [x] [class UpdateArchivedAttributeOfVulnerabilityReadsWorker](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/update_archived_attribute_of_vulnerability_reads_worker.rb#L4) - [x] [Vulnerabilities::UpdateArchivedOfVulnerabilityReadsService.execute(project_id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/update_archived_attribute_of_vulnerability_reads_worker.rb#L17) 12. ee/app/workers/vulnerabilities/update_archived_attribute_of_vulnerability_statistics_worker.rb - [x] [class UpdateArchivedAttributeOfVulnerabilityStatisticsWorker](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/update_archived_attribute_of_vulnerability_statistics_worker.rb#L4) - [x] [Vulnerabilities::UpdateArchivedOfVulnerabilityStatisticsService.execute(project_id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/update_archived_attribute_of_vulnerability_statistics_worker.rb#L17) 13. ee/app/workers/vulnerabilities/process_archived_events_worker.rb - [x] [# Ingest archived events to enqueue updating of denormalized column.](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/process_archived_events_worker.rb#L4) - [x] [class ProcessArchivedEventsWorker](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/process_archived_events_worker.rb#L7) - [x] [Vulnerabilities::UpdateArchivedOfVulnerabilityReadsService.execute(project_id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/process_archived_events_worker.rb#L30) - [x] [Vulnerabilities::UpdateArchivedOfVulnerabilityStatisticsService.execute(project_id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/process_archived_events_worker.rb#L31) 14. ee/app/workers/vulnerabilities/namespace_statistics/process_group_delete_events_worker.rb - [x] [Statistic.unarchived.within(traversal_ids)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/vulnerabilities/namespace_statistics/process_group_delete_events_worker.rb#L36) 15. ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb - [x] [# Same applies to the `archived` attribute which is also handled by this](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L11) - [x] [class AdjustTraversalIdsAndArchivedAttributes](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L13) - [x] [archived = map.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L19) - [x] [(%{values}) AS map(vulnerability_id, traversal_ids, archived)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L21) - [x] [vulnerability_reads.archived != map.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L26) - [x] [project.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L70) - [x] [# `archived` attributes of `vulnerability_reads` records by loading the related projects into memory.](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L100) - [x] [# To address this, we check if the `traversal_ids` or `archived` attributes are changed after we update](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L106) - [x] [ensure_archived_consistency](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L112) - [x] [def ensure_archived_consistency](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L122) - [x] [projects_which_archived_changed_after_update.each do |changed_project|](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L123) - [x] [Vulnerabilities::ProcessArchivedEventsWorker.perform_async(](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L124) - [x] ['Projects::ProjectArchivedEvent',](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L125) - [x] [def projects_which_archived_changed_after_update](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L143) - [x] [project_before_update.archived != project_after_update.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/archival/restoration/tasks/adjust_traversal_ids_and_archived_attributes.rb#L147) 16. ee/app/services/vulnerability_exports/export_service.rb - [x] [exportable.vulnerability_reads.unarchived.order_traversal_ids_asc](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerability_exports/export_service.rb#L206) 17. ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb - [x] [schedule_updating_archived_status_if_needed](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L17) - [x] [def schedule_updating_archived_status_if_needed](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L126) - [x] [return unless map_of_projects_to_adjust\[:archival_updated\].present?](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L127) - [x] [Vulnerabilities::UpdateArchivedAttributeOfVulnerabilityReadsWorker.bulk_perform_async_with_contexts(](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L129) - [x] [map_of_projects_to_adjust\[:archival_updated\],](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L130) - [x] [add_into_archival_updated_list_if_needed(map, project, project_with_most_recent_changes)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L162) - [x] [def add_into_archival_updated_list_if_needed(map, project, project_with_most_recent_changes)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L167) - [x] [return if project.archived == project_with_most_recent_changes.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L168) - [x] [map\[:archival_updated\] \<\< project](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/vulnerability_scanning/create_vulnerability_service.rb#L170) 18. ee/app/services/vulnerabilities/starboard_vulnerability_create_service.rb - [x] [process_archival_and_traversal_ids_changes if vulnerability_service_response&.success?](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/starboard_vulnerability_create_service.rb#L69) 19. ee/app/services/security/analyzers_status/update_archived_service.rb - [x] [class UpdateArchivedService](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/analyzers_status/update_archived_service.rb#L5) - [x] [project.analyzer_statuses.update!(archived: project.archived)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/analyzers_status/update_archived_service.rb#L25) 20. ee/app/services/security/ingestion/tasks/ingest_vulnerability_statistics.rb - [x] [AS target (project_id, archived, traversal_ids, letter_grade, created_at, updated_at, %{insert_attributes})](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/tasks/ingest_vulnerability_statistics.rb#L18) - [x] [project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/tasks/ingest_vulnerability_statistics.rb#L60) 21. ee/app/services/security/ingestion/tasks/ingest_vulnerability_reads/upsert.rb - [x] [archived: vulnerability.project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/tasks/ingest_vulnerability_reads/upsert.rb#L35) 22. ee/app/services/security/ingestion/schedule_mark_dropped_as_resolved_service.rb - [x] [.by_projects(::Project.non_archived.id_in(project_id).pluck_primary_key)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/schedule_mark_dropped_as_resolved_service.rb#L98) 23. ee/app/services/security/ingestion/ingest_reports_service.rb - [x] [@original_archived_value = project.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/ingest_reports_service.rb#L14) - [x] [schedule_updating_archived_status_if_needed](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/ingest_reports_service.rb#L26) - [x] [attr_reader :pipeline, :original_archived_value, :original_traversal_ids_value](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/ingest_reports_service.rb#L32) - [x] [def schedule_updating_archived_status_if_needed](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/ingest_reports_service.rb#L100) - [x] [return unless archived_value_changed?](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/ingest_reports_service.rb#L101) - [x] [Vulnerabilities::UpdateArchivedAttributeOfVulnerabilityReadsWorker.perform_async(project.id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/ingest_reports_service.rb#L103) - [x] [def archived_value_changed?](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/ingest_reports_service.rb#L112) - [x] [reloaded_project.archived != original_archived_value](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/ingest_reports_service.rb#L113) 24. ee/app/services/security/ingestion/tasks/ingest_vulnerability_reads/update.rb - [x] [archived: finding_map.project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/ingestion/tasks/ingest_vulnerability_reads/update.rb#L22) 25. ee/app/services/security/inventory_filters/vulnerability_statistics_update_service.rb - [x] [AS target (project_id, project_name, archived, traversal_ids, %{insert_attributes})](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/inventory_filters/vulnerability_statistics_update_service.rb#L8) - [x] [archived = EXCLUDED.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/inventory_filters/vulnerability_statistics_update_service.rb#L14) - [x] [project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/inventory_filters/vulnerability_statistics_update_service.rb#L77) 26. ee/app/services/security/inventory_filters/analyzer_status_update_service.rb - [x] [archived: project.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/inventory_filters/analyzer_status_update_service.rb#L48) 27. ee/app/services/security/analyzer_namespace_statuses/adjustment_service.rb - [x] [ON analyzer_project_statuses.archived = FALSE](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/analyzer_namespace_statuses/adjustment_service.rb#L37) - [x] [-- Handle case where all projects are archived: return 0 counts for existing analyzer types](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/analyzer_namespace_statuses/adjustment_service.rb#L45) - [x] [WHERE analyzer_project_statuses.archived = FALSE](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/analyzer_namespace_statuses/adjustment_service.rb#L60) 28. ee/app/services/security/analyzer_namespace_statuses/find_namespaces_with_analyzer_statuses_service.rb - [x] [analyzer_project_statuses.archived = false](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/security/analyzer_namespace_statuses/find_namespaces_with_analyzer_statuses_service.rb#L22) 29. ee/app/services/vulnerabilities/statistics/update_service.rb - [x] [INSERT INTO #{Statistic.table_name} AS target (project_id, archived, traversal_ids, %{insert_attributes}, letter_grade, created_at, updated_at)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/statistics/update_service.rb#L22) - [x] [VALUES (%{project_id}, %{archived}, %{traversal_ids}, %{insert_values}, %{letter_grade}, now(), now())](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/statistics/update_service.rb#L23) - [x] [archived: project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/statistics/update_service.rb#L60) 30. ee/app/services/vulnerabilities/statistics/adjustment_service.rb - [x] [(project_id, archived, traversal_ids, total, info, unknown, low, medium, high, critical, letter_grade, created_at, updated_at)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/statistics/adjustment_service.rb#L10) - [x] [project_attributes.archived AS archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/statistics/adjustment_service.rb#L29) - [x] [JOIN (%{project_attributes}) project_attributes(project_id, archived, traversal_ids)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/statistics/adjustment_service.rb#L55) - [x] [SELECT project_id, archived, traversal_ids, total, info, unknown, low, medium, high, critical, letter_grade, created_at, updated_at](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/statistics/adjustment_service.rb#L76) - [x] [.pluck(:id, :archived, :traversal_ids, :namespace_id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/statistics/adjustment_service.rb#L215) 31. ee/app/services/vulnerabilities/create_service_base.rb - [x] [@original_archived_value = project.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/create_service_base.rb#L13) - [x] [attr_reader :author, :project, :original_archived_value, :original_traversal_ids_value](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/create_service_base.rb#L19) - [x] [def process_archival_and_traversal_ids_changes](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/create_service_base.rb#L147) - [x] [schedule_updating_archived_status_if_needed](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/create_service_base.rb#L148) - [x] [def schedule_updating_archived_status_if_needed](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/create_service_base.rb#L152) - [x] [return if original_archived_value == reloaded_project.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/create_service_base.rb#L153) - [x] [Vulnerabilities::UpdateArchivedAttributeOfVulnerabilityReadsWorker.perform_async(project.id)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/create_service_base.rb#L155) 32. ee/app/services/vulnerabilities/manually_create_service.rb - [x] [process_archival_and_traversal_ids_changes if response.success?](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/manually_create_service.rb#L55) 33. ee/app/services/vulnerabilities/reads/upsert_service.rb - [x] [archived: vulnerability.project.archived?,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/reads/upsert_service.rb#L142) 34. ee/app/services/vulnerabilities/namespace_statistics/find_vulnerable_namespaces_service.rb - [x] [vulnerability_statistics.archived = false](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/namespace_statistics/find_vulnerable_namespaces_service.rb#L22) 35. ee/app/services/vulnerabilities/namespace_statistics/adjustment_service.rb - [x] [ON vulnerability_statistics.archived = FALSE](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/vulnerabilities/namespace_statistics/adjustment_service.rb#L47) 36. ee/lib/quality/seeders/vulnerabilities.rb - [x] [archived: vulnerability.project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/quality/seeders/vulnerabilities.rb#L185) 37. ee/lib/search/elastic/vulnerability_query_builder.rb - [x] [query_hash = ::Search::Elastic::VulnerabilityFilters.by_archived_projects(](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/search/elastic/vulnerability_query_builder.rb#L16) 38. ee/lib/search/elastic/types/vulnerability.rb - [x] [archived: { type: 'boolean' },](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/search/elastic/types/vulnerability.rb#L51) 39. ee/lib/search/elastic/vulnerability_filters.rb - [x] [def by_archived_projects(query_hash:, options:)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/search/elastic/vulnerability_filters.rb#L44) - [x] [include_archived_projects = !!options\[:include_archived_projects\]](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/search/elastic/vulnerability_filters.rb#L50) - [x] [return query_hash if include_archived_projects](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/search/elastic/vulnerability_filters.rb#L51) - [x] [{ term: { archived: { \_name: context.name(:archived_projects), value: false } } }](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/search/elastic/vulnerability_filters.rb#L55) 40. app/presenters/projects/security/configuration_presenter.rb - [x] [!archived?](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/app/presenters/projects/security/configuration_presenter.rb#L47) 41. ee/app/models/security/analyzer_namespace_status.rb - [x] [@total_projects_count ||= group.all_unarchived_project_ids.size](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/security/analyzer_namespace_status.rb#L23) 42. ee/app/models/security/analyzer_project_status.rb - [x] [scope :unarchived, -\> { where(archived: false) }](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/security/analyzer_project_status.rb#L22) 43. ee/app/models/security/inventory_filter.rb - [x] [validates :archived, allow_nil: false, inclusion: { in: \[true, false\] }](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/security/inventory_filter.rb#L11) 44. ee/app/models/security/project_tracked_context.rb - [x] [event :archive do](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/security/project_tracked_context.rb#L44) 45. ee/app/graphql/resolvers/security/namespace_security_projects_resolver.rb - [x] [finder_params = { include_subgroups: args\[:include_subgroups\], include_archived: false, ids: ids }](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/graphql/resolvers/security/namespace_security_projects_resolver.rb#L55) 46. ee/app/workers/security/analyzers_status/process_archived_events_worker.rb - [x] [class ProcessArchivedEventsWorker](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/security/analyzers_status/process_archived_events_worker.rb#L5) - [x] [UpdateArchivedService.execute(project)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/security/analyzers_status/process_archived_events_worker.rb#L26) - [x] [Security::InventoryFilter.by_project_id(project.id).update(archived: project.archived)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/security/analyzers_status/process_archived_events_worker.rb#L38) 47. ee/app/workers/security/analyzer_namespace_statuses/process_group_deleted_events_worker.rb - [x] [AnalyzerProjectStatus.unarchived.within(traversal_ids)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/security/analyzer_namespace_statuses/process_group_deleted_events_worker.rb#L35) 48. ee/app/services/concerns/security/analyzers_status/aggregated_types_handler.rb - [x] [archived: project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/concerns/security/analyzers_status/aggregated_types_handler.rb#L68) 49. ee/app/services/concerns/security/scan_result_policies/policy_violation_comment_generator.rb - [x] [return true if project.archived?](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/concerns/security/scan_result_policies/policy_violation_comment_generator.rb#L25) 50. ee/app/models/instance_security_dashboard.rb - [x] [def non_archived_project_ids](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/instance_security_dashboard.rb#L26) - [x] [projects.non_archived.limit(limit).pluck_primary_key](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/instance_security_dashboard.rb#L28) - [x] [project_ids = non_archived_project_ids](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/instance_security_dashboard.rb#L39) - [x] [project_ids = non_archived_project_ids](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/instance_security_dashboard.rb#L47) - [x] [project_ids = non_archived_project_ids](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/instance_security_dashboard.rb#L55) 51. ee/lib/ee/gitlab/background_migration/backfill_security_inventory_filters.rb - [x] [statistics_records = sub_batch.select(:project_id, :traversal_ids, :archived, \*SEVERITY_COLUMNS)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_security_inventory_filters.rb#L65) - [x] [archived: stat.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_security_inventory_filters.rb#L113) 52. lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_reads.rb - [x] [class BackfillArchivedAndTraversalIdsToVulnerabilityReads \< BatchedMigrationJob](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_reads.rb#L5) - [x] [operation_name :backfill_archived_and_traversal_ids_in_vulnerability_reads_table](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_reads.rb#L6) - [x] [archived = projects.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_reads.rb#L30) 53. lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb - [x] [class BackfillArchivedAndTraversalIdsToVulnerabilityStatistics \< BatchedMigrationJob](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L5) - [x] [operation_name :backfill_archived_and_traversal_ids_in_vulnerability_statistics_table](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L6) - [x] [WITH project_to_archived_traversal_ids (project_id, archived, traversal_ids) AS (](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L10) - [x] [traversal_ids = project_to_archived_traversal_ids.traversal_ids,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L16) - [x] [archived = project_to_archived_traversal_ids.archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L17) - [x] [project_to_archived_traversal_ids](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L19) - [x] [project_to_archived_traversal_ids.project_id = vulnerability_statistics.project_id AND](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L21) - [x] [scope :archived_and_traversal_ids, -\>(project_ids) {](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L46) - [x] [.pluck(:id, :archived, :traversal_ids)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L48) - [x] [project_info = Project.archived_and_traversal_ids(project_ids)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/lib/gitlab/background_migration/backfill_archived_and_traversal_ids_to_vulnerability_statistics.rb#L55) 54. ee/lib/ee/gitlab/background_migration/backfill_analyzer_project_statuses.rb - [x] [projects_info = sub_batch.pluck(:project_id, :traversal_ids, :latest_pipeline_id, :archived)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_analyzer_project_statuses.rb#L111) - [x] [project_info.each do |project_id, traversal_ids, pipeline_id, archived|](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_analyzer_project_statuses.rb#L119) - [x] [statuses = process_builds(builds, project_id, traversal_ids, archived)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_analyzer_project_statuses.rb#L125) - [x] [def process_builds(builds, project_id, traversal_ids, archived)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_analyzer_project_statuses.rb#L137) - [x] [archived: archived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_analyzer_project_statuses.rb#L158) - [x] [%w\[project_id traversal_ids analyzer_type status last_call build_id archived created_at updated_at\]](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_analyzer_project_statuses.rb#L194) - [x] [status_data\[:archived\],](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/lib/ee/gitlab/background_migration/backfill_analyzer_project_statuses.rb#L206) ### SBOM 1. ee/app/models/ee/group.rb - [x] [Sbom::Occurrence.for_namespace_and_descendants(self).unarchived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/ee/group.rb#L1029) 2. ee/app/services/sbom/ingestion/tasks/ingest_occurrences.rb - [x] [archived: project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/sbom/ingestion/tasks/ingest_occurrences.rb#L52) 3. ee/app/services/sbom/sync_archived_status_service.rb - [x] [class SyncArchivedStatusService](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/sbom/sync_archived_status_service.rb#L4) - [x] [in_lock(lease_key, ttl: LEASE_TTL, sleep_sec: LEASE_TRY_AFTER) { update_archived_status }](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/sbom/sync_archived_status_service.rb#L26) - [x] [def update_archived_status](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/sbom/sync_archived_status_service.rb#L33) - [x] [batch.update_all(archived: project.archived)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/services/sbom/sync_archived_status_service.rb#L35) 4. ee/app/workers/sbom/sync_archived_status_worker.rb - [x] [class SyncArchivedStatusWorker](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/sbom/sync_archived_status_worker.rb#L4) - [x] [::Sbom::SyncArchivedStatusService.new(event.data\['project_id'\]).execute](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/workers/sbom/sync_archived_status_worker.rb#L12) 5. ee/app/models/sbom/occurrence.rb - [x] [scope :unarchived, -\> { where(archived: false) }](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/sbom/occurrence.rb#L95) - [x] [archived: project.archived,](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/models/sbom/occurrence.rb#L101) 6. ee/app/finders/sbom/aggregations_finder.rb - [x] [Sbom::Occurrence.for_namespace_and_descendants(namespace).unarchived.loose_index_scan(column: :traversal_ids)](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/sbom/aggregations_finder.rb#L87) - [x] [.unarchived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/sbom/aggregations_finder.rb#L93) - [x] [.unarchived](https://gitlab.com/gitlab-org/gitlab/-/blob/1870ea27a0cd0da962bb241a7dab239d1337eee0/ee/app/finders/sbom/aggregations_finder.rb#L176)