---
title: "Get query result"
method: GET
path: "/dashboards"
tags: ["Dashboard"]
---

# Get query result

`GET /dashboards`

## Query parameters

- `queryName` 'countTeams' | 'countUsers' | 'activeEnvironments' | 'paginatedActiveEnvironments' | 'environmentStatus' | 'maxActiveEnvironmentsPerDay' | 'activeEnvironmentsPerDay' | 'countProjects' | 'countTemplates' | 'countDeploymentType' | 'countDeploymentsPerDay' | 'countDeployTypesByUserInTimeRange' | 'needsReview', required
- `startTime` string
- `endTime` string
- `organizationId` string, required

## Response `200`

- union
  - object[]
    - `date` string, required
    - `count` number, required
  - object[]
    - `name` string, required
    - `id` string, required
    - `projectName` string, required
    - `projectId` string, required
    - `status` 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS' | 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS' | 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS', required
    - `user` User, required
      - `email` string
      - `user_id` string
      - `created_at` string
      - `updated_at` string
      - `app_metadata` AppMetadata
        - `organizations` UserOrganization[]
          - `id` string, required
          - `role` string
          - `name` string
        - `isApiKey` boolean
        - `isAutogeneratedTerraformDeployer` boolean
        - `apiKeyType` 'oidc'
        - `createdBy` string
        - `organizationId` string
        - `isSystemUser` boolean
        - `readOnly` boolean
      - `picture` string
      - `name` string
      - `last_login` string
      - `given_name` string
      - `family_name` string
      - `blocked` boolean
    - `createdAt` string, date-time, required
    - `blueprintId` string, required
    - `blueprintName` string, required
    - `isSingleUseBlueprint` boolean
  - object[]
    - `status` 'ACTIVE' | 'FAILED' | 'IN_PROGRESS' | 'WAITING_FOR_USER' | 'DRIFTED' | 'NEVER_DEPLOYED', required
    - `count` number, required
  - object[]
    - `value` number, required
  - object[]
    - `value` number, required
  - object[]
    - `value` number, required
  - object[]
    - `value` number, required
  - object[]
    - `name` string, required
    - `id` string, required
    - `projectName` string, required
    - `projectId` string, required
    - `status` 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS' | 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS' | 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS', required
    - `user` User, required
      - `email` string
      - `user_id` string
      - `created_at` string
      - `updated_at` string
      - `app_metadata` AppMetadata
        - `organizations` UserOrganization[]
          - `id` string, required
          - `role` string
          - `name` string
        - `isApiKey` boolean
        - `isAutogeneratedTerraformDeployer` boolean
        - `apiKeyType` 'oidc'
        - `createdBy` string
        - `organizationId` string
        - `isSystemUser` boolean
        - `readOnly` boolean
      - `picture` string
      - `name` string
      - `last_login` string
      - `given_name` string
      - `family_name` string
      - `blocked` boolean
    - `lastDeploymentDate` string, date-time, required
    - `createdAt` string, date-time, required
    - `blueprintId` string, required
    - `blueprintName` string, required
    - `isSingleUseBlueprint` boolean
    - `isLocked` boolean, required
    - `blueprintType` union, required
      - 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible'
      - 'workflow'
      - 'module'
      - 'approval-policy'
      - 'custom-flow'
      - 'environment-discovery'
      - 'discovery-config'
      - 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible'
      - 'workflow'
      - 'module'
      - 'approval-policy'
      - 'custom-flow'
      - 'environment-discovery'
      - 'discovery-config'
      - 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible'
      - 'workflow'
      - 'module'
      - 'approval-policy'
      - 'custom-flow'
      - 'environment-discovery'
      - 'discovery-config'
      - 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible'
      - 'workflow'
      - 'module'
      - 'approval-policy'
      - 'custom-flow'
      - 'environment-discovery'
      - 'discovery-config'
    - `driftStatus` 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED' | 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED' | 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED', required
    - `latestDeploymentLogError` object
  - DashboardApiQueryPaginatedActiveEnvironmentsResponse
    - `total` number, required
    - `data` object[], required
      - `name` string, required
      - `id` string, required
      - `projectName` string, required
      - `projectId` string, required
      - `status` 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS' | 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS' | 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS', required
      - `user` User, required
        - `email` string
        - `user_id` string
        - `created_at` string
        - `updated_at` string
        - `app_metadata` AppMetadata
          - `organizations` UserOrganization[]
            - `id` string, required
            - `role` string
            - `name` string
          - `isApiKey` boolean
          - `isAutogeneratedTerraformDeployer` boolean
          - `apiKeyType` 'oidc'
          - `createdBy` string
          - `organizationId` string
          - `isSystemUser` boolean
          - `readOnly` boolean
        - `picture` string
        - `name` string
        - `last_login` string
        - `given_name` string
        - `family_name` string
        - `blocked` boolean
      - `lastDeploymentDate` string, date-time, required
      - `createdAt` string, date-time, required
      - `blueprintId` string, required
      - `blueprintName` string, required
      - `isSingleUseBlueprint` boolean
      - `isLocked` boolean, required
      - `blueprintType` union, required
        - 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible'
        - 'workflow'
        - 'module'
        - 'approval-policy'
        - 'custom-flow'
        - 'environment-discovery'
        - 'discovery-config'
        - 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible'
        - 'workflow'
        - 'module'
        - 'approval-policy'
        - 'custom-flow'
        - 'environment-discovery'
        - 'discovery-config'
        - 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible'
        - 'workflow'
        - 'module'
        - 'approval-policy'
        - 'custom-flow'
        - 'environment-discovery'
        - 'discovery-config'
        - 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible' | 'opentofu' | 'terraform' | 'terragrunt' | 'pulumi' | 'k8s' | 'cloudformation' | 'helm' | 'ansible'
        - 'workflow'
        - 'module'
        - 'approval-policy'
        - 'custom-flow'
        - 'environment-discovery'
        - 'discovery-config'
      - `driftStatus` 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED' | 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED' | 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED', required
      - `latestDeploymentLogError` object
  - object[]
    - `date` string, required
    - `deployCount` number, required
    - `destroyCount` number, required
    - `prPlanCount` number, required
    - `moduleTestCount` number, required
  - object[]
    - `deploymentType` string, required
    - `count` number, required
  - object[]
    - `user` User, required
      - `email` string
      - `user_id` string
      - `created_at` string
      - `updated_at` string
      - `app_metadata` AppMetadata
        - `organizations` UserOrganization[]
          - `id` string, required
          - `role` string
          - `name` string
        - `isApiKey` boolean
        - `isAutogeneratedTerraformDeployer` boolean
        - `apiKeyType` 'oidc'
        - `createdBy` string
        - `organizationId` string
        - `isSystemUser` boolean
        - `readOnly` boolean
      - `picture` string
      - `name` string
      - `last_login` string
      - `given_name` string
      - `family_name` string
      - `blocked` boolean
    - `totalDeployments` number, required
    - `deployCount` number, required
    - `destroyCount` number, required
    - `prPlanCount` number, required
    - `moduleTestCount` number, required
  - DashboardApiQueryNeedsReviewResponse
    - `total` number, required
    - `data` object[], required
      - `name` string, required
      - `id` string, required
      - `projectId` string, required
      - `status` 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS' | 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS' | 'CREATED' | 'INACTIVE' | 'ACTIVE' | 'FAILED' | 'TIMEOUT' | 'WAITING_FOR_USER' | 'DEPLOY_IN_PROGRESS' | 'DESTROY_IN_PROGRESS' | 'TASK_IN_PROGRESS' | 'ABORTING' | 'ABORTED' | 'NEVER_DEPLOYED' | 'DRIFTED' | 'DRY_RUN_IN_PROGRESS', required
      - `createdAt` string, date-time, required
      - `updatedAt` string, date-time, required
      - `blueprintId` string, required
      - `driftStatus` 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED' | 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED' | 'ERROR' | 'DRIFTED' | 'OK' | 'NEVER_RUN' | 'DISABLED', required

---

[API](https://skmtc.dev/envzero/apis/env0-api.md) · [All operations](https://skmtc.dev/envzero/apis/env0-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/envzero/env0-api/revisions/513441cbe9dc/schema)