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 |