Tables

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Connectors > Alphabetic Connector List > iQuate iQsonar > Extracted Data 

Tables

Table

Column

Type

devices

bios

coreCount

cpuChipCount

cpuCoreCount

cpuSpeed

deviceKey

deviceManufacturer

deviceModel

deviceName

fqdn

importCpuTypeId

importDataSourceId

importDeviceTypeId

importId

importLocationId

importLocationId

importOrgLevel2Id

importUserId

installationDate

inventoryDate

ipAddress

isHyperthreaded

macAddress

operatingSystemId

ram

remarks

serialNumber

threadsPerCore

virtualizationType

String

Integer

Integer

Integer

Integer

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

Boolean

String

String

Integer

String

String

Integer

String

device_relations

importDataSourceId

importDeviceRelTypeId

importFromDeviceId

importId

importToDeviceId

remarks

String

String

String

String

String

String

generic_os

description

genericKey

importDataSourceId

importDeviceId

importId

product

productVersion

publisher

quantity

String

String

String

String

String

String

String

String

Integer

arp

description

importDataSourceId

importDeviceId

importId

installationDate

product

productVersion

publisher

String

String

String

String

String

String

String

String

is

description

genericKey

importDataSourceId

importDeviceId

importId

product

productVersion

publisher

quantity

String

String

String

String

String

String

String

String

Integer

generic_process

description

genericKey

importDataSourceId

importDeviceId

importId

product

productVersion

publisher

quantity

String

String

String

String

String

String

String

String

Integer

generic_applications

description

genericKey

importDataSourceId

importDeviceId

importId

instanceName

lastUsage

product

productVersion

publisher

quantity

String

String

String

String

String

String

String

String

String

String

Integer

users

firstName

importDataSourceId

importId

importLevel2Id

importUserStatusId

isActive

isStUser

lastName

login

String

String

String

String

String

String

String

String

String

accounts

account

accountName

importDataSourceId

importId

importUserId

String

String

String

String

String

db_usages

description

genericKey

importAccountId

importDataSourceId

importId

product

productVersion

publisher

quantity

String

String

String

String

String

String

String

String

String