Skip to content

Instantly share code, notes, and snippets.

@timmc-edx
Last active May 19, 2023 16:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timmc-edx/bf1ef2ccc672df416735deeff449ce45 to your computer and use it in GitHub Desktop.
Save timmc-edx/bf1ef2ccc672df416735deeff449ce45 to your computer and use it in GitHub Desktop.
Finding parent transactions in a New Relic NRQL query based on searching child transactions
select count(*) from Transaction facet name where guid in (
select parentId from (
select count(*) from Transaction facet parentId
where appName = '...' and request_user_id = ... and name = '...'
limit max
)
limit max
)
since 3 days ago limit max
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment