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