Skip to content
Book a demoStart free
Connectors

SolarWinds Service Desk connector

Set up the SolarWinds Service Desk connector in Kaivo: authentication, configuration, the 22 BigQuery tables it syncs, and answers to common questions.

SolarWinds Service Desk connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your SolarWinds Service Desk data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your customer support data instead of moving it.

What is the SolarWinds Service Desk connector

Section titled “What is the SolarWinds Service Desk connector”

Sync your SolarWinds Service Desk data into BigQuery with Kaivo to analyse IT tickets, assets, and purchasing.

CategoryTech, Customer Service
AuthenticationAPI key
SetupSelf-service

Getting started with the SolarWinds Service Desk connector

Section titled “Getting started with the SolarWinds Service Desk connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your SolarWinds Service Desk account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key
Your SolarWinds Service Desk API token. See the SolarWinds documentation for instructions.

|

Configuring the SolarWinds Service Desk connector

Section titled “Configuring the SolarWinds Service Desk connector”

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

Tables and columns synced from SolarWinds Service Desk

Section titled “Tables and columns synced from SolarWinds Service Desk”

Kaivo syncs 22 tables from SolarWinds Service Desk into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

assets (75 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
asset_id STRING
asset_type__account_id FLOAT64
asset_type__id FLOAT64
asset_type__name STRING
asset_type__parent_id FLOAT64
category__account_id FLOAT64
category__id FLOAT64
category__name STRING
category__parent_id FLOAT64
created_at STRING
department__id FLOAT64
department__name STRING
href STRING
id FLOAT64
ip_address STRING
latitude STRING
longitude STRING
manufacturer STRING
model STRING
name STRING
owner__available_for_assignment BOOL
owner__avatar__type STRING
owner__avatar__color STRING
owner__avatar__initials STRING
owner__can_be_available_for_assignment BOOL
owner__created_at STRING
owner__disabled BOOL
owner__email STRING
owner__group_id FLOAT64
owner__id FLOAT64
owner__is_user BOOL
owner__name STRING
owner__phone STRING
owner__provider STRING
owner__role__description STRING
owner__role__id FLOAT64
owner__role__name STRING
owner__role__portal BOOL
owner__role__show_my_tasks BOOL
owner__updated_at STRING
serial_number STRING
site__id FLOAT64
site__location STRING
site__name STRING
status__id FLOAT64
status__name STRING
updated_at STRING
user__type STRING
user__available_for_assignment BOOL
user__avatar__type STRING
user__avatar__color STRING
user__avatar__initials STRING
user__avatar__klass STRING
user__can_be_available_for_assignment BOOL
user__created_at STRING
user__disabled BOOL
user__email STRING
user__group_id FLOAT64
user__id FLOAT64
user__is_user BOOL
user__name STRING
user__phone STRING
user__provider STRING
user__reports_to__href STRING
user__reports_to__id FLOAT64
user__role__description STRING
user__role__id FLOAT64
user__role__name STRING
user__role__portal BOOL
user__role__show_my_tasks BOOL
user__send_notifications BOOL
user__updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • assets__custom_fields_values (4 columns)
  • assets__hardware_dates (8 columns)
  • assets__incidents (4 columns)
  • assets__owner__custom_fields_values (4 columns)
  • assets__owner__group_ids (4 columns)
  • assets__purchase_orders (4 columns)
  • assets__tags (4 columns)
  • assets__tasks (5 columns)
  • assets__user__custom_fields_values (4 columns)
  • assets__user__group_ids (4 columns)
  • assets__user__memberships (6 columns)
audits (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action STRING
created_at STRING
department__default_assignee_id FLOAT64
department__id FLOAT64
department__name STRING
hardware_href STRING
message STRING
site__id FLOAT64
site__location STRING
site__name STRING
source_id FLOAT64
source_type STRING
user__available_for_assignment BOOL
user__avatar__type STRING
user__avatar__color STRING
user__avatar__initials STRING
user__can_be_available_for_assignment BOOL
user__created_at STRING
user__disabled BOOL
user__email STRING
user__id FLOAT64
user__last_login STRING
user__mobile_phone STRING
user__name STRING
user__phone STRING
user__provider STRING
user__role__description STRING
user__role__id FLOAT64
user__role__name STRING
user__role__portal BOOL
user__role__show_my_tasks BOOL
user__title STRING
user__updated_at STRING
user_id FLOAT64
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • audits__user__custom_fields_values (10 columns)
  • audits__user__group_ids (4 columns)
catalog_items (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
category__default_tags STRING
category__deleted BOOL
category__id FLOAT64
category__name STRING
created_at STRING
currency STRING
due_days STRING
href STRING
id FLOAT64
name STRING
portal_homepage BOOL
price STRING
request_count FLOAT64
show_due_days BOOL
show_price BOOL
state STRING
subcategory__default_tags STRING
subcategory__deleted BOOL
subcategory__id FLOAT64
subcategory__name STRING
subcategory__parent_id FLOAT64
updated_at STRING
url_id STRING
variables_unparsed STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • catalog_items__category__children (8 columns)
  • catalog_items__tags (4 columns)
  • catalog_items__variables (11 columns)
categories (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
default_tags STRING
deleted BOOL
id FLOAT64
name STRING
parent_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • categories__children (8 columns)
change_catalogs (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
change_plan STRING
created_at STRING
created_by__available_for_assignment BOOL
created_by__avatar__type STRING
created_by__avatar__color STRING
created_by__avatar__initials STRING
created_by__can_be_available_for_assignment BOOL
created_by__created_at STRING
created_by__disabled BOOL
created_by__email STRING
created_by__id FLOAT64
created_by__name STRING
created_by__phone STRING
created_by__provider STRING
created_by__role__description STRING
created_by__role__id FLOAT64
created_by__role__name STRING
created_by__role__portal BOOL
created_by__role__show_my_tasks BOOL
created_by__updated_at STRING
id FLOAT64
name STRING
priority STRING
requested_count FLOAT64
rollback_plan STRING
settings__fields__description__editable BOOL
settings__fields__change_plan__editable BOOL
settings__fields__name__editable BOOL
settings__fields__process__editable BOOL
settings__fields__rollback_plan__editable BOOL
settings__fields__test_plan__editable BOOL
settings__fields__variables__editable BOOL
show_in_portal BOOL
state STRING
test_plan STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • change_catalogs__created_by__custom_fields_values (4 columns)
  • change_catalogs__created_by__group_ids (4 columns)
  • change_catalogs__request_variables (4 columns)
  • change_catalogs__tags (4 columns)
  • change_catalogs__variables (10 columns)
changes (56 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
assignee__available_for_assignment BOOL
assignee__avatar__type STRING
assignee__avatar__color STRING
assignee__avatar__initials STRING
assignee__can_be_available_for_assignment BOOL
assignee__created_at STRING
assignee__disabled BOOL
assignee__email STRING
assignee__group_id FLOAT64
assignee__id FLOAT64
assignee__is_user BOOL
assignee__name STRING
assignee__phone STRING
assignee__provider STRING
assignee__role__description STRING
assignee__role__id FLOAT64
assignee__role__name STRING
assignee__role__portal BOOL
assignee__role__show_my_tasks BOOL
assignee__updated_at STRING
change_plan STRING
created_at STRING
created_by__account_id FLOAT64
created_by__avatar__type STRING
created_by__avatar__color STRING
created_by__avatar__initials STRING
created_by__disabled BOOL
created_by__email STRING
created_by__has_gravatar BOOL
created_by__id FLOAT64
created_by__name STRING
created_by__user_id FLOAT64
description_no_html STRING
href STRING
id FLOAT64
name STRING
number STRING
origin STRING
priority STRING
requester__account_id FLOAT64
requester__avatar__type STRING
requester__avatar__color STRING
requester__avatar__initials STRING
requester__disabled BOOL
requester__email STRING
requester__has_gravatar BOOL
requester__id FLOAT64
requester__name STRING
requester__user_id FLOAT64
rollback_plan STRING
state STRING
test_plan STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • changes__assets (4 columns)
  • changes__assignee__custom_fields_values (4 columns)
  • changes__assignee__group_ids (4 columns)
  • changes__cc (4 columns)
  • changes__changes (4 columns)
  • changes__configuration_items (4 columns)
  • changes__custom_fields_values (4 columns)
  • changes__incidents (4 columns)
  • changes__other_assets (4 columns)
  • changes__problems (4 columns)
  • changes__purchase_orders (4 columns)
  • changes__releases (4 columns)
  • changes__request_variables (4 columns)
  • changes__solutions (4 columns)
  • changes__tags (4 columns)
  • changes__tasks (4 columns)
  • changes__time_tracks (4 columns)
  • changes__workflow_tasks (4 columns)
configuration_items (200 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type__custom BOOL
type__disabled BOOL
type__icon_name STRING
type__id FLOAT64
type__name STRING
type__original_name STRING
type__parent_id FLOAT64
type__updated_at STRING
description STRING
asset_tag STRING
created_at STRING
deleted BOOL
department_id__default_assignee_id FLOAT64
department_id__id FLOAT64
department_id__name STRING
id FLOAT64
manager_id__available_for_assignment BOOL
manager_id__avatar__type STRING
manager_id__avatar__color STRING
manager_id__avatar__initials STRING
manager_id__can_be_available_for_assignment BOOL
manager_id__created_at STRING
manager_id__disabled BOOL
manager_id__email STRING
manager_id__group_id FLOAT64
manager_id__id FLOAT64
manager_id__is_user BOOL
manager_id__name STRING
manager_id__phone STRING
manager_id__provider STRING
manager_id__role__description STRING
manager_id__role__id FLOAT64
manager_id__role__name STRING
manager_id__role__portal BOOL
manager_id__role__show_my_tasks BOOL
manager_id__updated_at STRING
name STRING
parent__type STRING
parent__description STRING
parent__active_directory STRING
parent__address STRING
parent__asset_id STRING
parent__asset_tag STRING
parent__asset_type__account_id FLOAT64
parent__asset_type__id FLOAT64
parent__asset_type__name STRING
parent__asset_type__parent_id FLOAT64
parent__audits_href STRING
parent__category__account_id FLOAT64
parent__category__id FLOAT64
parent__category__name STRING
parent__category__parent_id FLOAT64
parent__city STRING
parent__company_issued BOOL
parent__contact_email STRING
parent__contact_name STRING
parent__contact_phone STRING
parent__cpu STRING
parent__created_at STRING
parent__department__default_assignee_id FLOAT64
parent__department__id FLOAT64
parent__department__name STRING
parent__device_type STRING
parent__end_date STRING
parent__external_ip STRING
parent__hardware_spec_href STRING
parent__hidden_softwares_href STRING
parent__href STRING
parent__id FLOAT64
parent__incidents_href STRING
parent__ip STRING
parent__ip_address STRING
parent__last_report STRING
parent__latitude STRING
parent__longitude STRING
parent__manufacturer STRING
parent__manufacturer_name STRING
parent__model STRING
parent__monitors FLOAT64
parent__name STRING
parent__operating_system STRING
parent__operating_system_version STRING
parent__owner__available_for_assignment BOOL
parent__owner__avatar__type STRING
parent__owner__avatar__color STRING
parent__owner__avatar__initials STRING
parent__owner__can_be_available_for_assignment BOOL
parent__owner__created_at STRING
parent__owner__disabled BOOL
parent__owner__email STRING
parent__owner__group_id FLOAT64
parent__owner__id FLOAT64
parent__owner__is_user BOOL
parent__owner__name STRING
parent__owner__phone STRING
parent__owner__provider STRING
parent__owner__role__description STRING
parent__owner__role__id FLOAT64
parent__owner__role__name STRING
parent__owner__role__portal BOOL
parent__owner__role__show_my_tasks BOOL
parent__owner__updated_at STRING
parent__processor_speed FLOAT64
parent__purchase_orders_href STRING
parent__risks_href STRING
parent__serial_number STRING
parent__site__id FLOAT64
parent__site__location STRING
parent__site__name STRING
parent__softwares_href STRING
parent__start_date STRING
parent__state STRING
parent__status JSON
parent__tag STRING
parent__technical_contact__available_for_assignment BOOL
parent__technical_contact__avatar__type STRING
parent__technical_contact__avatar__color STRING
parent__technical_contact__avatar__initials STRING
parent__technical_contact__can_be_available_for_assignment BOOL
parent__technical_contact__created_at STRING
parent__technical_contact__disabled BOOL
parent__technical_contact__email STRING
parent__technical_contact__group_id FLOAT64
parent__technical_contact__id FLOAT64
parent__technical_contact__is_user BOOL
parent__technical_contact__name STRING
parent__technical_contact__phone STRING
parent__technical_contact__provider STRING
parent__technical_contact__role__description STRING
parent__technical_contact__role__id FLOAT64
parent__technical_contact__role__name STRING
parent__technical_contact__role__portal BOOL
parent__technical_contact__role__show_my_tasks BOOL
parent__technical_contact__updated_at STRING
parent__telephone STRING
parent__updated_at STRING
parent__url STRING
parent__user__type STRING
parent__user__available_for_assignment BOOL
parent__user__avatar__type STRING
parent__user__avatar__color STRING
parent__user__avatar__initials STRING
parent__user__avatar__klass STRING
parent__user__can_be_available_for_assignment BOOL
parent__user__created_at STRING
parent__user__disabled BOOL
parent__user__email STRING
parent__user__group_id FLOAT64
parent__user__id FLOAT64
parent__user__is_user BOOL
parent__user__name STRING
parent__user__phone STRING
parent__user__provider STRING
parent__user__reports_to__href STRING
parent__user__reports_to__id FLOAT64
parent__user__role__description STRING
parent__user__role__id FLOAT64
parent__user__role__name STRING
parent__user__role__portal BOOL
parent__user__role__show_my_tasks BOOL
parent__user__send_notifications BOOL
parent__user__updated_at STRING
parent__vendor_type__id FLOAT64
parent__vendor_type__name STRING
parent__zip STRING
parent_id FLOAT64
parent_type STRING
site_id__id FLOAT64
site_id__location STRING
site_id__name STRING
state_id FLOAT64
type_id FLOAT64
updated_at STRING
user_id__type STRING
user_id__available_for_assignment BOOL
user_id__avatar__type STRING
user_id__avatar__color STRING
user_id__avatar__initials STRING
user_id__avatar__klass STRING
user_id__can_be_available_for_assignment BOOL
user_id__created_at STRING
user_id__disabled BOOL
user_id__email STRING
user_id__group_id FLOAT64
user_id__id FLOAT64
user_id__is_user BOOL
user_id__name STRING
user_id__phone STRING
user_id__provider STRING
user_id__reports_to__href STRING
user_id__reports_to__id FLOAT64
user_id__role__description STRING
user_id__role__id FLOAT64
user_id__role__name STRING
user_id__role__portal BOOL
user_id__role__show_my_tasks BOOL
user_id__send_notifications BOOL
user_id__updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • configuration_items__assets (4 columns)
  • configuration_items__changes (4 columns)
  • configuration_items__configuration_items (4 columns)
  • configuration_items__custom_fields_values (9 columns)
  • configuration_items__discovery_hardwares (4 columns)
  • configuration_items__incidents (4 columns)
  • configuration_items__manager_id__custom_fields_values (4 columns)
  • configuration_items__manager_id__group_ids (4 columns)
  • configuration_items__mobiles (4 columns)
  • configuration_items__other_assets (4 columns)
  • configuration_items__parent__bioses (10 columns)
  • configuration_items__parent__controllers (4 columns)
  • configuration_items__parent__custom_fields_values (4 columns)
  • configuration_items__parent__displays (4 columns)
  • configuration_items__parent__drives (4 columns)
  • configuration_items__parent__hardware_dates (8 columns)
  • configuration_items__parent__incidents (4 columns)
  • configuration_items__parent__inputs (4 columns)
  • configuration_items__parent__items (8 columns)
  • configuration_items__parent__memories (4 columns)
  • configuration_items__parent__networks (10 columns)
  • configuration_items__parent__owner__custom_fields_values (4 columns)
  • configuration_items__parent__owner__group_ids (4 columns)
  • configuration_items__parent__ports (4 columns)
  • configuration_items__parent__printers (4 columns)
  • configuration_items__parent__purchase_orders (4 columns)
  • configuration_items__parent__sounds (4 columns)
  • configuration_items__parent__storages (4 columns)
  • configuration_items__parent__tags (4 columns)
  • configuration_items__parent__tasks (5 columns)
  • configuration_items__parent__technical_contact__custom_fields_values (4 columns)
  • configuration_items__parent__technical_contact__group_ids (4 columns)
  • configuration_items__parent__user__custom_fields_values (4 columns)
  • configuration_items__parent__user__group_ids (4 columns)
  • configuration_items__parent__user__memberships (6 columns)
  • configuration_items__parent__videos (4 columns)
  • configuration_items__problems (4 columns)
  • configuration_items__purchase_orders (4 columns)
  • configuration_items__releases (4 columns)
  • configuration_items__solutions (4 columns)
  • configuration_items__user_id__custom_fields_values (4 columns)
  • configuration_items__user_id__group_ids (4 columns)
  • configuration_items__user_id__memberships (6 columns)
contracts (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_at STRING
end_date STRING
href STRING
id FLOAT64
manufacturer_name STRING
name STRING
start_date STRING
status STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • contracts__custom_fields_values (4 columns)
  • contracts__items (8 columns)
departments (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
default_assignee_id FLOAT64
id FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
groups (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
avatar__type STRING
avatar__color STRING
avatar__klass STRING
disabled BOOL
id FLOAT64
is_user BOOL
name STRING
reports_to__href STRING
reports_to__id FLOAT64
send_notifications BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • groups__custom_fields_values (4 columns)
  • groups__memberships (6 columns)
hardwares (79 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active_directory STRING
address STRING
asset_tag STRING
audits_href STRING
category__id FLOAT64
category__name STRING
cpu STRING
created_at STRING
department__default_assignee_id FLOAT64
department__id FLOAT64
department__name STRING
external_ip STRING
hardware_spec_href STRING
hidden_softwares_href STRING
href STRING
id FLOAT64
incidents_href STRING
ip STRING
latitude STRING
longitude STRING
monitors FLOAT64
name STRING
operating_system STRING
operating_system_version STRING
owner__available_for_assignment BOOL
owner__avatar__type STRING
owner__avatar__color STRING
owner__avatar__initials STRING
owner__can_be_available_for_assignment BOOL
owner__created_at STRING
owner__disabled BOOL
owner__email STRING
owner__group_id FLOAT64
owner__id FLOAT64
owner__is_user BOOL
owner__name STRING
owner__phone STRING
owner__provider STRING
owner__role__description STRING
owner__role__id FLOAT64
owner__role__name STRING
owner__role__portal BOOL
owner__role__show_my_tasks BOOL
owner__updated_at STRING
processor_speed FLOAT64
purchase_orders_href STRING
risks_href STRING
serial_number STRING
site__id FLOAT64
site__location STRING
site__name STRING
softwares_href STRING
status__id FLOAT64
status__name STRING
tag STRING
technical_contact__available_for_assignment BOOL
technical_contact__avatar__type STRING
technical_contact__avatar__color STRING
technical_contact__avatar__initials STRING
technical_contact__can_be_available_for_assignment BOOL
technical_contact__created_at STRING
technical_contact__disabled BOOL
technical_contact__email STRING
technical_contact__group_id FLOAT64
technical_contact__id FLOAT64
technical_contact__is_user BOOL
technical_contact__name STRING
technical_contact__phone STRING
technical_contact__provider STRING
technical_contact__role__description STRING
technical_contact__role__id FLOAT64
technical_contact__role__name STRING
technical_contact__role__portal BOOL
technical_contact__role__show_my_tasks BOOL
technical_contact__updated_at STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • hardwares__bioses (10 columns)
  • hardwares__controllers (4 columns)
  • hardwares__custom_fields_values (4 columns)
  • hardwares__displays (4 columns)
  • hardwares__drives (4 columns)
  • hardwares__inputs (4 columns)
  • hardwares__memories (4 columns)
  • hardwares__networks (10 columns)
  • hardwares__owner__custom_fields_values (4 columns)
  • hardwares__owner__group_ids (4 columns)
  • hardwares__ports (4 columns)
  • hardwares__printers (4 columns)
  • hardwares__sounds (4 columns)
  • hardwares__storages (4 columns)
  • hardwares__technical_contact__custom_fields_values (4 columns)
  • hardwares__technical_contact__group_ids (4 columns)
  • hardwares__videos (4 columns)
incidents (60 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
assignee__type STRING
assignee__avatar__type STRING
assignee__avatar__color STRING
assignee__avatar__initials STRING
assignee__avatar__klass STRING
assignee__disabled BOOL
assignee__email STRING
assignee__group_id FLOAT64
assignee__id FLOAT64
assignee__is_user BOOL
assignee__name STRING
assignee__reports_to__href STRING
assignee__reports_to__id FLOAT64
assignee__send_notifications BOOL
category__default_tags STRING
category__deleted BOOL
category__id FLOAT64
category__name STRING
created_at STRING
created_by__account_id FLOAT64
created_by__avatar__type STRING
created_by__avatar__color STRING
created_by__avatar__initials STRING
created_by__disabled BOOL
created_by__email STRING
created_by__has_gravatar BOOL
created_by__id FLOAT64
created_by__name STRING
created_by__user_id FLOAT64
description_no_html STRING
href STRING
href_account_domain STRING
id FLOAT64
is_service_request BOOL
name STRING
number FLOAT64
number_of_comments FLOAT64
origin STRING
priority STRING
requester__account_id FLOAT64
requester__avatar__type STRING
requester__avatar__color STRING
requester__avatar__initials STRING
requester__disabled BOOL
requester__email STRING
requester__has_gravatar BOOL
requester__id FLOAT64
requester__name STRING
requester__user_id FLOAT64
state STRING
subcategory__default_tags STRING
subcategory__deleted BOOL
subcategory__id FLOAT64
subcategory__name STRING
subcategory__parent_id FLOAT64
updated_at STRING
user_saw_all_comments BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • incidents__assets (4 columns)
  • incidents__assignee__custom_fields_values (4 columns)
  • incidents__assignee__memberships (6 columns)
  • incidents__cc (4 columns)
  • incidents__changes (4 columns)
  • incidents__configuration_items (4 columns)
  • incidents__custom_fields_values (10 columns)
  • incidents__custom_fields_values__raw_value (4 columns)
  • incidents__discovery_hardwares (4 columns)
  • incidents__incidents (4 columns)
  • incidents__mobiles (4 columns)
  • incidents__other_assets (4 columns)
  • incidents__problem (4 columns)
  • incidents__problems (4 columns)
  • incidents__purchase_orders (4 columns)
  • incidents__releases (4 columns)
  • incidents__sla_violations (4 columns)
  • incidents__solutions (4 columns)
  • incidents__tasks (5 columns)
  • incidents__time_tracks (4 columns)
mobiles (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
category__name STRING
company_issued BOOL
department__default_assignee_id FLOAT64
department__id FLOAT64
department__name STRING
device_type STRING
href STRING
id FLOAT64
last_report STRING
manufacturer STRING
model STRING
name STRING
serial_number STRING
site__id FLOAT64
site__location STRING
site__name STRING
status__id FLOAT64
status__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • mobiles__custom_fields_values (4 columns)
problems (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
assignee__available_for_assignment BOOL
assignee__avatar__type STRING
assignee__avatar__color STRING
assignee__avatar__initials STRING
assignee__can_be_available_for_assignment BOOL
assignee__created_at STRING
assignee__disabled BOOL
assignee__email STRING
assignee__group_id FLOAT64
assignee__id FLOAT64
assignee__is_user BOOL
assignee__name STRING
assignee__phone STRING
assignee__provider STRING
assignee__role__description STRING
assignee__role__id FLOAT64
assignee__role__name STRING
assignee__role__portal BOOL
assignee__role__show_my_tasks BOOL
assignee__updated_at STRING
created_at STRING
created_by__account_id FLOAT64
created_by__avatar__type STRING
created_by__avatar__color STRING
created_by__avatar__initials STRING
created_by__disabled BOOL
created_by__email STRING
created_by__has_gravatar BOOL
created_by__id FLOAT64
created_by__name STRING
created_by__user_id FLOAT64
description_no_html STRING
href STRING
id FLOAT64
name STRING
number STRING
priority STRING
requester__account_id FLOAT64
requester__avatar__type STRING
requester__avatar__color STRING
requester__avatar__initials STRING
requester__disabled BOOL
requester__email STRING
requester__has_gravatar BOOL
requester__id FLOAT64
requester__name STRING
requester__user_id FLOAT64
root_cause STRING
state STRING
symptoms STRING
updated_at STRING
workaround STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • problems__assets (4 columns)
  • problems__assignee__custom_fields_values (4 columns)
  • problems__assignee__group_ids (4 columns)
  • problems__changes (4 columns)
  • problems__configuration_items (4 columns)
  • problems__custom_fields_values (4 columns)
  • problems__incidents (4 columns)
  • problems__other_assets (4 columns)
  • problems__problems (4 columns)
  • problems__purchase_orders (4 columns)
  • problems__releases (4 columns)
  • problems__solutions (4 columns)
  • problems__tags (4 columns)
  • problems__tasks (4 columns)
  • problems__time_tracks (4 columns)
purchase_orders (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address STRING
buyer__href STRING
buyer__id FLOAT64
buyer__name STRING
created_at STRING
currency STRING
due_date STRING
href STRING
id FLOAT64
name STRING
notes STRING
number FLOAT64
number_of_attachments FLOAT64
order_date STRING
payment_terms STRING
requester__href STRING
requester__id FLOAT64
requester__name STRING
shipping_address STRING
shipping_handling FLOAT64
state STRING
tax FLOAT64
terms_conditions STRING
total_cost STRING
updated_at STRING
vendor__href STRING
vendor__id FLOAT64
vendor__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • purchase_orders__attachments (4 columns)
  • purchase_orders__purchase_order_items (14 columns)
releases (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
assignee__available_for_assignment BOOL
assignee__avatar__type STRING
assignee__avatar__color STRING
assignee__avatar__initials STRING
assignee__can_be_available_for_assignment BOOL
assignee__created_at STRING
assignee__disabled BOOL
assignee__email STRING
assignee__group_id FLOAT64
assignee__id FLOAT64
assignee__is_user BOOL
assignee__name STRING
assignee__phone STRING
assignee__provider STRING
assignee__role__description STRING
assignee__role__id FLOAT64
assignee__role__name STRING
assignee__role__portal BOOL
assignee__role__show_my_tasks BOOL
assignee__updated_at STRING
build STRING
created_at STRING
created_by__account_id FLOAT64
created_by__avatar__type STRING
created_by__avatar__color STRING
created_by__avatar__initials STRING
created_by__disabled BOOL
created_by__email STRING
created_by__has_gravatar BOOL
created_by__id FLOAT64
created_by__name STRING
created_by__user_id FLOAT64
deploy STRING
description_no_html STRING
href STRING
id FLOAT64
name STRING
number STRING
plan STRING
priority STRING
requester__account_id FLOAT64
requester__avatar__type STRING
requester__avatar__color STRING
requester__avatar__initials STRING
requester__disabled BOOL
requester__email STRING
requester__has_gravatar BOOL
requester__id FLOAT64
requester__name STRING
requester__user_id FLOAT64
state STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • releases__approvers (23 columns)
  • releases__approvers__custom_fields_values (4 columns)
  • releases__approvers__group_ids (4 columns)
  • releases__assets (4 columns)
  • releases__assignee__custom_fields_values (4 columns)
  • releases__assignee__group_ids (4 columns)
  • releases__changes (4 columns)
  • releases__custom_fields_values (4 columns)
  • releases__incidents (4 columns)
  • releases__other_assets (4 columns)
  • releases__problems (4 columns)
  • releases__purchase_orders (4 columns)
  • releases__releases (4 columns)
  • releases__solutions (4 columns)
  • releases__tags (4 columns)
  • releases__tasks (4 columns)
  • releases__time_tracks (4 columns)
risks (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
category STRING
created_at STRING
discarded BOOL
id FLOAT64
name STRING
resolved BOOL
severity STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • risks__affected_assets (6 columns)
roles (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id FLOAT64
name STRING
portal BOOL
show_my_tasks BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sites (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
location STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
solutions (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
creator__email STRING
creator__id FLOAT64
creator__name STRING
description_no_html STRING
href STRING
id FLOAT64
is_allow_to_vote BOOL
name STRING
number FLOAT64
number_of_attachments FLOAT64
number_of_shared_attachments FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • solutions__attachments (4 columns)
  • solutions__shared_attachments (4 columns)
users (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
available_for_assignment BOOL
avatar__type STRING
avatar__color STRING
avatar__initials STRING
can_be_available_for_assignment BOOL
created_at STRING
disabled BOOL
email STRING
id FLOAT64
name STRING
phone STRING
provider STRING
role__description STRING
role__id FLOAT64
role__name STRING
role__portal BOOL
role__show_my_tasks BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • users__custom_fields_values (4 columns)
  • users__group_ids (4 columns)
vendors (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
city STRING
contact_email STRING
contact_name STRING
contact_phone STRING
href STRING
id FLOAT64
name STRING
state STRING
telephone STRING
url STRING
vendor_type__id FLOAT64
vendor_type__name STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the SolarWinds Service Desk sync works

Section titled “How the SolarWinds Service Desk sync works”

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where SolarWinds Service Desk supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for SolarWinds Service Desk?

Section titled “How long does the initial sync take for SolarWinds Service Desk?”

It depends on how much history is in your SolarWinds Service Desk account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when SolarWinds Service Desk’s schema changes?

Section titled “What happens when SolarWinds Service Desk’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in SolarWinds Service Desk, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in SolarWinds Service Desk instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the SolarWinds Service Desk connector in Kaivo and all of its synced data is deleted with it.

Common use cases for SolarWinds Service Desk data

Section titled “Common use cases for SolarWinds Service Desk data”

Use hardwares, assets, and mobiles to report on the IT assets you manage.

Join purchase_orders with vendors and contracts to track IT spend.

Use risks and audits to support IT governance reporting.

Use SolarWinds Service Desk data in your AI and BI tools

Section titled “Use SolarWinds Service Desk data in your AI and BI tools”

Once SolarWinds Service Desk data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with SolarWinds Service Desk data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for SolarWinds Service Desk connector pricing and plan details.

  • HubSpot: Sync HubSpot to BigQuery.
  • Adform: Sync Adform to BigQuery.
  • Amplitude: Sync Amplitude to BigQuery.
  • Auth0: Sync Auth0 to BigQuery.
  • Convex: Sync Convex to BigQuery.
  • Dixa: Sync Dixa to BigQuery.