Collect github data with prometheus and show in grafana

[schwesig]

• [x] create a mockup: what data needs to be displayed, and how --> https://github.com/open-services-group/scrum/issues/40#issuecomment-1235596924
• [x] collect data via prometheus (prom ql) --> https://github.com/open-services-group/scrum/issues/40#issuecomment-1235602090
• [x] create a grafana dashboard, following the mockup --> https://github.com/open-services-group/scrum/issues/40#issuecomment-1235604477
• [x] deploy apps/grafana/overlays/moc/smaug-public/ --> https://grafana-public.operate-first.cloud/ (https://github.com/operate-first/apps/pull/2367)

[schwesig]

/sig community /area contributor /area community /area monitoring /kind metrics

[sesheta]

@schwesig: The label(s) sig/community, area/contributor, area/community, area/monitoring, kind/metrics cannot be applied, because the repository doesn't have them.

In response to [this](https://github.com/open-services-group/scrum/issues/40#issuecomment-1235590004): >/sig community >/area contributor >/area community >/area monitoring >/kind metrics Instructions for interacting with me using PR comments are available [here](https://git.k8s.io/community/contributors/guide/pull-requests.md). If you have questions or suggestions related to my behavior, please file an issue against the [kubernetes/test-infra](https://github.com/kubernetes/test-infra/issues/new?title=Prow%20issue:) repository.

[schwesig]

create mockup

[schwesig]

promql

• decision for last 4 days:

  • 30 days can take some time to collect
  • so far 4 days (or a week) seem to get fairly fast results
  • wasn't able to pull more data than last 2 days (tbd)

• Project Owner Groups, last 4 days, last

  • count(count by (annotation_op1st_project_owner) (k8s_resource_annotations_info{annotation_op1st_project_owner!=""}))

• Projects, last 4 days, last

  • count(count by (annotation_openshift_io_display_name) (k8s_resource_annotations_info{annotation_openshift_io_display_name!=""}))

• Namespaces, last 4 days, last

  • count(count by (name) (k8s_resource_annotations_info{name!="", annotation_openshift_io_display_name!=""}))

• Projects per Product Owner Group, last 4 days, last

  • (count(k8s_resource_annotations_info{annotation_op1st_project_owner!=""}) by (annotation_op1st_project_owner))

[schwesig]

example: json for Project Owner Groups, last 4 days, last

{
  "id": 4,
  "gridPos": {
    "h": 6,
    "w": 4,
    "x": 0,
    "y": 10
  },
  "type": "stat",
  "title": "Project Owner Groups, last 4 days, last",
  "datasource": {
    "uid": "PDD709D2516BFAE8A",
    "type": "prometheus"
  },
  "pluginVersion": "8.4.3",
  "description": "Project Owner Groups, last 4 days, last",
  "fieldConfig": {
    "defaults": {
      "mappings": [],
      "thresholds": {
        "mode": "absolute",
        "steps": [
          {
            "color": "#ffffff",
            "value": null
          }
        ]
      },
      "color": {
        "mode": "thresholds"
      },
      "unit": ""
    },
    "overrides": []
  },
  "options": {
    "reduceOptions": {
      "values": false,
      "calcs": [
        "last"
      ],
      "fields": ""
    },
    "orientation": "horizontal",
    "textMode": "auto",
    "colorMode": "none",
    "graphMode": "area",
    "justifyMode": "auto"
  },
  "targets": [
    {
      "expr": "count(count by (annotation_op1st_project_owner) (k8s_resource_annotations_info{annotation_op1st_project_owner!=\"\"}))",
      "legendFormat": "Verbose",
      "interval": "",
      "exemplar": false,
      "datasource": {
        "type": "prometheus",
        "uid": "PDD709D2516BFAE8A"
      },
      "refId": "A"
    }
  ]
}

[schwesig]

dashboard snapshot https://grafana.operate-first.cloud/dashboard/snapshot/2I4k71DpSz3wvIWvvnT2eSi08XyVH71N

[schwesig]

/close cleanup after change of organisation

[sesheta]

@schwesig: Closing this issue.

In response to [this](https://github.com/open-services-group/scrum/issues/40#issuecomment-1283728986): >/close >cleanup after change of organisation Instructions for interacting with me using PR comments are available [here](https://git.k8s.io/community/contributors/guide/pull-requests.md). If you have questions or suggestions related to my behavior, please file an issue against the [kubernetes/test-infra](https://github.com/kubernetes/test-infra/issues/new?title=Prow%20issue:) repository.