Skip to main content

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 SnowXMLField in Miss Marple database
IDdbo.Machine.Name
HostNamedbo.Machine.Name
BiosSerialNumberDbo.hardware.ComputerSerialNo
ManufacturerDbo.hardware.ComputerManufacturer
ModelDbo.hardware.ComputerModel
LastUpdateDbo.hardware.ScanTimeUTC
InstallDateDbo.OperatingSystem.OSInstallDate
CompanyDbo.hardware.ComputerManufacturer
IsVirtualDbo.Machine.IsVirtual
IsPortableDbo.Hardware.IsMobile
NumberOfProcessorsDbo.Hardware.ProcessorCount
DccNameDbo.VirtualizationDetails.DatacenterName
HostMachineDbo.ZusaetzlicheDaten.VMHostName
IsVDI* Dependent on HostName and connector configuration

NT service

Field in SnowXMLField in Miss Marple database
AccountName* Calculated from dbo.Service.ServiceAccount and dbo.Machine.Name
NameDbo.Service.DisplayName
PathNameDbo.Service.Commandline
StartupDbo.Service.StartMode
StatusDbo.Service.Started

Application

note

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

Field in SnowXMLFields in Miss Marple database
Namedbo.Computer2CAL.Name
dbo.awServerAppApplicationType.DataField
* Calculated from dbo.Program.FileDescription and dbo.Program.FileName
dbo.Installed.Name
Versiondbo.Computer2CAL.Version
dbo.Computer2ServerApp.Version
dbo.Program.ProductVersion
* Calculated from dbo.Installed.Version
Manufacturerdbo.Computer2CAL.Hersteller
dbo.Computer2ServerApp.Edition *(used for recognition)
dbo.Program.Publisher
dbo.Installed.Publisher
LanguageNamedbo.Program.Language
dbo.Installed.Language
FullVersiondbo.Program.ProductVersion
dbo.Installed.Version
ProductVersiondbo.Program.ProductVersion
dbo.Installed.Version
PathNamedbo.Program.Fullpath
dbo.Installed.Location
FileDateTimedbo.Program.FileLastAccess
FileSizedbo.Program.FileSize
FileDescriptiondbo.Program.FileDescription
FileVersiondbo.Program.FileVersion
ProductNamedbo.Program.ProductName
OriginalFilenamedbo.Program.OriginalName
InstallDatedbo.Installed.InstallDate
UninstallStringdbo.Installed.GUID

Memory

Field in SnowXMLField in Miss Marple database
TotalPhysicalDbo.hardware.RAM

Network adapter

Field in SnowXMLField in Miss Marple database
NameDbo.network.Name
SubnetDbo.Network.SubnetMask
DhcpEnabledDbo.network.DHCP
DefaultGatewayDbo.Network.GatewayAddress
MACAddressDbo.network.MACAddress
IPAddressDbo.network.IPAddress

Operating system

Field in SnowXMLField in Miss Marple database
NameDbo.OperatingSystem.OSName
UserName* Calculated from Dbo.OperatingSystem.LoggedOnuser and Dbo.OperatingSystem.LoggedOnUserDomain
RegisteredUserDbo.OperatingSystem.RegisteredFor
VersionDbo.OperatingSystem.OSVersion
DomainNameDbo.machine.Domain
ComputerNameDbo.machine.Name
VersionInfo* Calculated from dbo.OperatingSystem.OSServiceRelease
SystemUILanguageDbo.OperatingSystem.OSLanguage

Login user

Field in SnowXMLField in Miss Marple database
UserName* Calculated from dbo.RunProgs.Domain, dbo.Machine.Name, and dbo.RunProgs.Benutzer
UpdateTimeDbo.RunProgs.StartTime

Processor

Field in SnowXMLField in Miss Marple database
NameDbo.Hardware.ProcessorName
MaxSpeedDbo.hardware.ProcessorSpeed
ManufacturerDbo.Hardware.ProcessorManufacturer
NumberOfCoresDbo.Hardware.ProcessorCores
NumberOfProcessorsDbo.Hardware.ProcessorCount
ModelDbo.Hardware.ProcessorModel
HyperThreadingDbo.hardware.Hyperthreading

Physical disk

Field in SnowXMLField in Miss Marple database
NameDbo.Drive.Name
DiskSizeDbo.Drive.size

Logical disk

Field in SnowXMLField in Miss Marple database
NameDbo.Partition.Name
FreeSpaceDbo.Partition.SpaceFree
DiskSizeDbo.Partition.Size

Multimedia device

Field in SnowXMLField in Miss Marple database
SoundDeviceNameDbo.Hardware.Soundcard

Display adapter

Field in SnowXMLField in Miss Marple database
DisplayAdapterNameDbo.Hardware.GraphicsAdapter

Monitor

Field in SnowXMLField in Miss Marple database
NameDbo.Hardware.PrimaryMonitor

Virtual machine

Field in SnowXMLField in Miss Marple database
ComputerNameDbo.machine.Name
OperatingSystemDbo.OperatingSystem.OSName

Datacenter

Field in SnowXMLField in Miss Marple database
NameDbo.VirtualizationDetails.DatacenterName

Metering

Field in SnowXMLField 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
FullVersionDbo.RunProgs.Version
ManufacturerDbo.RunProgs.Firma_Name
NameDbo.RunProgs.Name
StartTimeDbo.RunProgs.Startzeit
StopTime* Calculated based on connector configuration and Dbo.RunProgs.Startzeit
Counter1
Day* Calculated based on dbo.RunProgs.Startzeit
FirstUsedDbo.RunProgs.Startzeit
LastUsed* Calculated based on dbo.RunProgs.Startzeit
Minutes* Configured in the connector
UsageMask* Calculated based on dbo.RunProgs.Startzeit
VersionDbo.RunProgs.Version