# How to write DQL to get Vulnerability details for application or process

**URL:** <https://community.dynatrace.com/t/how-to-write-dql-to-get-vulnerability-details-for-application-or-process/54353>\
**Category:** Open Q&A\
**Tags:** dql, appsec-vulnerabilities, site-reliability-guardian, vulnerabilities\
**Created:** [December 10, 2025, 9:20am UTC](https://community.dynatrace.com/t/how-to-write-dql-to-get-vulnerability-details-for-application-or-process/54353 "2025-12-10T09:20:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![heramb\_sawant](https://avatars.discourse-cdn.com/v4/letter/h/c4cdca/32.png) [@heramb\_sawant](https://community.dynatrace.com/u/heramb_sawant)\
**Post date:** [December 10, 2025, 9:20am UTC](https://community.dynatrace.com/t/how-to-write-dql-to-get-vulnerability-details-for-application-or-process/54353/1 "2025-12-10T09:20:01Z")

</div>

Hi Team,  
I w am building SRG for Security check/Vulnerabilities. Can someone help to to know how can I write DQL to fetch vulnerability details from grail.

Regards,  
Heramb sawant

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [December 10, 2025, 1:28pm UTC](https://community.dynatrace.com/t/how-to-write-dql-to-get-vulnerability-details-for-application-or-process/54353/2 "2025-12-10T13:28:43Z")

</div>

Hi,

You can check [DQL examples for security data](https://docs.dynatrace.com/docs/shortlink/security-events-examples).

Best regards

---

<div class="post-metadata">

**Author:** ![sujit\_k\_singh](https://avatars.discourse-cdn.com/v4/letter/s/34f0e0/32.png) [@sujit\_k\_singh](https://community.dynatrace.com/u/sujit_k_singh)\
**Post date:** [December 10, 2025, 9:32pm UTC](https://community.dynatrace.com/t/how-to-write-dql-to-get-vulnerability-details-for-application-or-process/54353/3 "2025-12-10T21:32:37Z")

</div>

Hello&nbsp;[@heramb\_sawant](https://community.dynatrace.com/user/46340)

Vulnerability state reports are stored as security events in Grail. The recommended way is to query the security.events table for VULNERABILITY\_STATE\_REPORT\_EVENT, deduplicate to the latest snapshot per affected entity, and (optionally) join to monitored entities (e.g., process or process group) to enrich with names, tags, ownership, etc.

As usggested by&nbsp;[@AntonPineiro](https://community.dynatrace.com/user/58682)that’s the perfect documentation for this topic—it provides ready-made DQL queries for vulnerability state reports, Management Zone scoping, and severity filters.  
You can also refer to this doc that explains where vulnerability events live in Grail (security.events), including bucket details and retention:[Threat Observability concepts — Dynatrace Docs](https://docs.dynatrace.com/docs/secure/threat-observability/concepts)
