Retrieved inventory data

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

The following sub-sections list the SnowXML 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