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 Microsoft SCCM they are populated with.

Retrieved computer information

USB

Field in SnowXML	Field in SCCM
ResourceId	v_GS_USB_CONTROLLER -> ResourceId
Name	v_GS_USB_CONTROLLER -> Name0

Client

Field in SnowXML	Field in SCCM
HasUsb	v_GS_USB_CONTROLLER -> SIGN(COUNT(ResourceID))
HostMachine	v_GS_VIRTUAL_MACHINE_64 and v_GS_VIRTUAL_MACHINE -> physicalhostname0
LastScanDate	v_GS_SoftwareUsageData + v_GS_LastSoftwareScan + v_GS_WORKSTATION_STATUS -> MAX(EndTimeLocal) + MAX(LastScanDate) + MAX(LastHWScan)
ResourceID	v_GS_COMPUTER_SYSTEM -> ResourceID
Model	v_GS_COMPUTER_SYSTEM -> Model0
Name	v_GS_COMPUTER_SYSTEM -> Name0
UserName	v_GS_COMPUTER_SYSTEM -> UserName0
Manufacturer	v_GS_COMPUTER_SYSTEM -> Manufacturer0
DomainName	v_GS_COMPUTER_SYSTEM -> Domain0
NumberOfProcessors	v_GS_COMPUTER_SYSTEM -> NumberOfProcessors0
CurrentTimeZoneCode	v_GS_COMPUTER_SYSTEM -> CurrentTimeZone0
BiosManufacturer	v_GS_PC_BIOS -> Manufacturer0
BiosReleaseDate	v_GS_PC_BIOS -> ReleaseDate0
BiosSerialNumber	v_GS_PC_BIOS -> SerialNumber0
BiosVersion	v_GS_PC_BIOS -> SMBIOSBIOSVersion0
PrimaryBusType	v_GS_MOTHERBOARD_DEVICE -> PrimaryBusType0
SecondaryBusType	v_GS_MOTHERBOARD_DEVICE -> SecondaryBusType0
OperatingSystem	v_GS_OPERATING_SYSTEM -> Caption0
BuildNumber	v_GS_OPERATING_SYSTEM -> BuildNumber0
BuildType	v_GS_OPERATING_SYSTEM -> BuildType0
CodeSet	v_GS_OPERATING_SYSTEM -> CodeSet0
CountryCode	v_GS_OPERATING_SYSTEM -> CountryCode0
LocaleCode	v_GS_OPERATING_SYSTEM -> Locale0
Manufacturer	v_GS_OPERATING_SYSTEM -> Manufacturer0
Organization	v_GS_OPERATING_SYSTEM -> Organization0
RegisteredUser	v_GS_OPERATING_SYSTEM -> RegisteredUser0
SerialNumber	v_GS_OPERATING_SYSTEM -> SerialNumber0
SystemDirectory	v_GS_OPERATING_SYSTEM -> SystemDirectory0
SystemUILanguageCode	v_GS_OPERATING_SYSTEM -> OSLanguage0
VersionInfo	v_GS_OPERATING_SYSTEM -> CSDVersion0
WindowsDirectory	v_GS_OPERATING_SYSTEM -> WindowsDirectory0
OperatingSystemVersion	v_GS_OPERATING_SYSTEM -> Version0
FreePhysical	v_GS_OPERATING_SYSTEM -> FreePhysicalMemory0
TotalSwap	v_GS_OPERATING_SYSTEM -> TotalSwapSpaceSize0
InstallDate	v_GS_OPERATING_SYSTEM -> InstallDate0
ChassisType	v_GS_SYSTEM_ENCLOSURE -> ChassisTypes0
ResourceID	v_R_User -> ResourceID
FullUserName	v_R_User -> Full_User_Name0
UniqueUserName	v_R_User -> Unique_User_Name0

Service

Field in SnowXML	Field in SCCM
ResourceID	v_GS_SERVICE -> ResourceID
Name	v_GS_SERVICE -> Name0
PathName	v_GS_SERVICE -> PathName0
ServiceType	v_GS_SERVICE -> ServiceType0
State	v_GS_SERVICE -> State0
StartMode	v_GS_SERVICE -> StartMode0
AccountName	v_GS_SERVICE -> StartName0

Software 1

Field in SnowXML	Field in SCCM
ResourceID	v_GS_ADD_REMOVE_PROGRAMS -> ResourceID
Version	v_GS_ADD_REMOVE_PROGRAMS -> Version0
Manufacturer	v_GS_ADD_REMOVE_PROGRAMS -> Publisher0
Name	v_GS_ADD_REMOVE_PROGRAMS -> DisplayName0
InstallDate	v_GS_ADD_REMOVE_PROGRAMS -> InstallDate0

Software 2

Field in SnowXML	Field in SCCM
ResourceID	v_GS_SoftwareFile -> ResourceID
FileName	v_GS_SoftwareFile -> FileName
FilePath	v_GS_SoftwareFile -> FilePath
FileDateTime	v_GS_SoftwareFile -> FileModifiedDate
FileSize	v_GS_SoftwareFile -> FileSize
Version	v_GS_SoftwareFile -> FileVersion
Name	v_GS_SoftwareFile -> FileDescription
ProductId	v_GS_SoftwareFile -> ProductId
FileID	v_GS_SoftwareFile -> FileID
ResourceID	v_GS_SoftwareProduct -> ResourceID
Language	v_GS_SoftwareProduct -> ProductLanguage
Manufacturer	v_GS_SoftwareProduct -> CompanyName
ProductID	v_GS_SoftwareProduct -> ProductID
ProductVersion	v_GS_SoftwareProduct -> ProductVersion

Software 3

Field in SnowXML	Field in SCCM
ResourceID	vInventoriedLicensedProduct -> ResourceID
Version	vInventoriedLicensedProduct -> VersionCode
Name	vInventoriedLicensedProduct -> ProductName

Software 4

Field in SnowXML	Field in SCCM
Manufacturer	v_gs_installed_software -> Publisher0
InstallDate	v_gs_installed_software -> InstallDate0
UninstallString	v_gs_installed_software -> UninstallString0
ResourceID	v_gs_installed_software -> ResourceID
Version	v_gs_installed_software -> ProductVersion0
Name	v_gs_installed_software -> ProductName0

Software 5

Field in SnowXML	Field in SCCM
Name	v_GS_CUSTOM_SQL_Property_2_00 -> 'Microsoft SQL Server ' + PropertyStrValue0
Version	v_GS_CUSTOM_SQL_Property_2_00 -> PropertyStrValue0
ResourceID	v_GS_CUSTOM_SQL_Property_2_00 -> ResourceID

Software 6

Field in SnowXML	Field in SCCM
Name	v_GS_CUSTOM_SQL12_Property0 -> 'Microsoft SQL Server ' + PropertyStrValue0
Version	v_GS_CUSTOM_SQL12_Property0 -> PropertyStrValue0
ResourceID	v_GS_CUSTOM_SQL12_Property0 -> ResourceID

Software 7

Field in SnowXML	Field in SCCM
Name v_GS_CUSTOM_SQL15_Property0	'Microsoft SQL Server ' + PropertyStrValue0
Version v_GS_CUSTOM_SQL15_Property0	PropertyStrValue0
ResourceID v_GS_CUSTOM_SQL15_Property0	ResourceID

Software 8

Field in SnowXML	Field in SCCM
Name	v_GS_CUSTOM_SQL14_Property0 -> 'Microsoft SQL Server ' + PropertyStrValue0
Version	v_GS_CUSTOM_SQL14_Property0 -> PropertyStrValue0
ResourceID	v_GS_CUSTOM_SQL14_Property0 -> ResourceID

Software 9

Field in SnowXML	Field in SCCM
Name	v_GS_SOFTWARE_TAG -> productname0 + ' (' + uniqueid0 + ') ' + case when uniqueid0 like '%creativecloud%' then 'SUBSCRIPTION' else '' end
ResourceID	v_GS_SOFTWARE_TAG -> ResourceID
Version	v_GS_SOFTWARE_TAG -> DisplayVersion0
Manufacturer	v_GS_SOFTWARE_TAG -> SoftwareCreatorRegid0

Software 10

Field in SnowXML	Field in SCCM
ResourceID	v_GS_SOFTWARE_LICENSING_PRODUCT -> ResourceID
Name	v_GS_SOFTWARE_LICENSING_PRODUCT -> name0

Software 11

Field in SnowXML	Field in SCCM
ResourceID	v_GS_ADD_REMOVE_PROGRAMS_64 -> ResourceID
Version	v_GS_ADD_REMOVE_PROGRAMS_64 -> Version0
Manufacturer	v_GS_ADD_REMOVE_PROGRAMS_64 -> Publisher0
Name	v_GS_ADD_REMOVE_PROGRAMS_64 -> DisplayName0

Processor

Field in SnowXML	Field in SCCM
NumberOfCores	v_GS_PROCESSOR -> SUM(ResourceID = ResourceID)
NumberOfProcessors	v_GS_PROCESSOR -> COUNT(ResourceID = ResourceID)
ResourceID	v_GS_PROCESSOR -> ResourceID
CurrentClockSpeed	v_GS_PROCESSOR -> CurrentClockSpeed0
Manufacturer	v_GS_PROCESSOR -> Manufacturer0
MaxClockSpeed	v_GS_PROCESSOR -> MaxClockSpeed0
Name	v_GS_PROCESSOR -> Name0
ProcessorID	v_GS_PROCESSOR -> ProcessorId0
Model	v_GS_PROCESSOR -> Version0
Voltage	v_GS_PROCESSOR -> CurrentVoltage0

OperatingSystem

Field in SnowXML	Field in SCCM
ResourceID	v_GS_COMPUTER_SYSTEM -> ResourceID
Model	v_GS_COMPUTER_SYSTEM -> Model0
ComputerName	v_GS_COMPUTER_SYSTEM -> Name0
UserName	v_GS_COMPUTER_SYSTEM -> UserName0
DomainName	v_GS_COMPUTER_SYSTEM -> Domain0
NumberOfProcessors	v_GS_COMPUTER_SYSTEM -> NumberOfProcessors0
CurrentTimeZoneCode	v_GS_COMPUTER_SYSTEM -> CurrentTimeZone0
Name	v_GS_OPERATING_SYSTEM -> Caption0
BuildNumber	v_GS_OPERATING_SYSTEM -> BuildNumber0
BuildType	v_GS_OPERATING_SYSTEM -> BuildType0
CodeSet	v_GS_OPERATING_SYSTEM -> CodeSet0
CountryCode	v_GS_OPERATING_SYSTEM -> CountryCode0
LocaleCode	v_GS_OPERATING_SYSTEM -> Locale0
Manufacturer	v_GS_OPERATING_SYSTEM -> Manufacturer0
Organization	v_GS_OPERATING_SYSTEM -> Organization0
RegisteredUser	v_GS_OPERATING_SYSTEM -> RegisteredUser0
SerialNumber	v_GS_OPERATING_SYSTEM -> SerialNumber0
SystemDirectory	v_GS_OPERATING_SYSTEM -> SystemDirectory0
SystemUILanguageCode	v_GS_OPERATING_SYSTEM -> OSLanguage0
VersionInfo	v_GS_OPERATING_SYSTEM -> CSDVersion0
WindowsDirectory	v_GS_OPERATING_SYSTEM -> WindowsDirectory0
Version	v_GS_OPERATING_SYSTEM -> Version0
FreePhysical	v_GS_OPERATING_SYSTEM -> FreePhysicalMemory0
TotalSwap	v_GS_OPERATING_SYSTEM -> TotalSwapSpaceSize0
InstallDate	v_GS_OPERATING_SYSTEM -> InstallDate0

NetworkClient

Field in SnowXML	Field in SCCM
ResourceID	v_GS_NETWORK_CLIENT -> ResourceID
Name	v_GS_NETWORK_CLIENT -> Name0

NetworkAdapter

Field in SnowXML	Field in SCCM
ResourceID	v_GS_NETWORK_ADAPTER -> ResourceID
MacAddress	v_GS_NETWORK_ADAPTER -> MACAddress0
ProductName	v_GS_NETWORK_ADAPTER -> ProductName0
ResourceID	v_GS_NETWORK_ADAPTER_CONFIGURATION -> ResourceID
DefaultIPGateway	v_GS_NETWORK_ADAPTER_CONFIGURATION -> DefaultIPGateway0
DhcpEnabled	v_GS_NETWORK_ADAPTER_CONFIGURATION -> DHCPEnabled0
IPAddress	v_GS_NETWORK_ADAPTER_CONFIGURATION -> IPAddress0
IPSubnet	v_GS_NETWORK_ADAPTER_CONFIGURATION -> IPSubnet0
DhcpServer	v_GS_NETWORK_ADAPTER_CONFIGURATION -> DHCPServer0

Multimedia

Field in SnowXML	Field in SCCM
ResourceID	v_GS_SOUND_DEVICE -> ResourceID
SoundDeviceName	v_GS_SOUND_DEVICE -> Name0

Mouse

Field in SnowXML	Field in SCCM
ResourceID	v_GS_POINTING_DEVICE -> ResourceID
Name	v_GS_POINTING_DEVICE -> Name0

Monitor

Field in SnowXML	Field in SCCM
ResourceID	v_GS_DESKTOP_MONITOR -> ResourceID
Name	v_GS_DESKTOP_MONITOR -> Description0
MonitorWidth	v_GS_DESKTOP_MONITOR -> ScreenWidth0
MonitorHeight	v_GS_DESKTOP_MONITOR -> ScreenHeight0

Metering 1

Field in SnowXML	Field in SCCM
ResourceID	v_GS_SoftwareUsageData -> ResourceID
StartTime	v_GS_SoftwareUsageData -> StartTimeLocal
StopTime	v_GS_SoftwareUsageData -> EndTimeLocal
DomainAndUserName	v_GS_SoftwareUsageData -> UserName
ProductName	v_GS_SoftwareUsageData -> FileDescription
FullVersion	v_GS_SoftwareUsageData -> FileVersion
Manufacturer	v_GS_SoftwareUsageData -> CompanyName
LCID	v_GS_SoftwareUsageData -> ProductLanguage
ResourceID	v_GS_COMPUTER_SYSTEM -> ResourceID
DeviceID	v_GS_COMPUTER_SYSTEM -> Name0
ResourceID	v_GS_SoftwareFile -> ResourceID
FileName	v_GS_SoftwareFile -> FileName
FilePath	v_GS_SoftwareFile -> FilePath
FileID	v_GS_SoftwareFile -> FileID

Metering 2

Field in SnowXML	Field in SCCM
ResourceID	v_MonthlyUsageSummary -> ResourceID
TimeKey	v_MonthlyUsageSummary -> TimeKey
MeteredUserID	v_MonthlyUsageSummary -> MeteredUserID
FileID	v_MonthlyUsageSummary -> FileID
StopTime	v_MonthlyUsageSummary -> MAX(LastUsage)
UsageCount	v_MonthlyUsageSummary -> SUM(ISNULL(UsageCount, 0))
UsageMinutes	v_MonthlyUsageSummary -> SUM(ISNULL(CASE WHEN UsageTime IS NOT NULL THEN (UsageTime / 60 ) ELSE 0 END, 0))
FilePath	SoftwareFilePath -> MAX(FilePath)
FileName	SoftwareFile -> MAX([FileName])
DeviceID	v_GS_COMPUTER_SYSTEM -> Name0
DomainAndUsername	v_MeteredUser -> FullName
MeteredUserID	v_MeteredUser -> MeteredUserID
ProductName	SoftwareFile -> FileDescription
ProductId	SoftwareFile -> ProductId
FileID	SoftwareFile -> FileID
LCID	SoftwareProduct -> ProductLanguage
Manufacturer	SoftwareProduct -> CompanyName
ProductID	SoftwareProduct -> ProductID
FullVersion	SoftwareProduct -> ProductVersion
ProductId	SoftwareInventory -> ProductId
ClientId	SoftwareInventory -> ClientId

Memory

Field in SnowXML	Field in SCCM
ResourceID	v_GS_X86_PC_MEMORY -> ResourceID
TotalPhysical	v_GS_X86_PC_MEMORY -> TotalPhysicalMemory0
TotalVirtual	v_GS_X86_PC_MEMORY -> TotalVirtualMemory0
FreeVirtual	v_GS_X86_PC_MEMORY -> AvailableVirtualMemory0
FreePhysical	v_GS_OPERATING_SYSTEM -> FreePhysicalMemory0
TotalSwap	v_GS_OPERATING_SYSTEM -> TotalSwapSpaceSize0

LogicalDisk

Field in SnowXML	Field in SCCM
ResourceID	v_GS_LOGICAL_DISK -> ResourceID
Compressed	v_GS_LOGICAL_DISK -> Compressed0
FileSystem	v_GS_LOGICAL_DISK -> FileSystem0
FreeSpace	v_GS_LOGICAL_DISK -> FreeSpace0
Name	v_GS_LOGICAL_DISK -> Name0
DiskSize	v_GS_LOGICAL_DISK -> Size0
VolumeName	v_GS_LOGICAL_DISK -> VolumeName0
DriveType	v_GS_LOGICAL_DISK -> DriveType0
VolumeSerialNumber	v_GS_LOGICAL_DISK -> VolumeSerialNumber0

PhysicalDisk

Field in SnowXML	Field in SCCM
ResourceID	v_GS_DISK -> ResourceID
Interface	v_GS_DISK -> InterfaceType0
Type	v_GS_DISK -> MediaType0
Partitions	v_GS_DISK -> Partitions0
DeviceID	v_GS_DISK -> PNPDeviceID0
DiskSize	v_GS_DISK -> Size0
Cylinders	v_GS_DISK -> TotalCylinders0
Sectors	v_GS_DISK -> TotalSectors0
Tracks	v_GS_DISK -> TotalTracks0
Name	v_GS_DISK -> Caption0

DisplayAdapter

Field in SnowXML	Field in SCCM
ResourceID	v_GS_VIDEO_CONTROLLER -> ResourceID
CurrentBitsPerPixel	v_GS_VIDEO_CONTROLLER -> CurrentBitsPerPixel0
CurrentHorizontalResolution	v_GS_VIDEO_CONTROLLER -> CurrentHorizontalResolution0
CurrentVerticalResolution	v_GS_VIDEO_CONTROLLER -> CurrentVerticalResolution0
DisplayAdapterName	v_GS_VIDEO_CONTROLLER -> VideoProcessor0

Keyboard

Field in SnowXML	Field in SCCM
ResourceID	v_GS_KEYBOARD_DEVICE -> ResourceID
Name	v_GS_KEYBOARD_DEVICE -> Description0
Layout	v_GS_KEYBOARD_DEVICE -> Layout0

CDROM

Field in SnowXML	Field in SCCM
ResourceID	v_GS_CDROM -> ResourceID
DeviceID	v_GS_CDROM -> DeviceID0

LoginUserHistory

Field in SnowXML	Field in SCCM
ResourceID	v_GS_SYSTEM_CONSOLE_USER -> ResourceID
SystemConsoleUser	v_GS_SYSTEM_CONSOLE_USER -> SystemConsoleUser0
LastConsoleUse	v_GS_SYSTEM_CONSOLE_USER -> LastConsoleUse0
FullUserName	v_R_User -> Full_User_Name0

Printer

Field in SnowXML	Field in SCCM
ResourceID	v_GS_PRINTER_DEVICE -> ResourceID
Name	v_GS_PRINTER_DEVICE -> Name0
PortName	v_GS_PRINTER_DEVICE -> PortName0

Environment

Field in SnowXML	Field in SCCM
ResourceID	v_GS_ENVIRONMENT -> ResourceID
Name	v_GS_ENVIRONMENT -> Name0
VariableValue	v_GS_ENVIRONMENT -> VariableValue0

PhysicalMemory

Field in SnowXML	Field in SCCM
ResourceID	v_GS_PHYSICAL_MEMORY -> ResourceID
Capacity	v_GS_PHYSICAL_MEMORY -> Capacity0
MemoryType	v_GS_PHYSICAL_MEMORY -> MemoryType0

VirtualSoftware

Field in SnowXML	Field in SCCM
ResourceId	v_GS_APPV_CLIENT_PACKAGE -> ResourceId
Name	v_GS_APPV_CLIENT_PACKAGE -> Name0
Version	v_GS_APPV_CLIENT_PACKAGE -> Version0
GUID	v_GS_APPV_CLIENT_PACKAGE -> PackageId0

Retrieved MDM information

Client

Field in SnowXML	Field in SCCM
HostName	v_GS_DEVICE_INFO -> DeviceName0
ResourceID	v_GS_DEVICE_INFO -> ResourceID
BiosSerialNumber	v_GS_DEVICE_COMPUTERSYSTEM -> SerialNumber0
Manufacturer	v_GS_DEVICE_INFO -> Manufacturer0
Model	v_GS_DEVICE_INFO -> Model0
Username	v_R_User -> Unique_User_Name0
FullUserName	v_R_User -> Full_User_Name0
LastScanDate	v_GS_SoftwareUsageData + v_GS_LastSoftwareScan + v_GS_WORKSTATION_STATUS -> MAX(EndTimeLocal) + MAX(LastScanDate) + MAX(LastHWScan)

MobileDevice

Field in SnowXML	Field in SCCM
Imei	v_GS_DEVICE_COMPUTERSYSTEM ->IMEI0
Imsi	v_GS_DEVICE_COMPUTERSYSTEM -> IMSI0
PhoneNumber	v_GS_DEVICE_COMPUTERSYSTEM -> PhoneNumber0
Operator	v_GS_DEVICE_COMPUTERSYSTEM -> SubscriberCarrierNetwork0

OperatingSystem

Field in SnowXML	Field in SCCM
Version	v_GS_DEVICE_OSINFORMATION -> Version0
SystemUILanguageCode	v_GS_DEVICE_OSINFORMATION -> Language0
Name	v_GS_DEVICE_INFO -> OS0
Manufacture	v_GS_DEVICE_INFO -> Manufacturer0

PhysicalDisk

Field in SnowXML	Field in SCCM
DiskSize	v_GS_DEVICE_MEMORY -> StorageTotal0

Application

Field in SnowXML	Field in SCCM
Version	v_GS_DEVICE_INSTALLEDAPPLICATIONS -> sw.Version0
Name	v_GS_DEVICE_INSTALLEDAPPLICATIONS -> sw.Name0

Retrieved computer information​

USB​

Client​

Service​

Software 1​

Software 2​

Software 3​

Software 4​

Software 5​

Software 6​

Software 7​

Software 8​

Software 9​

Software 10​

Software 11​

Processor​

OperatingSystem​

NetworkClient​

NetworkAdapter​

Multimedia​

Mouse​

Monitor​

Metering 1​

Metering 2​

Memory​

LogicalDisk​

PhysicalDisk​

DisplayAdapter​

Keyboard​

CDROM​

LoginUserHistory​

Printer​

Environment​

PhysicalMemory​

VirtualSoftware​

Retrieved MDM information​

Client​

MobileDevice​

OperatingSystem​

PhysicalDisk​

Application​

Retrieved computer information

USB

Client

Service

Software 1

Software 2

Software 3

Software 4

Software 5

Software 6

Software 7

Software 8

Software 9

Software 10

Software 11

Processor

OperatingSystem

NetworkClient

NetworkAdapter

Multimedia

Mouse

Monitor

Metering 1

Metering 2

Memory

LogicalDisk

PhysicalDisk

DisplayAdapter

Keyboard

CDROM

LoginUserHistory

Printer

Environment

PhysicalMemory

VirtualSoftware

Retrieved MDM information

Client

MobileDevice

OperatingSystem

PhysicalDisk

Application