topic Re: how to calculate following objects in dynatrace in weekly basis in Dashboarding

How to calculate following objects in Dynatrace in weekly basis?

pram — Wed, 15 Jan 2025 13:07:27 GMT

the report should have the following and the same to be shared with on a weekly basis. Please report keeping the focus on the following aspects and share the same. I want to calcultae these in weekly basis please give me with an example .

System availability
Capacity and utilization
Resource spikes
Security alerts

Re: how to calculate following objects in dynatrace in weekly basis

Ramanan_16 — Thu, 09 Jan 2025 09:03:03 GMT

Hi Pram,

1) System Availability - you can use the metric "Host availability %" and split by host. Display it is table format.

2) Capacity and utilization - CPU usage % , Disk used %, Memory used %, NIC connectivity metrics can be used.

3) Resource spikes - You can use the above metrics and change the value from "Auto" to "Max". With this you will be able to capture the spikes.

4) Security alerts - I doubt whether this can be added to the dashboard.

Re: how to calculate following objects in dynatrace in weekly basis

PacoPorro — Thu, 09 Jan 2025 12:09:37 GMT

For security alerts you can try:

fetch events, from:now() - 7d | filter event.kind == "SECURITY_EVENT" | filter isNotNull(dt.entity.host) | lookup [ fetch dt.entity.host | fieldsAdd entity.name ], sourceField:dt.entity.host, lookupField:id | summarize by:{hostName =lookup.entity.name}, eventcount = count() | sort eventcount desc

Re: how to calculate following objects in dynatrace in weekly basis

StrangerThing — Thu, 09 Jan 2025 14:27:04 GMT

This sounds like a great opportunity to use Site Reliability Guardian in combination with a Workflow for automation. Once you've figured out the exact queries you'd like to run, build a SRG and run it weekly with a Workflow. You can then add a step to that Workflow to wait for the SRG to complete and then email the results out.