Retrieved information

The connector creates Inventory files using the SnowXML schema. The following sections list the properties that are used in the SnowXML file and what information from CloudSphere iQSonar REST API they are populated with.

Client

Field in SnowXML	Field in CloudSphere iQSonar REST API
BiosManufacturer	device &7C; bios
BiosSerialNumber	device &7C; serial_number
BiosVersion	device &7C; bios
ID	device &7C; device_id
ClientType	"SIEDP"
DCCName	application &7C; name
HostMachine	device &7C; virtual_host
HostName	device &7C; host_name or device
HypervisorName	device &7C; virualization_platform
IsVirtual	device &7C; is_virtual
IsHypervisorPlugin	device &7C; is_hypervisor
LastUpdate	device &7C; last_scan
Manufacturer	device &7C; manufacturer
Model	device &7C; model
NumberOfProcessors	device &7C; cpu_count
Source	“IQSONAR”
PowerState	device &7C; power_state
MainboardType	device &7C; cpu_count

DataCenter

Field in SnowXML	Field in CloudSphere iQSonar REST API
Name	application &7C; name

DataCenterMember

Field in SnowXML	Field in CloudSphere iQSonar REST API
HostName	device &7C; host_name or device

LogicalDisk

Field in SnowXML	Field in CloudSphere iQSonar REST API
DiskSize	device &7C; logical_disk
Type	device &7C; logical_disk
FreeSpace	device &7C; logical_disk
Name	device &7C; logical_disk
VolumeSerialNumber	device &7C; logical_disk
VolumeName	device &7C; logical_disk

LoginUser

Field in SnowXML	Field in CloudSphere iQSonar REST API
UpdateTime	user &7C; login_time
UserName	user &7C; user_name
FullUserName	user &7C; user_name

Memory

Field in SnowXML	Field in CloudSphere iQSonar REST API
TotalPhysical	device &7C; total_memory_mb

NetworkAdapter

Field in SnowXML	Field in CloudSphere iQSonar REST API
DhcpEnabled	device &7C; ip_address
DhcpServer	device &7C; ip_address
IpAddress	device &7C; ip_address
MacAddress	device &7C; ip_address
Name	device &7C; ip_address

OperatingSystem

Field in SnowXML	Field in CloudSphere iQSonar REST API
ComputerName	device &7C; host_name or device
DomainName	device &7C; qualified_name
Name	device &7C; operating_system
Manufacturer	device &7C; operating_system
Version	device &7C; operating_system
VersionInfo	device &7C; operating_system
BuildNumber	device &7C; operating_system

Software

Field in SnowXML	Field in CloudSphere iQSonar REST API
Name	application &7C; name and application
Version	application &7C; version or installed_software
FullVersion	application &7C; version or installed_software
Manufacturer	application &7C; product
IsRecognized	"1"

OracleDatabaseEnterpriseManagerPacks

Field in SnowXML	Field in CloudSphere iQSonar REST API
DbId	application &7C; deployed_databases
Name	application &7C; database_packs
PackAccessGranted	application &7C; database_packs
PackAccessAgreed	application &7C; database_packs

OracleDatabaseInstances

Field in SnowXML	Field in CloudSphere iQSonar REST API
DbId	application &7C; deployed_databases
DbName	application &7C; name
HostName	device &7C; host_name
InstanceName	application &7C; name
NumberOfProcessorsAssigned	reports &7C; oracle
OracleCoreCount	reports &7C; oracle
OracleCpuHighWater	reports &7C; oracle
OracleSocketCount	reports &7C; oracle

OracleDatabaseNamedUsers

Field in SnowXML	Field in CloudSphere iQSonar REST API
AccountStatus	application &7C; users
DbId	application &7C; users
LockDate	application &7C; users
OracleExpiryDate	application &7C; users
OracleNamedUser	application &7C; users
OracleNamedUserCreated	application &7C; users

OracleDatabaseTechnology

Field in SnowXML	Field in CloudSphere iQSonar REST API
Cdb	application &7C; cdb_id
CdbDbId	application &7C; cdb_id
Created	application &7C; deployed_databases
DatabaseRole	reports &7C; oracle
DataGuard	application &7C; application_features
DbId	application &7C; deployed_databases
DbName	application &7C; name
DbUniqueName	application &7C; deployed_databases
OpenMode	application &7C; deployed_databases
OracleDatabaseProduct	application &7C; product
OracleDatabaseVersion	application &7C; version
LastDateCheck	application &7C; last_scan

OracleFeatureUsageStatistics

Field in SnowXML	Field in CloudSphere iQSonar REST API
DbId	application &7C; deployed_databases
Description	application &7C; application_features
DetectedUsages	application &7C; application_features
FirstUsed	application &7C; application_features
LastUsed	application &7C; application_features
Name	application &7C; application_features
Used	application &7C; application_features

OracleSessions

Field in SnowXML	Field in CloudSphere iQSonar REST API
BackgroundSession	application &7C; sessions
ClientProgram	application &7C; sessions
DbId	application &7C; deployed_databases
LogonTime	application &7C; sessions
Machine	application &7C; sessions
OracleUser	application &7C; sessions
OsUser	application &7C; sessions
Status	application &7C; sessions

Processor

Field in SnowXML	Field in CloudSphere iQSonar REST API
ClockSpeed	device &7C; cpu
HyperThreading	device &7C; cpu
Manufacturer	device &7C; cpu
Model	device &7C; cpu
Name	device &7C; cpu
NumberOfCores	device &7C; core_count
NumberOfProcessors	device &7C; cpu_count

Service

Field in SnowXML	Field in CloudSphere iQSonar REST API
Name	device &7C; windows_service
PathName	device &7C; windows_service
Startup	device &7C; windows_service
Status	device &7C; windows_service

VirtualMachine

Field in SnowXML	Field in CloudSphere iQSonar REST API
ComputerName	device &7C; host_name
IpAddress	device &7C; ip_address
OperatingSystem	device &7C; operating_system
PowerState	device &7C; power_state
OverallStatus	“Unknown”