If you are using the Gen1/2 Problem page and you save the tile, it will only save filter constructs and time frames, not sorting preferences on the table view. Additionally the tile will only show you a problem count. If you want a table version say a top 10 list, you will need to do this in the Gen3 UI with the new problems page:
Granted this is in a Scatter plot but you can put it into a table format, or even a record format.
Hi @Khejazi ,
Quick and dirty approach (Sorry, vibecoded due to time pressure), you need to install the python modules requests and dynatrace-metric-utils.
#!/usr/bin/env python3
"""Fetch open problems from Dynatrace Problems v2 API, print them, and push duration as metric.ingest."""
import os
import sys
from datetime import datetime, timezone
import requests
from dynatrace.metric.utils import DynatraceMetricsFactory, DynatraceMetricsSerializer, MetricError
DT_ENVIRONMENT = os.environ.get("DT_ENVIRONMENT") # e.g. https://abc12345.live.dynatrace.com
DT_APITOKEN = os.environ.get("DT_APITOKEN")
METRIC_KEY = "problems.active"
factory = DynatraceMetricsFactory()
serializer = DynatraceMetricsSerializer()
def duration_seconds(start_ms, end_ms):
end_ms = end_ms if end_ms and end_ms > 0 else int(datetime.now(timezone.utc).timestamp() * 1000)
return (end_ms - start_ms) // 1000
def format_duration(seconds):
hours, remainder = divmod(seconds, 3600)
minutes, seconds = divmod(remainder, 60)
return f"{hours}h {minutes}m"
def get_open_problems():
if not DT_ENVIRONMENT or not DT_APITOKEN:
sys.exit("Set DT_ENVIRONMENT and DT_APITOKEN environment variables.")
url = f"{DT_ENVIRONMENT.rstrip('/')}/api/v2/problems"
headers = {"Authorization": f"Api-Token {DT_APITOKEN}"}
params = {
"problemSelector": 'status("open")',
"fields": "impactLevel,severityLevel",
}
problems = []
while True:
resp = requests.get(url, headers=headers, params=params, timeout=30)
resp.raise_for_status()
data = resp.json()
problems.extend(data.get("problems", []))
next_page_key = data.get("nextPageKey")
if not next_page_key:
break
params = {"nextPageKey": next_page_key}
return problems
def build_metric_line(problem, seconds):
dimensions = {
"problemId": problem["problemId"],
"displayId": problem.get("displayId", "N/A"),
"title": problem.get("title", "N/A"),
}
metric = factory.create_int_gauge(METRIC_KEY, seconds, dimensions)
return serializer.serialize(metric)
def ingest_metrics(lines):
url = f"{DT_ENVIRONMENT.rstrip('/')}/api/v2/metrics/ingest"
headers = {
"Authorization": f"Api-Token {DT_APITOKEN}",
"Content-Type": "text/plain; charset=utf-8",
}
resp = requests.post(url, headers=headers, data="\n".join(lines), timeout=30)
resp.raise_for_status()
return resp.json()
def main():
problems = get_open_problems()
if not problems:
print("No open problems.")
return
lines = []
for p in problems:
seconds = duration_seconds(p["startTime"], p.get("endTime", -1))
print(
f"{p['problemId']}\t"
f"{p.get('severityLevel', 'N/A')}\t"
f"{p.get('impactLevel', 'N/A')}\t"
f"{p.get('title', 'N/A')}\t"
f"{format_duration(seconds)}"
)
try:
lines.append(build_metric_line(p, seconds))
except MetricError as e:
print(f" skipped metric for {p['problemId']}: {e}")
result = ingest_metrics(lines)
print(f"Ingested: {result.get('linesOk', 0)} ok, {result.get('linesInvalid', 0)} invalid")
if __name__ == "__main__":
main()
Featured Posts
