Grafana Table - Not Displaying the Data correctly in the Second Row when a new URL is added

Hi Team - We are completely new to the Grafana/Prometheus Tool and below is the stuff we are trying to configure : Monitoring the URLs , and to show the dashboard in TABLE Format having the status of the URL being monitored.

  • What Grafana version and what operating system are you using? grafana-9.3.6, Prometheus - 2.42.0, BlackBox Exporter 0.23.0 on RHEL8.

  • What are you trying to achieve? We have list of URLs to be monitored for availability and we have chosen the Table to show the status code,Probe_success, dns lookup duration, SSL Expiry, http re-directs etc.

  • How are you trying to achieve it? - Configured the same in the list of URLs in Prometheus as shown below

scrape_configs:

  • job_name: “monitoring”
    params:
    module: [http_2xx]
    file_sd_configs:
    - files:
    <path_to_the_targets_file_list_of _URLs>
    relabel_configs:
    - source_labels: [address]
    target_label: __param_target
    - source_labels: [__param_target]
    target_label: instance
    - target_label: address
    replacement: <host_name>:9115 #BlackBox Exporter Instance
  • What happened? - When we add a new URL, the data is not populated exactly on the 2nd row, against the Table headers, but in different rows, thus it creates a new values like VALUE#J,VALUE#K , for example.

  • What did you expect to happen? Note that, we used the SSL Monitoring Dashboard and trying to re-create for URL Monitoring, when we add the second URL , it should be shown exactly like the first record and not creating further rows Separately.

  • Can you copy/paste the configuration(s) that you are having problems with? We are using the configuration like this and having the Transforms as

Join by Field
Mode : OUTER
Filed : Instance — URL to be monitored
Organize Fields
Hidden the values which are not required.

Query ( shown as code):

probe_http_redirects{instance=“Our_url_1”}
probe_http_status_code{instance=“Our_url_1”}
probe_dns_lookup_time_seconds{instance=“Our_url_1”}

probe_http_redirects{instance=“Our_url_2”}
probe_http_status_code{instance=“Our_url_2”}
probe_dns_lookup_time_seconds{instance=“Our_url_2”}

Under the Options We have : Legend : Verbose, Format : Table , Type : Instant

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were. - Not seeing errors

  • Did you follow any online instructions? If so, what is the URL? we didn’t follow any URLs , but imported the SSL Monitoring Dashboard with ID 13230 and trying to convert it to URL Monitoring format by using the Query

Please correct me if i’m wrong and Please help us in this regard

Hi Team - Please can some look into this and help us?

Please refer the screen shot of the table what I get

Hi Team - Can somebody help looking into this issue?