Do all my Snky results have a Jira ticket?

I am trying to understand all SCA items that have not triggered a change management ticket. How do I use JupiterOne to find all Snyk Findings that don't have an associated Jira Ticket created?

Answers

  • This query would show snyk findings relating to some github repo that do not currently have a jira issue associated with them:

    find snyk_finding as result 
      that has github_repo that owns github_account 
      that owns Root that owns jira_account 
      that has jira_project 
      that has jira_issue as ticket 
    where ticket.description!~=result.weblink

This Month's Leaders