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 Ivanti Endpoint Manager they are populated with.

Client

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

Computer | Computer_Idn

HostName

Computer | DeviceName

BiosReleaseDate

BIOS | BiosDate

BiosManufacturer

BIOS | Manufacturer

BiosSerialNumber

BIOS | SerialNum

BiosVersion

BIOS | SMBIOSVer

HasUsb

USBControl + Computer | (SELECT SIGN(COUNT(Computer_Idn))

Manufacturer

CompSystem | Manufacturer

Model

CompSystem | Model

IsPortable

CompSystem | CASE ChassisType

WHEN 'Notebook' THEN '1'

WHEN 'LapTop' THEN '1'

WHEN 'Portable' THEN '1'

ELSE '0'

END

NumberOfProcessors

Processor | ProcCount

FullUserName

Computer | FullName

Username

Computer | QualifiedUser

LastUpdate

Computer | HWLastScanDate

Software 1

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

AppSoftware | Computer_Idn

Name

AppSoftware | ExeName

FileSize

AppSoftware | FileSize

FileDate

AppSoftware | FileDate

Version

AppSoftware | Version

FilePath

AppSoftware | Path

Manufacturer

AppSoftware | Vendor

FileName

AppSoftware | FileName

Software 2

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

AppSoftwareSuites | Computer_Idn

Name

AppSoftwareSuites | SuiteName

Version

AppSoftwareSuites | Version

Manufacturer

AppSoftwareSuites | Publisher

InstallDate

AppSoftwareSuites | InstallDate

Software 3

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

ProductInstance | Computer_Idn

Name

ProductInstance | Title

Version

ProductInstance | Version

Manufacturer

ProductInstance | Name

OperatingSystem

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

Operating_System | Computer_Idn

Name

Operating_System | OSType

Version

Operating_System | Version

BuildNumber

OSNT | CurrentBuild

UserUILanguage

OSNT | MUILang

UserName

OSNT | RegisteredOwner

BuildType

OSNT | CurrentType

WindowsDirectory

OSNT | SystemRoot

SerialNumber

OSNT | SerialNumber

ComputerName

Computer | DeviceName

Processor

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

Processor | Computer_Idn

Name

Processor | Type

CurrentClockSpeed

Processor | MhzSpeed

NumberOfProcessors

Processor | ProcCount

ProcessorId

Processor | ID

Manufacturer

Processor | Vendor

Model

Processor | Model

MaxClockSpeed

Processor | MaxSpeed

MMX

Processor | MMX

HyperThreading

Processor | HyperThreading

NumberOfCores

Processor | CoresPerPkg

DisplayAdapter

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

VideoAdapter | Computer_Idn

DisplayAdapterName

VideoAdapter | Type

Resolution

Video | Resolution

Memory

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

Memory | Computer_Idn

TotalPhysical

Memory | BytesTotal

FreePhysical

Memory | BytesAvail

TotalSwap

Memory | COALESCE([PageMaxSize], [PageTotal])

FreeSwap

Memory | COALESCE([PageAvail], [PageAvail2])

TotalVirtual

Memory | VirtTotal

FreeVirtual

Memory | VirtAvail

TotalSlots

Memory | NumSlots

CDROM

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

CDROMDrives | Computer_Idn

Model

CDROMDrives | Name

Type

CDROMDrives | MediaType

PhysicalDisk

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

FixedDrives | Computer_Idn

Cylinders

FixedDrives | Cylinders

Sectors

FixedDrives | Sectors

DiskSize

FixedDrives | StorageTotal

BytesPerSector

FixedDrives | BytesPerSect

Name

FixedDrives | Model

Interface

FixedDrives | Interface

DeviceID

FixedDrives | DeviceID

Type

FixedDrives | MediaType

Partitions

FixedDrives | Partitions

Tracks

FixedDrives | TracksPerCylinder

LogicalDisk

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

LogicalDrives | Computer_Idn

DriveType

LogicalDrives | DriveType

VolumeSerialNumber

LogicalDrives | SerialNumber

VolumeName

LogicalDrives | VolumeLabel

FileSystem

LogicalDrives | FileSystem

Name

LogicalDrives | DriveLetter

DiskSize

LogicalDrives | StorageTotal

FreeSpace

LogicalDrives | StorageAvail

NetworkAdapter

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

BoundAdapter | Computer_Idn

MacAddress

BoundAdapter | PhysAddress

ProductName

BoundAdapter | Description

IpAddress

BoundAdapter | convert(nvarchar,convert(int,PARSENAME([IPAddress], 4))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([IPAddress], 3))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([IPAddress], 2))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([IPAddress], 1))* 1)

IpSubnet

BoundAdapter | convert(nvarchar,convert(int,PARSENAME([SubnetMask], 4))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([SubnetMask], 3))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([SubnetMask], 2))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([SubnetMask], 1))* 1)

DefaultIpGateway

BoundAdapter | convert(nvarchar,convert (int,PARSENAME([DefaultGateway], 4))* 1) + '.'+ convert(nvarchar, convert(int,PARSENAME([DefaultGateway], 3))* 1) + '.'+ convert (nvarchar,convert(int,PARSENAME([DefaultGateway], 2))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([DefaultGateway], 1))* 1)

DhcpServer

BoundAdapter | convert(nvarchar,convert(int,PARSENAME([DHCPServer], 4))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([DHCPServer], 3))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([DHCPServer], 2))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([DHCPServer], 1))* 1)

DhcpEnabled

BoundAdapter | DHCPEnabled

DnsServer

BoundAdapter | convert(nvarchar,convert(int,PARSENAME([PrimaryDNS], 4))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([PrimaryDNS], 3))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([PrimaryDNS], 2))* 1) + '.'+ convert(nvarchar,convert(int,PARSENAME([PrimaryDNS], 1))* 1)

Monitor

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

VideoMonitor | Computer_Idn

Name

VideoMonitor | Model

Service

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

Services | Computer_Idn

Name

Services | Name

USB

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceId

USBDevice | Computer_Idn

Name

USBDevice | Name

Printer

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

Printer | Computer_Idn

Port

Printer | Port

Name

Printer | Name

Keyboard

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

Keyboard | Computer_Idn

Name

Keyboard | Type

Layout

Keyboard | Layout

Mouse

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

PointingDevices | Computer_Idn

Name

PointingDevices | DriverName

Multimedia

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

PeripheralAdapters | Computer_Idn

Name

PeripheralAdapters | Type

Environment

Field in SnowXML

Field in Ivanti Endpoint Manager

ResourceID

EnvironSettings | Computer_Idn

Name

EnvironSettings | Name

VariableValue

EnvironSettings | ValueString