|
<< Click to Display Table of Contents >> Raynet One Data Hub > 14.0 > Connectors > Alphabetic Connector List > CloudSphere IQSonar > Extracted Data Tables |
Table |
Column |
Type |
|---|---|---|
devices |
•biosManufacturer •biosName •biosVersion •coreCount •cpuCount •cpuManufacturer •cpuModel •cpuSpeed •cpuType •deviceId •deviceName •deviceTypeHint •evcEnabled •fqdn •ipAddress •isHyperthreaded •isHypervisor •isVirtual •lastDeviceUser •lastScan •locationName •macAddress •manufacturer •maxCapacity •model •onlineVirtualCpu •operatingSystemBuildNumber •operatingSystemEdition •operatingSystemName •operatingSystemProductDescription •operatingSystemProductName •operatingSystemProductVendor •operatingSystemServicePack •operatingSystemVersion •osInstallDate •partitionMode •partitionType •powerState •serialNumber •socketCount •state •status •threasPerCore •totalCoreCount •totalMemoryMb •uptime •virtualHostId •virtualHostName •virtualName •virtualizationPlatform •vmotionEnabled |
•String •String •String •Integer •Integer •String •String •Number •String •String •String •String •Boolean •String •String •Boolean •Boolean •Boolean •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •String •Integer •String •String •Integer •Integer •Integer •String •String •String •String •String •String |
virtual_hosts |
•coreCount •cpuCount •deviceId •deviceTypeHint •hostName •importLocationId •isHypervisor •isVirtual •lastScan •manufacturer •model •operatingSystemBuildNumber •operatingSystemEdition •operatingSystemName •operatingSystemProductDescription •operatingSystemProductName •operatingSystemProductVendor •operatingSystemServicePack •operatingSystemVersion •serialNumber •totalMemoryMb •virtualHostId |
•Integer •Integer •String •String •String •String •Boolean •Boolean •String •String •String •String •String •String •String •String •String •String •String •String •Integer •String |
device_clusters |
•clusterId •clusterName •clusterType •deviceId •virtualHostId |
•String •String •String •String •String |
services |
•description •deviceId •displayName •installDate •name •path •startMode •status |
•String •String •String •String •String •String •String •String |
processes |
•deviceId •name •path •pid •ppid •processArguments •userName |
•String •String •String •Integer •Integer •String •String |
installed_software |
•deviceId •installDate •lastUsedDate •name •operatingSystem •path •usageCount •vendor •version |
•String •String •String •String •String •String •String •String •String |
applications |
•applicationId •deviceId •edition •instanceName •lastScan •parentClusterId •parentClusterName •parentClusterType •productDescription •productName •productVendor •version |
•String •String •String •String •String •String •String •String •String •String •String •String |
application_features |
•applicationId •auxCount •currentlyUsed •dbId •detectedUsageCount •deviceId •firstUsageDate •instanceName •lastSampleDate •lastUsageDate •name •sampleInterval •totalSamplesCount •version |
•String •String •String •String •String •String •String •String •String •String •String •String •String •String |
database_packs |
•accessAgreed •accessGranted •applicationId •deviceId •instanceName •packLabel •packName •targetType |
•String •String •String •String •String •String •String •String |
database_options |
•applicationId •deviceId •instanceName •optionAbbreviation •optionInstalled •optionName •optionUsed |
•String •String •String •String •String •String •String |
database_users |
•accountStatus •applicationId •credentialType •dateCreated •dateCreatedUtc •dbid •deviceId •expiryDate •lastLoggedinUtc •lastLogin •lockDate •userName •userRole |
•String •String •String •String •String •Integer •String •String •String •String •String •String •String |