GitLab-15-Breaking-Changes.md

@@ -361,11 +361,38 @@ supported report file, but this is the first step towards GitLab supporting othe
 
 - [Issue](https://gitlab.com/gitlab-org/gitlab/-/issues/348980)
 
-#### :ballot_box_with_check: find projects that might be affected :gem: [-TODO-]
+#### :ballot_box_with_check: find projects that might be affected :gem:
 
 - Rails query that returns a list of projects that recently generated a coverage report
 - Their CI code then needs checking for references to  `cobertura`
 
+- list all code quality artifacts created in the last 3 months, including project
+
+```ruby
+Ci::JobArtifact.where("file_type = ?", 17).where("created_at > ?", 3.month.ago).find_each do |a|
+ p=Project.find_by_id(a.project_id) 
+ puts "project: '#{p.full_path}' created:'#{a.created_at}' report:'#{a.file}'"
+end
+```
+
+- unique projects generating code quality reports in three months
+- check that their CI code refers to `coverage_report` and not `cobertura`
+- email addresses of owners of affected projects are printed out
+
+```ruby
+prj=[]
+Ci::JobArtifact.where("file_type = ?", 17).where("created_at > ?", 3.month.ago).find_each do |a|
+  prj.push Project.find_by_id(a.project_id)
+end;nil
+prj.uniq.each do |p|
+  puts "#{p.full_path}"
+  powners=p.owners
+  powners.each do |powner|
+    puts "   #{powner.email}"
+  end
+end;nil
+```
+
 ---
 
 ### Known host required for GitLab Runner SSH executor