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 -> bios -> manufacturer
BiosSerialNumber	device -> serial_number
BiosVersion	device -> bios -> version
ID	device -> device_id
ClientType	"SIEDP"
DCCName	application -> name
HostMachine	device -> virtual_host -> host_name
HostName	device -> host_name or device -> device_id
HypervisorName	device -> virualization_platform
IsVirtual	device -> is_virtual
IsHypervisorPlugin	device -> is_hypervisor
LastUpdate	device -> last_scan
Manufacturer	device -> manufacturer
Model	device -> model
NumberOfProcessors	device -> cpu_count
Source	“IQSONAR”
PowerState	device -> power_state
MainboardType	device -> cpu_count

DataCenter

Field in SnowXML	Field in CloudSphere iQSonar REST API
Name	application -> name

DataCenterMember

Field in SnowXML	Field in CloudSphere iQSonar REST API
HostName	device -> host_name or device -> device_id

LogicalDisk

Field in SnowXML	Field in CloudSphere iQSonar REST API
DiskSize	device -> logical_disk -> capacity_gb
Type	device -> logical_disk -> description
FreeSpace	device -> logical_disk -> free_space_gb
Name	device -> logical_disk -> name
VolumeSerialNumber	device -> logical_disk -> volume_serial_number
VolumeName	device -> logical_disk -> description

LoginUser

Field in SnowXML	Field in CloudSphere iQSonar REST API
UpdateTime	user -> login_time
UserName	user -> user_name
FullUserName	user -> user_name

Memory

Field in SnowXML	Field in CloudSphere iQSonar REST API
TotalPhysical	device -> total_memory_mb

NetworkAdapter

Field in SnowXML	Field in CloudSphere iQSonar REST API
DhcpEnabled	device -> ip_address -> is_dhcp_enabled
DhcpServer	device -> ip_address -> dhcp_server
IpAddress	device -> ip_address -> ip_address
MacAddress	device -> ip_address -> mac_address
Name	device -> ip_address -> network_interface

OperatingSystem

Field in SnowXML	Field in CloudSphere iQSonar REST API
ComputerName	device -> host_name or device -> device_id
DomainName	device -> qualified_name -> name
Name	device -> operating_system -> name and device -> operating_system -> edition and device -> operating_system -> osarchitecture or device -> operating_system -> product -> name and device -> operating_system -> edition and device -> operating_system -> osarchitecture or device -> operating_system -> version Note: device -> operating_system -> osarchitecture is only available in API v2.
Manufacturer	device -> operating_system -> product -> vendor
Version	device -> operating_system -> version or device -> operating_system -> build_number
VersionInfo	device -> operating_system -> service_pack
BuildNumber	device -> operating_system -> build_number or device -> operating_system -> name

Software

Field in SnowXML	Field in CloudSphere iQSonar REST API
Name	application -> name and application -> edition or application -> product -> name and application -> edition or installed_software -> name
Version	application -> version or installed_software -> version
FullVersion	application -> version or installed_software -> version
Manufacturer	application -> product -> vendor or installed_software -> vendor
IsRecognized	"1"

OracleDatabaseEnterpriseManagerPacks

Field in SnowXML	Field in CloudSphere iQSonar REST API
DbId	application -> deployed_databases -> database_identity
Name	application -> database_packs -> pack_name
PackAccessGranted	application -> database_packs -> access_granted
PackAccessAgreed	application -> database_packs -> access_agreed

OracleDatabaseInstances

Field in SnowXML	Field in CloudSphere iQSonar REST API
DbId	application -> deployed_databases -> database_identity
DbName	application -> name
HostName	device -> host_name
InstanceName	application -> name
NumberOfProcessorsAssigned	reports -> oracle -> lms_v$license -> CPU_COUNT_CURRENT
OracleCoreCount	reports -> oracle -> lms_detail -> TOTAL_PHYSICAL_CORES
OracleCpuHighWater	reports -> oracle -> lms_v$license -> CPU_COUNT_HIGHWATER
OracleSocketCount	reports -> oracle -> lms_detail -> SOCKETS_POPULATED_PHYS

OracleDatabaseNamedUsers

Field in SnowXML	Field in CloudSphere iQSonar REST API
AccountStatus	application -> users -> account_status
DbId	application -> users -> dbid
LockDate	application -> users -> lock_date
OracleExpiryDate	application -> users -> expiry_date
OracleNamedUser	application -> users -> user_name
OracleNamedUserCreated	application -> users -> date_created

OracleDatabaseTechnology

Field in SnowXML	Field in CloudSphere iQSonar REST API
Cdb	application -> cdb_id
CdbDbId	application -> cdb_id
Created	application -> deployed_databases -> date_created
DatabaseRole	reports -> oracle -> lms_detail -> DB_ROLE
DataGuard	application -> application_features -> name and application -> application_features -> used
DbId	application -> deployed_databases -> database_identity
DbName	application -> name
DbUniqueName	application -> deployed_databases -> name
OpenMode	application -> deployed_databases -> status
OracleDatabaseProduct	application -> product -> name and application -> edition
OracleDatabaseVersion	application -> version
LastDateCheck	application -> last_scan

OracleFeatureUsageStatistics

Field in SnowXML	Field in CloudSphere iQSonar REST API
DbId	application -> deployed_databases -> database_identity
Description	application -> application_features -> description
DetectedUsages	application -> application_features -> detected_usage_count
FirstUsed	application -> application_features -> first_used_date
LastUsed	application -> application_features -> last_used_date
Name	application -> application_features -> name
Used	application -> application_features -> used

OracleSessions

Field in SnowXML	Field in CloudSphere iQSonar REST API
BackgroundSession	application -> sessions -> is_background
ClientProgram	application -> sessions -> client
DbId	application -> deployed_databases -> database_identity
LogonTime	application -> sessions -> session_start_time or application -> sessions -> session_start_date_utc
Machine	application -> sessions -> client_host_name
OracleUser	application -> sessions -> user_name
OsUser	application -> sessions -> os_user
Status	application -> sessions -> status

Processor

Field in SnowXML	Field in CloudSphere iQSonar REST API
ClockSpeed	device -> cpu -> cpu_speed
HyperThreading	device -> cpu -> is_hyperthreaded
Manufacturer	device -> cpu -> manufacturer
Model	device -> cpu -> cpu_model
Name	device -> cpu -> cpu_model
NumberOfCores	device -> core_count
NumberOfProcessors	device -> cpu_count

Service

Field in SnowXML	Field in CloudSphere iQSonar REST API
Name	device -> windows_service -> name or service -> name
PathName	device -> windows_service -> path or service -> path
Startup	device -> windows_service -> start_mode or service -> start_mode
Status	device -> windows_service -> status or service -> status

VirtualMachine

Field in SnowXML	Field in CloudSphere iQSonar REST API
ComputerName	device -> host_name
IpAddress	device -> ip_address -> ip_address
OperatingSystem	device -> operating_system -> name
PowerState	device -> power_state
OverallStatus	“Unknown”