Development

Queries below require integration with either Github or Bitbucket.

Were there any Code Repos added in the last 24 hours?

Find CodeRepo with _beginOn > date.now-24hr and _version=1

Which PRs did this developer open in the last 5 days?

For a developer whose first name is Charlie:

'Charlie' that OPENED PR with _createdOn > date.now - 5days as PR
  return PR.displayName, PR.name, PR.webLink

Or, the following query is more accurate but it requires an IdP integration and proper mapping between the dev users and IdP users:

Find Person with firstName='Charlie'
  that IS (github_user|bitbucket_user)
  that OPENED PR with _createdOn > date.now - 5days as PR
return PR.displayName, PR.name, PR.webLink

Who are the most recent contributors to this repo?

This is particularly useful to identify who might be the best person to fix a newly discovered vulnerability.

Find User as u
  that OPENED PR as PR
  that HAS CodeRepo with name='repo-name' as repo
  return
    u.displayName, u.username,
    PR.displayName, PR.name, PR._createdOn, repo.name
  order by PR._createdOn
  limit 5

What are the code repos for a particular application or project?

Find CodeRepo that relates to (Application|Project) with name='JupiterOne'

Are there unapproved or self-approved code changes in the last week?

Find PR with
  approved=false and
  (createdOn > date.now-7days or updatedOn > date.now-7days)

Are there code commits by an unknown developer in a PR?

Find PR with validated=false