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 |