Navigation: Schema: ConfigurationItems > Tables

ConfigurationItems_ItemsUserDefinedFields

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_ItemsUserDefinedFields are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required
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	☐
name	string	Name	☐
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	☐
value	string	Value	☐
vendorID	int32	Vendor ID	☐
warrantyExpirationDate	datetime	Warranty Expiration Date	☐

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

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.

Please enable JavaScript to view this site.

Autotask API Data Model

ConfigurationItems_ItemsUserDefinedFields

Table Columns

Important Safety and Usage Information