Skip to main content

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 SnowXMLField in SCCM
ResourceIdv_GS_USB_CONTROLLER -> ResourceId
Namev_GS_USB_CONTROLLER -> Name0

Client

Field in SnowXMLField in SCCM
HasUsbv_GS_USB_CONTROLLER -> SIGN(COUNT(ResourceID))
HostMachinev_GS_VIRTUAL_MACHINE_64 and v_GS_VIRTUAL_MACHINE -> physicalhostname0
LastScanDatev_GS_SoftwareUsageData + v_GS_LastSoftwareScan + v_GS_WORKSTATION_STATUS -> MAX(EndTimeLocal) + MAX(LastScanDate) + MAX(LastHWScan)
ResourceIDv_GS_COMPUTER_SYSTEM -> ResourceID
Modelv_GS_COMPUTER_SYSTEM -> Model0
Namev_GS_COMPUTER_SYSTEM -> Name0
UserNamev_GS_COMPUTER_SYSTEM -> UserName0
Manufacturerv_GS_COMPUTER_SYSTEM -> Manufacturer0
DomainNamev_GS_COMPUTER_SYSTEM -> Domain0
NumberOfProcessorsv_GS_COMPUTER_SYSTEM -> NumberOfProcessors0
CurrentTimeZoneCodev_GS_COMPUTER_SYSTEM -> CurrentTimeZone0
BiosManufacturerv_GS_PC_BIOS -> Manufacturer0
BiosReleaseDatev_GS_PC_BIOS -> ReleaseDate0
BiosSerialNumberv_GS_PC_BIOS -> SerialNumber0
BiosVersionv_GS_PC_BIOS -> SMBIOSBIOSVersion0
PrimaryBusTypev_GS_MOTHERBOARD_DEVICE -> PrimaryBusType0
SecondaryBusTypev_GS_MOTHERBOARD_DEVICE -> SecondaryBusType0
OperatingSystemv_GS_OPERATING_SYSTEM -> Caption0
BuildNumberv_GS_OPERATING_SYSTEM -> BuildNumber0
BuildTypev_GS_OPERATING_SYSTEM -> BuildType0
CodeSetv_GS_OPERATING_SYSTEM -> CodeSet0
CountryCodev_GS_OPERATING_SYSTEM -> CountryCode0
LocaleCodev_GS_OPERATING_SYSTEM -> Locale0
Manufacturerv_GS_OPERATING_SYSTEM -> Manufacturer0
Organizationv_GS_OPERATING_SYSTEM -> Organization0
RegisteredUserv_GS_OPERATING_SYSTEM -> RegisteredUser0
SerialNumberv_GS_OPERATING_SYSTEM -> SerialNumber0
SystemDirectoryv_GS_OPERATING_SYSTEM -> SystemDirectory0
SystemUILanguageCodev_GS_OPERATING_SYSTEM -> OSLanguage0
VersionInfov_GS_OPERATING_SYSTEM -> CSDVersion0
WindowsDirectoryv_GS_OPERATING_SYSTEM -> WindowsDirectory0
OperatingSystemVersionv_GS_OPERATING_SYSTEM -> Version0
FreePhysicalv_GS_OPERATING_SYSTEM -> FreePhysicalMemory0
TotalSwapv_GS_OPERATING_SYSTEM -> TotalSwapSpaceSize0
InstallDatev_GS_OPERATING_SYSTEM -> InstallDate0
ChassisTypev_GS_SYSTEM_ENCLOSURE -> ChassisTypes0
ResourceIDv_R_User -> ResourceID
FullUserNamev_R_User -> Full_User_Name0
UniqueUserNamev_R_User -> Unique_User_Name0

Service

Field in SnowXMLField in SCCM
ResourceIDv_GS_SERVICE -> ResourceID
Namev_GS_SERVICE -> Name0
PathNamev_GS_SERVICE -> PathName0
ServiceTypev_GS_SERVICE -> ServiceType0
Statev_GS_SERVICE -> State0
StartModev_GS_SERVICE -> StartMode0
AccountNamev_GS_SERVICE -> StartName0

Software 1

Field in SnowXMLField in SCCM
ResourceIDv_GS_ADD_REMOVE_PROGRAMS -> ResourceID
Versionv_GS_ADD_REMOVE_PROGRAMS -> Version0
Manufacturerv_GS_ADD_REMOVE_PROGRAMS -> Publisher0
Namev_GS_ADD_REMOVE_PROGRAMS -> DisplayName0
InstallDatev_GS_ADD_REMOVE_PROGRAMS -> InstallDate0

Software 2

Field in SnowXMLField in SCCM
ResourceIDv_GS_SoftwareFile -> ResourceID
FileNamev_GS_SoftwareFile -> FileName
FilePathv_GS_SoftwareFile -> FilePath
FileDateTimev_GS_SoftwareFile -> FileModifiedDate
FileSizev_GS_SoftwareFile -> FileSize
Versionv_GS_SoftwareFile -> FileVersion
Namev_GS_SoftwareFile -> FileDescription
ProductIdv_GS_SoftwareFile -> ProductId
FileIDv_GS_SoftwareFile -> FileID
ResourceIDv_GS_SoftwareProduct -> ResourceID
Languagev_GS_SoftwareProduct -> ProductLanguage
Manufacturerv_GS_SoftwareProduct -> CompanyName
ProductIDv_GS_SoftwareProduct -> ProductID
ProductVersionv_GS_SoftwareProduct -> ProductVersion

Software 3

Field in SnowXMLField in SCCM
ResourceIDvInventoriedLicensedProduct -> ResourceID
VersionvInventoriedLicensedProduct -> VersionCode
NamevInventoriedLicensedProduct -> ProductName

Software 4

Field in SnowXMLField in SCCM
Manufacturerv_gs_installed_software -> Publisher0
InstallDatev_gs_installed_software -> InstallDate0
UninstallStringv_gs_installed_software -> UninstallString0
ResourceIDv_gs_installed_software -> ResourceID
Versionv_gs_installed_software -> ProductVersion0
Namev_gs_installed_software -> ProductName0

Software 5

Field in SnowXMLField in SCCM
Namev_GS_CUSTOM_SQL_Property_2_00 -> 'Microsoft SQL Server ' + PropertyStrValue0
Versionv_GS_CUSTOM_SQL_Property_2_00 -> PropertyStrValue0
ResourceIDv_GS_CUSTOM_SQL_Property_2_00 -> ResourceID

Software 6

Field in SnowXMLField in SCCM
Namev_GS_CUSTOM_SQL12_Property0 -> 'Microsoft SQL Server ' + PropertyStrValue0
Versionv_GS_CUSTOM_SQL12_Property0 -> PropertyStrValue0
ResourceIDv_GS_CUSTOM_SQL12_Property0 -> ResourceID

Software 7

Field in SnowXMLField in SCCM
Name v_GS_CUSTOM_SQL15_Property0'Microsoft SQL Server ' + PropertyStrValue0
Version v_GS_CUSTOM_SQL15_Property0PropertyStrValue0
ResourceID v_GS_CUSTOM_SQL15_Property0ResourceID

Software 8

Field in SnowXMLField in SCCM
Namev_GS_CUSTOM_SQL14_Property0 -> 'Microsoft SQL Server ' + PropertyStrValue0
Versionv_GS_CUSTOM_SQL14_Property0 -> PropertyStrValue0
ResourceIDv_GS_CUSTOM_SQL14_Property0 -> ResourceID

Software 9

Field in SnowXMLField in SCCM
Namev_GS_SOFTWARE_TAG -> productname0 + ' (' + uniqueid0 + ') ' + case when uniqueid0 like '%creativecloud%' then 'SUBSCRIPTION' else '' end
ResourceIDv_GS_SOFTWARE_TAG -> ResourceID
Versionv_GS_SOFTWARE_TAG -> DisplayVersion0
Manufacturerv_GS_SOFTWARE_TAG -> SoftwareCreatorRegid0

Software 10

Field in SnowXMLField in SCCM
ResourceIDv_GS_SOFTWARE_LICENSING_PRODUCT -> ResourceID
Namev_GS_SOFTWARE_LICENSING_PRODUCT -> name0

Software 11

Field in SnowXMLField in SCCM
ResourceIDv_GS_ADD_REMOVE_PROGRAMS_64 -> ResourceID
Versionv_GS_ADD_REMOVE_PROGRAMS_64 -> Version0
Manufacturerv_GS_ADD_REMOVE_PROGRAMS_64 -> Publisher0
Namev_GS_ADD_REMOVE_PROGRAMS_64 -> DisplayName0

Processor

Field in SnowXMLField in SCCM
NumberOfCoresv_GS_PROCESSOR -> SUM(ResourceID = ResourceID)
NumberOfProcessorsv_GS_PROCESSOR -> COUNT(ResourceID = ResourceID)
ResourceIDv_GS_PROCESSOR -> ResourceID
CurrentClockSpeedv_GS_PROCESSOR -> CurrentClockSpeed0
Manufacturerv_GS_PROCESSOR -> Manufacturer0
MaxClockSpeedv_GS_PROCESSOR -> MaxClockSpeed0
Namev_GS_PROCESSOR -> Name0
ProcessorIDv_GS_PROCESSOR -> ProcessorId0
Modelv_GS_PROCESSOR -> Version0
Voltagev_GS_PROCESSOR -> CurrentVoltage0

OperatingSystem

Field in SnowXMLField in SCCM
ResourceIDv_GS_COMPUTER_SYSTEM -> ResourceID
Modelv_GS_COMPUTER_SYSTEM -> Model0
ComputerNamev_GS_COMPUTER_SYSTEM -> Name0
UserNamev_GS_COMPUTER_SYSTEM -> UserName0
DomainNamev_GS_COMPUTER_SYSTEM -> Domain0
NumberOfProcessorsv_GS_COMPUTER_SYSTEM -> NumberOfProcessors0
CurrentTimeZoneCodev_GS_COMPUTER_SYSTEM -> CurrentTimeZone0
Namev_GS_OPERATING_SYSTEM -> Caption0
BuildNumberv_GS_OPERATING_SYSTEM -> BuildNumber0
BuildTypev_GS_OPERATING_SYSTEM -> BuildType0
CodeSetv_GS_OPERATING_SYSTEM -> CodeSet0
CountryCodev_GS_OPERATING_SYSTEM -> CountryCode0
LocaleCodev_GS_OPERATING_SYSTEM -> Locale0
Manufacturerv_GS_OPERATING_SYSTEM -> Manufacturer0
Organizationv_GS_OPERATING_SYSTEM -> Organization0
RegisteredUserv_GS_OPERATING_SYSTEM -> RegisteredUser0
SerialNumberv_GS_OPERATING_SYSTEM -> SerialNumber0
SystemDirectoryv_GS_OPERATING_SYSTEM -> SystemDirectory0
SystemUILanguageCodev_GS_OPERATING_SYSTEM -> OSLanguage0
VersionInfov_GS_OPERATING_SYSTEM -> CSDVersion0
WindowsDirectoryv_GS_OPERATING_SYSTEM -> WindowsDirectory0
Versionv_GS_OPERATING_SYSTEM -> Version0
FreePhysicalv_GS_OPERATING_SYSTEM -> FreePhysicalMemory0
TotalSwapv_GS_OPERATING_SYSTEM -> TotalSwapSpaceSize0
InstallDatev_GS_OPERATING_SYSTEM -> InstallDate0

NetworkClient

Field in SnowXMLField in SCCM
ResourceIDv_GS_NETWORK_CLIENT -> ResourceID
Namev_GS_NETWORK_CLIENT -> Name0

NetworkAdapter

Field in SnowXMLField in SCCM
ResourceIDv_GS_NETWORK_ADAPTER -> ResourceID
MacAddressv_GS_NETWORK_ADAPTER -> MACAddress0
ProductNamev_GS_NETWORK_ADAPTER -> ProductName0
ResourceIDv_GS_NETWORK_ADAPTER_CONFIGURATION -> ResourceID
DefaultIPGatewayv_GS_NETWORK_ADAPTER_CONFIGURATION -> DefaultIPGateway0
DhcpEnabledv_GS_NETWORK_ADAPTER_CONFIGURATION -> DHCPEnabled0
IPAddressv_GS_NETWORK_ADAPTER_CONFIGURATION -> IPAddress0
IPSubnetv_GS_NETWORK_ADAPTER_CONFIGURATION -> IPSubnet0
DhcpServerv_GS_NETWORK_ADAPTER_CONFIGURATION -> DHCPServer0

Multimedia

Field in SnowXMLField in SCCM
ResourceIDv_GS_SOUND_DEVICE -> ResourceID
SoundDeviceNamev_GS_SOUND_DEVICE -> Name0

Mouse

Field in SnowXMLField in SCCM
ResourceIDv_GS_POINTING_DEVICE -> ResourceID
Namev_GS_POINTING_DEVICE -> Name0

Monitor

Field in SnowXMLField in SCCM
ResourceIDv_GS_DESKTOP_MONITOR -> ResourceID
Namev_GS_DESKTOP_MONITOR -> Description0
MonitorWidthv_GS_DESKTOP_MONITOR -> ScreenWidth0
MonitorHeightv_GS_DESKTOP_MONITOR -> ScreenHeight0

Metering 1

Field in SnowXMLField in SCCM
ResourceIDv_GS_SoftwareUsageData -> ResourceID
StartTimev_GS_SoftwareUsageData -> StartTimeLocal
StopTimev_GS_SoftwareUsageData -> EndTimeLocal
DomainAndUserNamev_GS_SoftwareUsageData -> UserName
ProductNamev_GS_SoftwareUsageData -> FileDescription
FullVersionv_GS_SoftwareUsageData -> FileVersion
Manufacturerv_GS_SoftwareUsageData -> CompanyName
LCIDv_GS_SoftwareUsageData -> ProductLanguage
ResourceIDv_GS_COMPUTER_SYSTEM -> ResourceID
DeviceIDv_GS_COMPUTER_SYSTEM -> Name0
ResourceIDv_GS_SoftwareFile -> ResourceID
FileNamev_GS_SoftwareFile -> FileName
FilePathv_GS_SoftwareFile -> FilePath
FileIDv_GS_SoftwareFile -> FileID

Metering 2

Field in SnowXMLField in SCCM
ResourceIDv_MonthlyUsageSummary -> ResourceID
TimeKeyv_MonthlyUsageSummary -> TimeKey
MeteredUserIDv_MonthlyUsageSummary -> MeteredUserID
FileIDv_MonthlyUsageSummary -> FileID
StopTimev_MonthlyUsageSummary -> MAX(LastUsage)
UsageCountv_MonthlyUsageSummary -> SUM(ISNULL(UsageCount, 0))
UsageMinutesv_MonthlyUsageSummary -> SUM(ISNULL(CASE WHEN UsageTime IS NOT NULL THEN (UsageTime / 60 ) ELSE 0 END, 0))
FilePathSoftwareFilePath -> MAX(FilePath)
FileNameSoftwareFile -> MAX([FileName])
DeviceIDv_GS_COMPUTER_SYSTEM -> Name0
DomainAndUsernamev_MeteredUser -> FullName
MeteredUserIDv_MeteredUser -> MeteredUserID
ProductNameSoftwareFile -> FileDescription
ProductIdSoftwareFile -> ProductId
FileIDSoftwareFile -> FileID
LCIDSoftwareProduct -> ProductLanguage
ManufacturerSoftwareProduct -> CompanyName
ProductIDSoftwareProduct -> ProductID
FullVersionSoftwareProduct -> ProductVersion
ProductIdSoftwareInventory -> ProductId
ClientIdSoftwareInventory -> ClientId

Memory

Field in SnowXMLField in SCCM
ResourceIDv_GS_X86_PC_MEMORY -> ResourceID
TotalPhysicalv_GS_X86_PC_MEMORY -> TotalPhysicalMemory0
TotalVirtualv_GS_X86_PC_MEMORY -> TotalVirtualMemory0
FreeVirtualv_GS_X86_PC_MEMORY -> AvailableVirtualMemory0
FreePhysicalv_GS_OPERATING_SYSTEM -> FreePhysicalMemory0
TotalSwapv_GS_OPERATING_SYSTEM -> TotalSwapSpaceSize0

LogicalDisk

Field in SnowXMLField in SCCM
ResourceIDv_GS_LOGICAL_DISK -> ResourceID
Compressedv_GS_LOGICAL_DISK -> Compressed0
FileSystemv_GS_LOGICAL_DISK -> FileSystem0
FreeSpacev_GS_LOGICAL_DISK -> FreeSpace0
Namev_GS_LOGICAL_DISK -> Name0
DiskSizev_GS_LOGICAL_DISK -> Size0
VolumeNamev_GS_LOGICAL_DISK -> VolumeName0
DriveTypev_GS_LOGICAL_DISK -> DriveType0
VolumeSerialNumberv_GS_LOGICAL_DISK -> VolumeSerialNumber0

PhysicalDisk

Field in SnowXMLField in SCCM
ResourceIDv_GS_DISK -> ResourceID
Interfacev_GS_DISK -> InterfaceType0
Typev_GS_DISK -> MediaType0
Partitionsv_GS_DISK -> Partitions0
DeviceIDv_GS_DISK -> PNPDeviceID0
DiskSizev_GS_DISK -> Size0
Cylindersv_GS_DISK -> TotalCylinders0
Sectorsv_GS_DISK -> TotalSectors0
Tracksv_GS_DISK -> TotalTracks0
Namev_GS_DISK -> Caption0

DisplayAdapter

Field in SnowXMLField in SCCM
ResourceIDv_GS_VIDEO_CONTROLLER -> ResourceID
CurrentBitsPerPixelv_GS_VIDEO_CONTROLLER -> CurrentBitsPerPixel0
CurrentHorizontalResolutionv_GS_VIDEO_CONTROLLER -> CurrentHorizontalResolution0
CurrentVerticalResolutionv_GS_VIDEO_CONTROLLER -> CurrentVerticalResolution0
DisplayAdapterNamev_GS_VIDEO_CONTROLLER -> VideoProcessor0

Keyboard

Field in SnowXMLField in SCCM
ResourceIDv_GS_KEYBOARD_DEVICE -> ResourceID
Namev_GS_KEYBOARD_DEVICE -> Description0
Layoutv_GS_KEYBOARD_DEVICE -> Layout0

CDROM

Field in SnowXMLField in SCCM
ResourceIDv_GS_CDROM -> ResourceID
DeviceIDv_GS_CDROM -> DeviceID0

LoginUserHistory

Field in SnowXMLField in SCCM
ResourceIDv_GS_SYSTEM_CONSOLE_USER -> ResourceID
SystemConsoleUserv_GS_SYSTEM_CONSOLE_USER -> SystemConsoleUser0
LastConsoleUsev_GS_SYSTEM_CONSOLE_USER -> LastConsoleUse0
FullUserNamev_R_User -> Full_User_Name0

Printer

Field in SnowXMLField in SCCM
ResourceIDv_GS_PRINTER_DEVICE -> ResourceID
Namev_GS_PRINTER_DEVICE -> Name0
PortNamev_GS_PRINTER_DEVICE -> PortName0

Environment

Field in SnowXMLField in SCCM
ResourceIDv_GS_ENVIRONMENT -> ResourceID
Namev_GS_ENVIRONMENT -> Name0
VariableValuev_GS_ENVIRONMENT -> VariableValue0

PhysicalMemory

Field in SnowXMLField in SCCM
ResourceIDv_GS_PHYSICAL_MEMORY -> ResourceID
Capacityv_GS_PHYSICAL_MEMORY -> Capacity0
MemoryTypev_GS_PHYSICAL_MEMORY -> MemoryType0

VirtualSoftware

Field in SnowXMLField in SCCM
ResourceIdv_GS_APPV_CLIENT_PACKAGE -> ResourceId
Namev_GS_APPV_CLIENT_PACKAGE -> Name0
Versionv_GS_APPV_CLIENT_PACKAGE -> Version0
GUIDv_GS_APPV_CLIENT_PACKAGE -> PackageId0

Retrieved MDM information

Client

Field in SnowXMLField in SCCM
HostNamev_GS_DEVICE_INFO -> DeviceName0
ResourceIDv_GS_DEVICE_INFO -> ResourceID
BiosSerialNumberv_GS_DEVICE_COMPUTERSYSTEM -> SerialNumber0
Manufacturerv_GS_DEVICE_INFO -> Manufacturer0
Modelv_GS_DEVICE_INFO -> Model0
Usernamev_R_User -> Unique_User_Name0
FullUserNamev_R_User -> Full_User_Name0
LastScanDatev_GS_SoftwareUsageData + v_GS_LastSoftwareScan +
v_GS_WORKSTATION_STATUS -> MAX(EndTimeLocal) +
MAX(LastScanDate) + MAX(LastHWScan)

MobileDevice

Field in SnowXMLField in SCCM
Imeiv_GS_DEVICE_COMPUTERSYSTEM ->IMEI0
Imsiv_GS_DEVICE_COMPUTERSYSTEM -> IMSI0
PhoneNumberv_GS_DEVICE_COMPUTERSYSTEM -> PhoneNumber0
Operatorv_GS_DEVICE_COMPUTERSYSTEM -> SubscriberCarrierNetwork0

OperatingSystem

Field in SnowXMLField in SCCM
Versionv_GS_DEVICE_OSINFORMATION -> Version0
SystemUILanguageCodev_GS_DEVICE_OSINFORMATION -> Language0
Namev_GS_DEVICE_INFO -> OS0
Manufacturev_GS_DEVICE_INFO -> Manufacturer0

PhysicalDisk

Field in SnowXMLField in SCCM
DiskSizev_GS_DEVICE_MEMORY -> StorageTotal0

Application

Field in SnowXMLField in SCCM
Versionv_GS_DEVICE_INSTALLEDAPPLICATIONS -> sw.Version0
Namev_GS_DEVICE_INSTALLEDAPPLICATIONS -> sw.Name0