Skip to main content
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.

Written By Lauri Raivio

Last updated 16 days ago

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

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

  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.

Authenticating SolarWinds Service Desk

Authenticate with your API Key.

FieldDescription
API Key

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

Configuring the SolarWinds Service Desk connector

When you set up the connector, you provide:

FieldDescription
Start Date

Any data before this date will not be fetched.

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.

ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
asset_idSTRING
asset_type__account_idFLOAT64
asset_type__idFLOAT64
asset_type__nameSTRING
asset_type__parent_idFLOAT64
category__account_idFLOAT64
category__idFLOAT64
category__nameSTRING
category__parent_idFLOAT64
created_atSTRING
department__idFLOAT64
department__nameSTRING
hrefSTRING
idFLOAT64
ip_addressSTRING
latitudeSTRING
longitudeSTRING
manufacturerSTRING
modelSTRING
nameSTRING
owner__available_for_assignmentBOOL
owner__avatar__typeSTRING
owner__avatar__colorSTRING
owner__avatar__initialsSTRING
owner__can_be_available_for_assignmentBOOL
owner__created_atSTRING
owner__disabledBOOL
owner__emailSTRING
owner__group_idFLOAT64
owner__idFLOAT64
owner__is_userBOOL
owner__nameSTRING
owner__phoneSTRING
owner__providerSTRING
owner__role__descriptionSTRING
owner__role__idFLOAT64
owner__role__nameSTRING
owner__role__portalBOOL
owner__role__show_my_tasksBOOL
owner__updated_atSTRING
serial_numberSTRING
site__idFLOAT64
site__locationSTRING
site__nameSTRING
status__idFLOAT64
status__nameSTRING
updated_atSTRING
user__typeSTRING
user__available_for_assignmentBOOL
user__avatar__typeSTRING
user__avatar__colorSTRING
user__avatar__initialsSTRING
user__avatar__klassSTRING
user__can_be_available_for_assignmentBOOL
user__created_atSTRING
user__disabledBOOL
user__emailSTRING
user__group_idFLOAT64
user__idFLOAT64
user__is_userBOOL
user__nameSTRING
user__phoneSTRING
user__providerSTRING
user__reports_to__hrefSTRING
user__reports_to__idFLOAT64
user__role__descriptionSTRING
user__role__idFLOAT64
user__role__nameSTRING
user__role__portalBOOL
user__role__show_my_tasksBOOL
user__send_notificationsBOOL
user__updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
actionSTRING
created_atSTRING
department__default_assignee_idFLOAT64
department__idFLOAT64
department__nameSTRING
hardware_hrefSTRING
messageSTRING
site__idFLOAT64
site__locationSTRING
site__nameSTRING
source_idFLOAT64
source_typeSTRING
user__available_for_assignmentBOOL
user__avatar__typeSTRING
user__avatar__colorSTRING
user__avatar__initialsSTRING
user__can_be_available_for_assignmentBOOL
user__created_atSTRING
user__disabledBOOL
user__emailSTRING
user__idFLOAT64
user__last_loginSTRING
user__mobile_phoneSTRING
user__nameSTRING
user__phoneSTRING
user__providerSTRING
user__role__descriptionSTRING
user__role__idFLOAT64
user__role__nameSTRING
user__role__portalBOOL
user__role__show_my_tasksBOOL
user__titleSTRING
user__updated_atSTRING
user_idFLOAT64
uuidSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
category__default_tagsSTRING
category__deletedBOOL
category__idFLOAT64
category__nameSTRING
created_atSTRING
currencySTRING
due_daysSTRING
hrefSTRING
idFLOAT64
nameSTRING
portal_homepageBOOL
priceSTRING
request_countFLOAT64
show_due_daysBOOL
show_priceBOOL
stateSTRING
subcategory__default_tagsSTRING
subcategory__deletedBOOL
subcategory__idFLOAT64
subcategory__nameSTRING
subcategory__parent_idFLOAT64
updated_atSTRING
url_idSTRING
variables_unparsedSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
default_tagsSTRING
deletedBOOL
idFLOAT64
nameSTRING
parent_idFLOAT64
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • categories__children (8 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
change_planSTRING
created_atSTRING
created_by__available_for_assignmentBOOL
created_by__avatar__typeSTRING
created_by__avatar__colorSTRING
created_by__avatar__initialsSTRING
created_by__can_be_available_for_assignmentBOOL
created_by__created_atSTRING
created_by__disabledBOOL
created_by__emailSTRING
created_by__idFLOAT64
created_by__nameSTRING
created_by__phoneSTRING
created_by__providerSTRING
created_by__role__descriptionSTRING
created_by__role__idFLOAT64
created_by__role__nameSTRING
created_by__role__portalBOOL
created_by__role__show_my_tasksBOOL
created_by__updated_atSTRING
idFLOAT64
nameSTRING
prioritySTRING
requested_countFLOAT64
rollback_planSTRING
settings__fields__description__editableBOOL
settings__fields__change_plan__editableBOOL
settings__fields__name__editableBOOL
settings__fields__process__editableBOOL
settings__fields__rollback_plan__editableBOOL
settings__fields__test_plan__editableBOOL
settings__fields__variables__editableBOOL
show_in_portalBOOL
stateSTRING
test_planSTRING
updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
assignee__available_for_assignmentBOOL
assignee__avatar__typeSTRING
assignee__avatar__colorSTRING
assignee__avatar__initialsSTRING
assignee__can_be_available_for_assignmentBOOL
assignee__created_atSTRING
assignee__disabledBOOL
assignee__emailSTRING
assignee__group_idFLOAT64
assignee__idFLOAT64
assignee__is_userBOOL
assignee__nameSTRING
assignee__phoneSTRING
assignee__providerSTRING
assignee__role__descriptionSTRING
assignee__role__idFLOAT64
assignee__role__nameSTRING
assignee__role__portalBOOL
assignee__role__show_my_tasksBOOL
assignee__updated_atSTRING
change_planSTRING
created_atSTRING
created_by__account_idFLOAT64
created_by__avatar__typeSTRING
created_by__avatar__colorSTRING
created_by__avatar__initialsSTRING
created_by__disabledBOOL
created_by__emailSTRING
created_by__has_gravatarBOOL
created_by__idFLOAT64
created_by__nameSTRING
created_by__user_idFLOAT64
description_no_htmlSTRING
hrefSTRING
idFLOAT64
nameSTRING
numberSTRING
originSTRING
prioritySTRING
requester__account_idFLOAT64
requester__avatar__typeSTRING
requester__avatar__colorSTRING
requester__avatar__initialsSTRING
requester__disabledBOOL
requester__emailSTRING
requester__has_gravatarBOOL
requester__idFLOAT64
requester__nameSTRING
requester__user_idFLOAT64
rollback_planSTRING
stateSTRING
test_planSTRING
updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
type__customBOOL
type__disabledBOOL
type__icon_nameSTRING
type__idFLOAT64
type__nameSTRING
type__original_nameSTRING
type__parent_idFLOAT64
type__updated_atSTRING
descriptionSTRING
asset_tagSTRING
created_atSTRING
deletedBOOL
department_id__default_assignee_idFLOAT64
department_id__idFLOAT64
department_id__nameSTRING
idFLOAT64
manager_id__available_for_assignmentBOOL
manager_id__avatar__typeSTRING
manager_id__avatar__colorSTRING
manager_id__avatar__initialsSTRING
manager_id__can_be_available_for_assignmentBOOL
manager_id__created_atSTRING
manager_id__disabledBOOL
manager_id__emailSTRING
manager_id__group_idFLOAT64
manager_id__idFLOAT64
manager_id__is_userBOOL
manager_id__nameSTRING
manager_id__phoneSTRING
manager_id__providerSTRING
manager_id__role__descriptionSTRING
manager_id__role__idFLOAT64
manager_id__role__nameSTRING
manager_id__role__portalBOOL
manager_id__role__show_my_tasksBOOL
manager_id__updated_atSTRING
nameSTRING
parent__typeSTRING
parent__descriptionSTRING
parent__active_directorySTRING
parent__addressSTRING
parent__asset_idSTRING
parent__asset_tagSTRING
parent__asset_type__account_idFLOAT64
parent__asset_type__idFLOAT64
parent__asset_type__nameSTRING
parent__asset_type__parent_idFLOAT64
parent__audits_hrefSTRING
parent__category__account_idFLOAT64
parent__category__idFLOAT64
parent__category__nameSTRING
parent__category__parent_idFLOAT64
parent__citySTRING
parent__company_issuedBOOL
parent__contact_emailSTRING
parent__contact_nameSTRING
parent__contact_phoneSTRING
parent__cpuSTRING
parent__created_atSTRING
parent__department__default_assignee_idFLOAT64
parent__department__idFLOAT64
parent__department__nameSTRING
parent__device_typeSTRING
parent__end_dateSTRING
parent__external_ipSTRING
parent__hardware_spec_hrefSTRING
parent__hidden_softwares_hrefSTRING
parent__hrefSTRING
parent__idFLOAT64
parent__incidents_hrefSTRING
parent__ipSTRING
parent__ip_addressSTRING
parent__last_reportSTRING
parent__latitudeSTRING
parent__longitudeSTRING
parent__manufacturerSTRING
parent__manufacturer_nameSTRING
parent__modelSTRING
parent__monitorsFLOAT64
parent__nameSTRING
parent__operating_systemSTRING
parent__operating_system_versionSTRING
parent__owner__available_for_assignmentBOOL
parent__owner__avatar__typeSTRING
parent__owner__avatar__colorSTRING
parent__owner__avatar__initialsSTRING
parent__owner__can_be_available_for_assignmentBOOL
parent__owner__created_atSTRING
parent__owner__disabledBOOL
parent__owner__emailSTRING
parent__owner__group_idFLOAT64
parent__owner__idFLOAT64
parent__owner__is_userBOOL
parent__owner__nameSTRING
parent__owner__phoneSTRING
parent__owner__providerSTRING
parent__owner__role__descriptionSTRING
parent__owner__role__idFLOAT64
parent__owner__role__nameSTRING
parent__owner__role__portalBOOL
parent__owner__role__show_my_tasksBOOL
parent__owner__updated_atSTRING
parent__processor_speedFLOAT64
parent__purchase_orders_hrefSTRING
parent__risks_hrefSTRING
parent__serial_numberSTRING
parent__site__idFLOAT64
parent__site__locationSTRING
parent__site__nameSTRING
parent__softwares_hrefSTRING
parent__start_dateSTRING
parent__stateSTRING
parent__statusJSON
parent__tagSTRING
parent__technical_contact__available_for_assignmentBOOL
parent__technical_contact__avatar__typeSTRING
parent__technical_contact__avatar__colorSTRING
parent__technical_contact__avatar__initialsSTRING
parent__technical_contact__can_be_available_for_assignmentBOOL
parent__technical_contact__created_atSTRING
parent__technical_contact__disabledBOOL
parent__technical_contact__emailSTRING
parent__technical_contact__group_idFLOAT64
parent__technical_contact__idFLOAT64
parent__technical_contact__is_userBOOL
parent__technical_contact__nameSTRING
parent__technical_contact__phoneSTRING
parent__technical_contact__providerSTRING
parent__technical_contact__role__descriptionSTRING
parent__technical_contact__role__idFLOAT64
parent__technical_contact__role__nameSTRING
parent__technical_contact__role__portalBOOL
parent__technical_contact__role__show_my_tasksBOOL
parent__technical_contact__updated_atSTRING
parent__telephoneSTRING
parent__updated_atSTRING
parent__urlSTRING
parent__user__typeSTRING
parent__user__available_for_assignmentBOOL
parent__user__avatar__typeSTRING
parent__user__avatar__colorSTRING
parent__user__avatar__initialsSTRING
parent__user__avatar__klassSTRING
parent__user__can_be_available_for_assignmentBOOL
parent__user__created_atSTRING
parent__user__disabledBOOL
parent__user__emailSTRING
parent__user__group_idFLOAT64
parent__user__idFLOAT64
parent__user__is_userBOOL
parent__user__nameSTRING
parent__user__phoneSTRING
parent__user__providerSTRING
parent__user__reports_to__hrefSTRING
parent__user__reports_to__idFLOAT64
parent__user__role__descriptionSTRING
parent__user__role__idFLOAT64
parent__user__role__nameSTRING
parent__user__role__portalBOOL
parent__user__role__show_my_tasksBOOL
parent__user__send_notificationsBOOL
parent__user__updated_atSTRING
parent__vendor_type__idFLOAT64
parent__vendor_type__nameSTRING
parent__zipSTRING
parent_idFLOAT64
parent_typeSTRING
site_id__idFLOAT64
site_id__locationSTRING
site_id__nameSTRING
state_idFLOAT64
type_idFLOAT64
updated_atSTRING
user_id__typeSTRING
user_id__available_for_assignmentBOOL
user_id__avatar__typeSTRING
user_id__avatar__colorSTRING
user_id__avatar__initialsSTRING
user_id__avatar__klassSTRING
user_id__can_be_available_for_assignmentBOOL
user_id__created_atSTRING
user_id__disabledBOOL
user_id__emailSTRING
user_id__group_idFLOAT64
user_id__idFLOAT64
user_id__is_userBOOL
user_id__nameSTRING
user_id__phoneSTRING
user_id__providerSTRING
user_id__reports_to__hrefSTRING
user_id__reports_to__idFLOAT64
user_id__role__descriptionSTRING
user_id__role__idFLOAT64
user_id__role__nameSTRING
user_id__role__portalBOOL
user_id__role__show_my_tasksBOOL
user_id__send_notificationsBOOL
user_id__updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
typeSTRING
created_atSTRING
end_dateSTRING
hrefSTRING
idFLOAT64
manufacturer_nameSTRING
nameSTRING
start_dateSTRING
statusSTRING
updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • contracts__custom_fields_values (4 columns)
  • contracts__items (8 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
default_assignee_idFLOAT64
idFLOAT64
nameSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
typeSTRING
avatar__typeSTRING
avatar__colorSTRING
avatar__klassSTRING
disabledBOOL
idFLOAT64
is_userBOOL
nameSTRING
reports_to__hrefSTRING
reports_to__idFLOAT64
send_notificationsBOOL
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • groups__custom_fields_values (4 columns)
  • groups__memberships (6 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
active_directorySTRING
addressSTRING
asset_tagSTRING
audits_hrefSTRING
category__idFLOAT64
category__nameSTRING
cpuSTRING
created_atSTRING
department__default_assignee_idFLOAT64
department__idFLOAT64
department__nameSTRING
external_ipSTRING
hardware_spec_hrefSTRING
hidden_softwares_hrefSTRING
hrefSTRING
idFLOAT64
incidents_hrefSTRING
ipSTRING
latitudeSTRING
longitudeSTRING
monitorsFLOAT64
nameSTRING
operating_systemSTRING
operating_system_versionSTRING
owner__available_for_assignmentBOOL
owner__avatar__typeSTRING
owner__avatar__colorSTRING
owner__avatar__initialsSTRING
owner__can_be_available_for_assignmentBOOL
owner__created_atSTRING
owner__disabledBOOL
owner__emailSTRING
owner__group_idFLOAT64
owner__idFLOAT64
owner__is_userBOOL
owner__nameSTRING
owner__phoneSTRING
owner__providerSTRING
owner__role__descriptionSTRING
owner__role__idFLOAT64
owner__role__nameSTRING
owner__role__portalBOOL
owner__role__show_my_tasksBOOL
owner__updated_atSTRING
processor_speedFLOAT64
purchase_orders_hrefSTRING
risks_hrefSTRING
serial_numberSTRING
site__idFLOAT64
site__locationSTRING
site__nameSTRING
softwares_hrefSTRING
status__idFLOAT64
status__nameSTRING
tagSTRING
technical_contact__available_for_assignmentBOOL
technical_contact__avatar__typeSTRING
technical_contact__avatar__colorSTRING
technical_contact__avatar__initialsSTRING
technical_contact__can_be_available_for_assignmentBOOL
technical_contact__created_atSTRING
technical_contact__disabledBOOL
technical_contact__emailSTRING
technical_contact__group_idFLOAT64
technical_contact__idFLOAT64
technical_contact__is_userBOOL
technical_contact__nameSTRING
technical_contact__phoneSTRING
technical_contact__providerSTRING
technical_contact__role__descriptionSTRING
technical_contact__role__idFLOAT64
technical_contact__role__nameSTRING
technical_contact__role__portalBOOL
technical_contact__role__show_my_tasksBOOL
technical_contact__updated_atSTRING
updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
assignee__typeSTRING
assignee__avatar__typeSTRING
assignee__avatar__colorSTRING
assignee__avatar__initialsSTRING
assignee__avatar__klassSTRING
assignee__disabledBOOL
assignee__emailSTRING
assignee__group_idFLOAT64
assignee__idFLOAT64
assignee__is_userBOOL
assignee__nameSTRING
assignee__reports_to__hrefSTRING
assignee__reports_to__idFLOAT64
assignee__send_notificationsBOOL
category__default_tagsSTRING
category__deletedBOOL
category__idFLOAT64
category__nameSTRING
created_atSTRING
created_by__account_idFLOAT64
created_by__avatar__typeSTRING
created_by__avatar__colorSTRING
created_by__avatar__initialsSTRING
created_by__disabledBOOL
created_by__emailSTRING
created_by__has_gravatarBOOL
created_by__idFLOAT64
created_by__nameSTRING
created_by__user_idFLOAT64
description_no_htmlSTRING
hrefSTRING
href_account_domainSTRING
idFLOAT64
is_service_requestBOOL
nameSTRING
numberFLOAT64
number_of_commentsFLOAT64
originSTRING
prioritySTRING
requester__account_idFLOAT64
requester__avatar__typeSTRING
requester__avatar__colorSTRING
requester__avatar__initialsSTRING
requester__disabledBOOL
requester__emailSTRING
requester__has_gravatarBOOL
requester__idFLOAT64
requester__nameSTRING
requester__user_idFLOAT64
stateSTRING
subcategory__default_tagsSTRING
subcategory__deletedBOOL
subcategory__idFLOAT64
subcategory__nameSTRING
subcategory__parent_idFLOAT64
updated_atSTRING
user_saw_all_commentsBOOL
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
category__nameSTRING
company_issuedBOOL
department__default_assignee_idFLOAT64
department__idFLOAT64
department__nameSTRING
device_typeSTRING
hrefSTRING
idFLOAT64
last_reportSTRING
manufacturerSTRING
modelSTRING
nameSTRING
serial_numberSTRING
site__idFLOAT64
site__locationSTRING
site__nameSTRING
status__idFLOAT64
status__nameSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • mobiles__custom_fields_values (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
assignee__available_for_assignmentBOOL
assignee__avatar__typeSTRING
assignee__avatar__colorSTRING
assignee__avatar__initialsSTRING
assignee__can_be_available_for_assignmentBOOL
assignee__created_atSTRING
assignee__disabledBOOL
assignee__emailSTRING
assignee__group_idFLOAT64
assignee__idFLOAT64
assignee__is_userBOOL
assignee__nameSTRING
assignee__phoneSTRING
assignee__providerSTRING
assignee__role__descriptionSTRING
assignee__role__idFLOAT64
assignee__role__nameSTRING
assignee__role__portalBOOL
assignee__role__show_my_tasksBOOL
assignee__updated_atSTRING
created_atSTRING
created_by__account_idFLOAT64
created_by__avatar__typeSTRING
created_by__avatar__colorSTRING
created_by__avatar__initialsSTRING
created_by__disabledBOOL
created_by__emailSTRING
created_by__has_gravatarBOOL
created_by__idFLOAT64
created_by__nameSTRING
created_by__user_idFLOAT64
description_no_htmlSTRING
hrefSTRING
idFLOAT64
nameSTRING
numberSTRING
prioritySTRING
requester__account_idFLOAT64
requester__avatar__typeSTRING
requester__avatar__colorSTRING
requester__avatar__initialsSTRING
requester__disabledBOOL
requester__emailSTRING
requester__has_gravatarBOOL
requester__idFLOAT64
requester__nameSTRING
requester__user_idFLOAT64
root_causeSTRING
stateSTRING
symptomsSTRING
updated_atSTRING
workaroundSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_addressSTRING
buyer__hrefSTRING
buyer__idFLOAT64
buyer__nameSTRING
created_atSTRING
currencySTRING
due_dateSTRING
hrefSTRING
idFLOAT64
nameSTRING
notesSTRING
numberFLOAT64
number_of_attachmentsFLOAT64
order_dateSTRING
payment_termsSTRING
requester__hrefSTRING
requester__idFLOAT64
requester__nameSTRING
shipping_addressSTRING
shipping_handlingFLOAT64
stateSTRING
taxFLOAT64
terms_conditionsSTRING
total_costSTRING
updated_atSTRING
vendor__hrefSTRING
vendor__idFLOAT64
vendor__nameSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
assignee__available_for_assignmentBOOL
assignee__avatar__typeSTRING
assignee__avatar__colorSTRING
assignee__avatar__initialsSTRING
assignee__can_be_available_for_assignmentBOOL
assignee__created_atSTRING
assignee__disabledBOOL
assignee__emailSTRING
assignee__group_idFLOAT64
assignee__idFLOAT64
assignee__is_userBOOL
assignee__nameSTRING
assignee__phoneSTRING
assignee__providerSTRING
assignee__role__descriptionSTRING
assignee__role__idFLOAT64
assignee__role__nameSTRING
assignee__role__portalBOOL
assignee__role__show_my_tasksBOOL
assignee__updated_atSTRING
buildSTRING
created_atSTRING
created_by__account_idFLOAT64
created_by__avatar__typeSTRING
created_by__avatar__colorSTRING
created_by__avatar__initialsSTRING
created_by__disabledBOOL
created_by__emailSTRING
created_by__has_gravatarBOOL
created_by__idFLOAT64
created_by__nameSTRING
created_by__user_idFLOAT64
deploySTRING
description_no_htmlSTRING
hrefSTRING
idFLOAT64
nameSTRING
numberSTRING
planSTRING
prioritySTRING
requester__account_idFLOAT64
requester__avatar__typeSTRING
requester__avatar__colorSTRING
requester__avatar__initialsSTRING
requester__disabledBOOL
requester__emailSTRING
requester__has_gravatarBOOL
requester__idFLOAT64
requester__nameSTRING
requester__user_idFLOAT64
stateSTRING
updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
categorySTRING
created_atSTRING
discardedBOOL
idFLOAT64
nameSTRING
resolvedBOOL
severitySTRING
updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • risks__affected_assets (6 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
idFLOAT64
nameSTRING
portalBOOL
show_my_tasksBOOL
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
idFLOAT64
locationSTRING
nameSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
created_atSTRING
creator__emailSTRING
creator__idFLOAT64
creator__nameSTRING
description_no_htmlSTRING
hrefSTRING
idFLOAT64
is_allow_to_voteBOOL
nameSTRING
numberFLOAT64
number_of_attachmentsFLOAT64
number_of_shared_attachmentsFLOAT64
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • solutions__attachments (4 columns)
  • solutions__shared_attachments (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
available_for_assignmentBOOL
avatar__typeSTRING
avatar__colorSTRING
avatar__initialsSTRING
can_be_available_for_assignmentBOOL
created_atSTRING
disabledBOOL
emailSTRING
idFLOAT64
nameSTRING
phoneSTRING
providerSTRING
role__descriptionSTRING
role__idFLOAT64
role__nameSTRING
role__portalBOOL
role__show_my_tasksBOOL
updated_atSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
addressSTRING
citySTRING
contact_emailSTRING
contact_nameSTRING
contact_phoneSTRING
hrefSTRING
idFLOAT64
nameSTRING
stateSTRING
telephoneSTRING
urlSTRING
vendor_type__idFLOAT64
vendor_type__nameSTRING
zipSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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?

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

Asset inventory

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

Purchasing

Join purchase_orders with vendors and contracts to track IT spend.

Risk and audit

Use risks and audits to support IT governance reporting.

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.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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.

Was this helpful?

Still need help? Share an idea