problems.py

#! /usr/bin/python
from dynatrace import Dynatrace
import csv
import os

# Set these via
# export DT_BASE_URL="http://[YOUR-TENANT].live.dynatrace.com"
# export DT_API_TOKEN="[YOUR-TOKEN]"

dt = Dynatrace(
    os.getenv("DT_BASE_URL"),
    os.getenv("DT_API_TOKEN")
)

def formatdate(thedate):
  if thedate:
    return thedate.strftime("%Y-%m")
  else:
    return ""

# adjust as required
#problems = dt.problems.list(time_from="now-30m",problem_selector='status("closed")')
#problems = dt.problems.list(time_from="now-180d",problem_selector='status("closed"),managementZoneIds("mZId-1", "mzId-2")')
#problems = dt.problems.list(time_from="now-30m") #,entity_selector='type("CUSTOM_DEVICE")')
#problems = dt.problems.list(time_from="now-120d",time_to="now-60d",problem_selector='affectedEntityTypes("CUSTOM_DEVICE")')
#problems = dt.problems.list(time_from="2021-01-25T00:00:00",time_to="2023-02-10T00:00:00",problem_selector='affectedEntityTypes("CUSTOM_DEVICE")')
problems = dt.problems.list(time_from="now-1d",problem_selector='status("closed"),managementZoneIds("mZId-1", "mzId-2")')

with open('problems.csv', 'w') as file:
  # create the csv writer
  writer = csv.writer(file)
  file.write("problem, title, status, impact_level, severity_level, start_time, end_time\n")

  if not problems:
    print("No problems found")
    quit()

  for problem in problems:
    # adjust as required
    pr=problem.json()
    print(pr)
    if 'recentComments' in pr:
        co = pr['recentComments']
        for c in co:
          com = co['totalCount']
    else:
          print('Skipping comments')
          com=0
        
    # adjust as required
    file.write("{},{},{},{},{},{},{}\n".format(
    problem.display_id, \
    problem.title,\
    str(problem.status).partition(".")[2],\
    str(problem.impact_level).partition(".")[2],\
    str(problem.severity_level).partition(".")[2],\
    formatdate(problem.start_time),\
    formatdate(problem.end_time)))

  file.close()