ConfigurationItemsById |
Catalog: Autotask
Schema: ConfigurationItems
This is a read-only table function. 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.
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function ConfigurationItemsById. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
id |
int64 |
☑ |
|
|
Columns of Table Function
The columns of the table function ConfigurationItemsById 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