1 files changed, 57 insertions, 0 deletions
diff --git a/lib/gitlab/usage/metrics/instrumentations/count_imported_projects_metric.rb b/lib/gitlab/usage/metrics/instrumentations/count_imported_projects_metric.rb
new file mode 100644
index 00000000000..c5498ce530f
--- /dev/null
+++ b/lib/gitlab/usage/metrics/instrumentations/count_imported_projects_metric.rb
@@ -0,0 +1,57 @@
+# frozen_string_literal: true
+
+module Gitlab
+  module Usage
+    module Metrics
+      module Instrumentations
+        class CountImportedProjectsMetric < DatabaseMetric
+          operation :count
+
+          def initialize(time_frame:, options: {})
+            super
+
+            raise ArgumentError, "import_type options attribute is required" unless import_type.present?
+          end
+
+          relation { ::Project }
+
+          start do |time_constraints|
+            unless time_constraints.nil?
+              start = time_constraints[:created_at]&.first
+
+              unless start.nil?
+                ::Project
+                  .select(:id)
+                  .where(Project.arel_table[:created_at].gteq(start)) # rubocop:disable UsageData/LargeTable
+                  .order(created_at: :asc).limit(1).first&.id
+              end
+            end
+          end
+
+          finish do |time_constraints|
+            unless time_constraints.nil?
+              finish = time_constraints[:created_at]&.last
+
+              unless finish.nil?
+                ::Project
+                  .select(:id)
+                  .where(Project.arel_table[:created_at].lteq(finish)) # rubocop:disable UsageData/LargeTable
+                  .order(created_at: :desc).limit(1).first&.id
+              end
+            end
+          end
+
+          private
+
+          def relation
+            super.imported_from(import_type) # rubocop: disable CodeReuse/ActiveRecord
+          end
+
+          def import_type
+            options[:import_type]
+          end
+        end
+      end
+    end
+  end
+end