# How to calculate following objects in Dynatrace in weekly basis?

**URL:** <https://community.dynatrace.com/t/how-to-calculate-following-objects-in-dynatrace-in-weekly-basis/49629>\
**Category:** Dashboarding\
**Tags:** dynatrace-managed, dashboards\
**Created:** [January 9, 2025, 8:16am UTC](https://community.dynatrace.com/t/how-to-calculate-following-objects-in-dynatrace-in-weekly-basis/49629 "2025-01-09T08:16:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pram](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@pram](https://community.dynatrace.com/u/pram)\
**Post date:** [January 9, 2025, 8:16am UTC](https://community.dynatrace.com/t/how-to-calculate-following-objects-in-dynatrace-in-weekly-basis/49629/1 "2025-01-09T08:16:05Z")

</div>

the report should have the following and the same to be shared with&nbsp; 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

---

<div class="post-metadata">

**Author:** ![Ramanan\_16](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@Ramanan\_16](https://community.dynatrace.com/u/Ramanan_16)\
**Post date:** [January 9, 2025, 9:03am UTC](https://community.dynatrace.com/t/how-to-calculate-following-objects-in-dynatrace-in-weekly-basis/49629/2 "2025-01-09T09:03:03Z")

</div>

Hi Pram,

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

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

3)&nbsp;&nbsp;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)&nbsp;Security alerts - I doubt whether this can be added to the dashboard.

---

<div class="post-metadata">

**Author:** ![PacoPorro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pacoporro/32/36087_2.png) [@PacoPorro](https://community.dynatrace.com/u/PacoPorro)\
**Post date:** [January 9, 2025, 12:09pm UTC](https://community.dynatrace.com/t/how-to-calculate-following-objects-in-dynatrace-in-weekly-basis/49629/3 "2025-01-09T12:09:37Z")

</div>

For security alerts you can try:

```javascript
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

```

---

<div class="post-metadata">

**Author:** ![StrangerThing](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/strangerthing/32/12182_2.png) [@StrangerThing](https://community.dynatrace.com/u/StrangerThing)\
**Post date:** [January 9, 2025, 2:27pm UTC](https://community.dynatrace.com/t/how-to-calculate-following-objects-in-dynatrace-in-weekly-basis/49629/4 "2025-01-09T14:27:04Z")

</div>

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.