Retrieved inventory data

The Miss Marple connector replicates inventory data from the Miss Marple database in a standard format that conforms to the Snow XML schema. This XML schema file can be found in the Snow Integration Manager installation directory.

The following sub-sections list the Snow XML schema properties mapped to the respective Miss Marple server information with which they are populated.

Client

Field in SnowXML

Field in Miss Marple database

ID

dbo.Machine.Name

HostName

dbo.Machine.Name

BiosSerialNumber

Dbo.hardware.ComputerSerialNo

Manufacturer

Dbo.hardware.ComputerManufacturer

Model

Dbo.hardware.ComputerModel

LastUpdate

Dbo.hardware.ScanTimeUTC

InstallDate

Dbo.OperatingSystem.OSInstallDate

Company

Dbo.hardware.ComputerManufacturer

IsVirtual

Dbo.Machine.IsVirtual

IsPortable

Dbo.Hardware.IsMobile

NumberOfProcessors

Dbo.Hardware.ProcessorCount

DccName

Dbo.VirtualizationDetails.DatacenterName

HostMachine

Dbo.ZusaetzlicheDaten.VMHostName

IsVDI

* Dependent on HostName and connector configuration

NT service

Field in SnowXML

Field in Miss Marple database

AccountName

* Calculated from dbo.Service.ServiceAccount and dbo.Machine.Name

Name

Dbo.Service.DisplayName

PathName

Dbo.Service.Commandline

Startup

Dbo.Service.StartMode

Status

Dbo.Service.Started

Application

Note

For the Application property, there are up to four separate Miss Marple sources for each field in SnowXML.

Field in SnowXML

Fields in Miss Marple database

Name

dbo.Computer2CAL.Name

dbo.awServerAppApplicationType.DataField

* Calculated from dbo.Program.FileDescription and dbo.Program.FileName

dbo.Installed.Name

Version

dbo.Computer2CAL.Version

dbo.Computer2ServerApp.Version

dbo.Program.ProductVersion

* Calculated from dbo.Installed.Version

Manufacturer

dbo.Computer2CAL.Hersteller

dbo.Computer2ServerApp.Edition *(used for recognition)

dbo.Program.Publisher

dbo.Installed.Publisher

LanguageName

dbo.Program.Language

dbo.Installed.Language

FullVersion

dbo.Program.ProductVersion

dbo.Installed.Version

ProductVersion

dbo.Program.ProductVersion

dbo.Installed.Version

PathName

dbo.Program.Fullpath

dbo.Installed.Location

FileDateTime

dbo.Program.FileLastAccess

FileSize

dbo.Program.FileSize

FileDescription

dbo.Program.FileDescription

FileVersion

dbo.Program.FileVersion

ProductName

dbo.Program.ProductName

OriginalFilename

dbo.Program.OriginalName

InstallDate

dbo.Installed.InstallDate

UninstallString

dbo.Installed.GUID

Memory

Field in SnowXML

Field in Miss Marple database

TotalPhysical

Dbo.hardware.RAM

Network adapter

Field in SnowXML

Field in Miss Marple database

Name

Dbo.network.Name

Subnet

Dbo.Network.SubnetMask

DhcpEnabled

Dbo.network.DHCP

DefaultGateway

Dbo.Network.GatewayAddress

MACAddress

Dbo.network.MACAddress

IPAddress

Dbo.network.IPAddress

Operating system

Field in SnowXML

Field in Miss Marple database

Name

Dbo.OperatingSystem.OSName

UserName

* Calculated from Dbo.OperatingSystem.LoggedOnuser and Dbo.OperatingSystem.LoggedOnUserDomain

RegisteredUser

Dbo.OperatingSystem.RegisteredFor

Version

Dbo.OperatingSystem.OSVersion

DomainName

Dbo.machine.Domain

ComputerName

Dbo.machine.Name

VersionInfo

* Calculated from dbo.OperatingSystem.OSServiceRelease

SystemUILanguage

Dbo.OperatingSystem.OSLanguage

Login user

Field in SnowXML

Field in Miss Marple database

UserName

* Calculated from dbo.RunProgs.Domain, dbo.Machine.Name, and dbo.RunProgs.Benutzer

UpdateTime

Dbo.RunProgs.StartTime

Processor

Field in SnowXML

Field in Miss Marple database

Name

Dbo.Hardware.ProcessorName

MaxSpeed

Dbo.hardware.ProcessorSpeed

Manufacturer

Dbo.Hardware.ProcessorManufacturer

NumberOfCores

Dbo.Hardware.ProcessorCores

NumberOfProcessors

Dbo.Hardware.ProcessorCount

Model

Dbo.Hardware.ProcessorModel

HyperThreading

Dbo.hardware.Hyperthreading

Physical disk

Field in SnowXML

Field in Miss Marple database

Name

Dbo.Drive.Name

DiskSize

Dbo.Drive.size

Logical disk

Field in SnowXML

Field in Miss Marple database

Name

Dbo.Partition.Name

FreeSpace

Dbo.Partition.SpaceFree

DiskSize

Dbo.Partition.Size

Multimedia device

Field in SnowXML

Field in Miss Marple database

SoundDeviceName

Dbo.Hardware.Soundcard

Display adapter

Field in SnowXML

Field in Miss Marple database

DisplayAdapterName

Dbo.Hardware.GraphicsAdapter

Monitor

Field in SnowXML

Field in Miss Marple database

Name

Dbo.Hardware.PrimaryMonitor

Virtual machine

Field in SnowXML

Field in Miss Marple database

ComputerName

Dbo.machine.Name

OperatingSystem

Dbo.OperatingSystem.OSName

Datacenter

Field in SnowXML

Field in Miss Marple database

Name

Dbo.VirtualizationDetails.DatacenterName

Metering

Field in SnowXML

Field in Miss Marple database

DeviceId

* Calculated based on dbo.machine.Name and dbo.RunProgs.Clientname

DomainName

* Calculated based on dbo.RunProgs.Benutzer, dbo.machine.Domain, and dbo.machine.name

UserName

* Calculated based on dbo.RunProgs.Benutzer, dbo.machine.Domain, and dbo.machine.name

PathName

* Calculated based on dbo.RunProgs.EXE_Name

FullVersion

Dbo.RunProgs.Version

Manufacturer

Dbo.RunProgs.Firma_Name

Name

Dbo.RunProgs.Name

StartTime

Dbo.RunProgs.Startzeit

StopTime

* Calculated based on connector configuration and Dbo.RunProgs.Startzeit

Counter

1

Day

* Calculated based on dbo.RunProgs.Startzeit

FirstUsed

Dbo.RunProgs.Startzeit

LastUsed

* Calculated based on dbo.RunProgs.Startzeit

Minutes

* Configured in the connector

UsageMask

* Calculated based on dbo.RunProgs.Startzeit

Version

Dbo.RunProgs.Version