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 iQuate iQSonar REST API they are populated with.

Client

Field in SnowXML

Field in iQuate 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

“IQUATE”

PowerState

device | power_state

MainboardType

device | cpu_count

DataCenter

Field in SnowXML

Field in iQuate REST API

Name

application | name

DataCenterMember

Field in SnowXML

Field in iQuate REST API

HostName

device | host_name or

device | device_id

LogicalDisk

Field in SnowXML

Field in iQuate 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 iQuate REST API

UpdateTime

user | login_time

UserName

user | user_name

FullUserName

user | user_name

Memory

Field in SnowXML

Field in iQuate REST API

TotalPhysical

device | total_memory_mb

NetworkAdapter

Field in SnowXML

Field in iQuate 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 iQuate 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 iQuate 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 iQuate 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 iQuate 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 iQuate 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 iQuate 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 iQuate 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 iQuate 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 iQuate 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 iQuate 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 iQuate REST API

ComputerName

device | host_name

IpAddress

device | ip_address | ip_address

OperatingSystem

device | operating_system | name

PowerState

device | power_state

OverallStatus

“Unknown”