Please enable JavaScript to view this site.

Navigation: Schema: ConfigurationItems > Tables

ConfigurationItems

Catalog: Autotask

Schema: ConfigurationItems

This is a read-only table. The Autotask API may not support changing the data or the Invantive UniversalSQL driver for Autotask does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Autotask API.

Table Columns

The columns of the table ConfigurationItems are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

apiVendorID

int32

API Vendor ID

 

companyID

int32

Company ID

 

companyLocationID

int32

Company Location ID

 

configurationItemCategoryID

int32

Configuration Item Category ID

 

configurationItemType

int32

Configuration Item Type

 

contactID

int32

Contact ID

 

contractID

int32

Contract ID

 

contractServiceBundleID

int32

Contract Service Bundle ID

 

contractServiceID

int32

Contract Service ID

 

createDate

datetime

Created

 

createdByPersonID

int32

Created by Person ID

 

dailyCost

double

Daily Cost

 

dattoAvailableKilobytes

int64

Available Kilobytes

 

dattoDeviceMemoryMegabytes

int32

Device Memory Megabytes

 

dattoDrivesErrors

boolean

Drives Errors

 

dattoHostname

string

Hostname

 

dattoInternalIP

string

Internal IP

 

dattoKernelVersionID

int32

Kernel Version ID

 

dattoLastCheckInDateTime

datetime

Last Check-in Date/Time

 

dattoNICSpeedKilobitsPerSecond

int32

Speed Kilobits per Second

 

dattoNumberOfAgents

int32

Number of Agents

 

dattoNumberOfDrives

int32

Number of Drives

 

dattoNumberOfVolumes

int32

Number of Volumes

 

dattoOffsiteUsedBytes

int64

Off-site Used Bytes

 

dattoOSVersionID

int32

OS Version ID

 

dattoPercentageUsed

double

Percentage Used

 

dattoProtectedKilobytes

int64

Protected Kilobytes

 

dattoRemoteIP

string

Remote IP

 

dattoSerialNumber

string

Serial Number

 

dattoUptimeSeconds

int32

Up-time (seconds)

 

dattoUsedKilobytes

int64

Used (Kilobytes)

 

dattoZFSVersionID

int32

OZFS Version ID

 

deviceNetworkingID

string

Device Networking ID

 

domain

string

Domain

 

domainExpirationDateTime

datetime

Domain Expiration Date/Time

 

domainLastUpdatedDateTime

datetime

Domain Last Updated Date/Time

 

domainRegistrarID

int32

Domain Registrar ID

 

domainRegistrationDateTime

datetime

Domain Registration Date/Time

 

hourlyCost

double

Hourly Cost

 

id

int64

ID

 

impersonatorCreatorResourceID

int32

Imperonsator Creator Resource ID

 

installDate

datetime

Install Date

 

installedByContactID

int32

Installed by Contact ID

 

installedByID

int32

Installed by ID

 

isActive

boolean

Is Active

 

lastActivityPersonID

int32

Last Activity Person ID

 

lastActivityPersonType

int32

Last Acitvity Person Type

 

lastModifiedTime

datetime

Last Modified Time

 

location

string

Location

 

monthlyCost

double

Monthly Cost

 

notes

string

Notes

 

numberOfUsers

double

Number of Users

 

parentConfigurationItemID

int32

Parent Configuration Item ID

 

perUseCost

double

Per Use Cost

 

productID

int32

Product ID

 

referenceNumber

string

Reference Number

 

referenceTitle

string

Reference Title

 

rmmDeviceAuditAntivirusStatusID

int32

Device Audit Anti-virus Status ID

 

rmmDeviceAuditArchitectureID

int32

Device Audit Architecture ID

 

rmmDeviceAuditBackupStatusID

int32

Device Audit Backup Status ID

 

rmmDeviceAuditDescription

string

Device Audit Description

 

rmmDeviceAuditDeviceTypeID

int32

Device Audit Device Type ID

 

rmmDeviceAuditDisplayAdaptorID

int32

Device Audit Display Adaptor ID

 

rmmDeviceAuditDomainID

int32

Device Audit Domain ID

 

rmmDeviceAuditExternalIPAddress

string

Device Audit External IP Address

 

rmmDeviceAuditHostname

string

Device Audit Hostname

 

rmmDeviceAuditIPAddress

string

Devuce Audit IP-address

 

rmmDeviceAuditLastUser

string

Device Audit Last User

 

rmmDeviceAuditMacAddress

string

Device Audit MAC Address

 

rmmDeviceAuditManufacturerID

int32

Device Audit Manufacturer ID

 

rmmDeviceAuditMemoryBytes

int64

Device Audit Memory Bytes

 

rmmDeviceAuditMissingPatchCount

int32

Device Audit Missing Patch Count

 

rmmDeviceAuditMobileNetworkOperatorID

int32

Device Audit Mobile Network Operator ID

 

rmmDeviceAuditMobileNumber

string

Device Audit Mobile Number

 

rmmDeviceAuditModelID

int32

Device Audit Model ID

 

rmmDeviceAuditMotherboardID

int32

Device Audit Motherboard ID

 

rmmDeviceAuditOperatingSystem

string

Device Audit Operating System

 

rmmDeviceAuditPatchStatusID

int32

Device Audit Patch Status ID

 

rmmDeviceAuditProcessorID

int32

Device Audit Processor ID

 

rmmDeviceAuditServicePackID

int32

Device Audit Service Pack ID

 

rmmDeviceAuditSNMPContact

string

Device Audit SNMP Contact

 

rmmDeviceAuditSNMPLocation

string

Device Audit SNMP Location

 

rmmDeviceAuditSNMPName

string

Device Audit SNMP Name

 

rmmDeviceAuditSoftwareStatusID

int32

Device Audit Software Status ID

 

rmmDeviceAuditStorageBytes

int64

Device Audit Storage Bytes

 

rmmDeviceID

int64

Device ID

 

rmmDeviceUID

string

Device UID

 

rmmOpenAlertCount

int32

Open Alert Count

 

serialNumber

string

Serial Number

 

serviceBundleID

int32

Service Bundle ID

 

serviceID

int32

Service ID

 

serviceLevelAgreementID

int32

Service Level Agreement ID

 

setupFee

double

Setup Fee

 

sourceChargeID

int32

Source Charge ID

 

sourceChargeType

int32

Source Charge Type

 

sslCommonName

string

SSL Common Name

 

sslIssuedBy

string

SSL Issued by

 

sslLocation

string

SSL Location

 

sslOrganization

string

SSL Organization

 

sslOrganizationUnit

string

SSL Organization Unit

 

sslSerialNumber

string

SSL Serial Number

 

sslSignatureAlgorithm

string

SSL Signature Algorithm

 

sslSource

string

SSL Source

 

sslValidFromDateTime

datetime

SSL Valid from Date/Time

 

sslValidUntilDateTime

datetime

SSL Valid until Date/Time

 

vendorID

int32

Vendor ID

 

warrantyExpirationDate

datetime

Warranty Expiration Date

 

 

10-06-2024 18:39 Version 24.1.3-BETA+4689

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer