Skip to content

Microsoft SQL Server overview

Overview of installed SQL Server instances. For virtual machines, host (hypervisor) machine information is also provided, as some SQL Server licensing variants need to license the host cores for example.

Note

Check for OctoSAM catalog updates if you get 'Unknown' in the 'Product Version' column

Fields

Name Type Visible Description
Organization ID numeric false Internal ID that references the Organization entity (Foreign Key)
Organization string true Name of the organization this entity is mapped to
Machine ID numeric false Internal ID for the Machine entity (Primary Key)
Machine Guid guid false A unique ID that can be used to link to this machine object by external applications
Domain Name string false Windows NETBIOS Domain Name
Machine Name string false Machine name (computer name)
Machine string true Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines
Description string false Description attribute of the directory service or manually entered during offline scan
Directory Path string false Path where the machine was found in the directory service. Usually an LDAP path.
Site string true Name of the Active Directory Site that this machine belogs to
Wmi Instance ID numeric false OctoSAM internal ID of the WMI instance entity
Product Version string true SQL Server product version
Build string true SQL Server build number
Patch Level string false SQL Server patch level
Edition string true SQL Server edition
Edition Type string false Altertnative edition name, depending on detection method
Instance string true SQL Server name of the instance. Multiple instances per machine are possible.
Tcp Port string false Configured TCP port for this instance
Operating System string true Operating System installed on this machine as reported by OctoSAM scanners
Operating System Server bool true True if this OS is a server version
Operating System Version string false Additional version information about the OS
Operating System Build string false Build number of the OS
Operating System Update Build Revision numeric false Windows UBR number
Operating System Family string true A short identifier of the operating system family
Deleted In Directory bool false True, if directory check detects that the machine is no longer found in directory.
Raw Manufacturer string false Manufacturer of the machine as defined in WMI
Manufacturer ID numeric false Internal ID that references the Manufacturer entity (Foreign Key)
Manufacturer string false Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information
Model string true Model of the Machine as defined in WMI
Virtual Machine bool true True if this is a virtual machine
Processor string true Processor Name as reported by WMI
Number Of Processors numeric true Number of processors as reported by WMI
Number Of Cores numeric true Number of cores as reported by WMI
Number Of Logical Processors numeric true Number of logical processors as reported by WMI
Physical Memory Gi B numeric true Installed Memory in GiB (Gibibyte)
Custom Field1 string false Available for custom data for this machine, not used by OctoSAM Inventory.
Custom Field2 string false Available for custom data for this machine, not used by OctoSAM Inventory.
Custom Field3 string false Available for custom data for this Machine, not used by OctoSAM Inventory
Custom Field4 string false Available for custom data for this Machine, not used by OctoSAM Inventory
First Scan date false Date/Time this machine got scanned first
Last Scan date true Date/Time this machine got scanned last
Last Found In Directory date false Time the object was last found in the directory service
Directory Last Logon Timestamp date false LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days.
Virtual Machine ID numeric false OctoSAM internal ID of this Virtual Machine entity
VM string false Name of the virtual machine
VM Hypervisor string false Name of the hypervisor,
VM Virtual Cores numeric false Virtual cores or virtual processors that the hypervisor provides
VM Memory MB numeric false RAM that the hypervisor provides
VMVM Ware_Annotation_Backup_Status string true No tooltip defined for annotation 'Backup Status' - this tooltip is shown only for DEBUG builds
VMVM Ware_Annotation_hostname string true No tooltip defined for annotation 'hostname' - this tooltip is shown only for DEBUG builds
VMVM Ware_Annotation_Last_Backup string true No tooltip defined for annotation 'Last Backup' - this tooltip is shown only for DEBUG builds
Host ID numeric false OctoSAM internal ID of the host machine
Host Guid guid false A unique ID that can be used to link to this machine object by external applications
Host string true For virtual machines, the Hypervisor machine
Host Name string false For virtual machines, name of the Hypervisor machine
Host FQDN string false For virtual machines, FQDN of the Hypervisor machine
Host Operating System string false Full name of the OS
Host Operating System Server bool false True if this OS is a server version
Host Operating System Version string false Additional version information about the OS
Host Operating System Build string false Build number of the OS
Host Operating System Family string false A short name to identify different operating system families
Host Deleted In Directory bool false True, if directory check detects that the machine is no longer found in directory.
Host Raw Manufacturer string false Manufacturer string as scanned from the system. See field 'Host Manufacturer' for normalized manufacturer
Host Manufacturer ID numeric false OctoSAM internal ID of the host machine manufacturer
Host Manufacturer string false Normalized manufacturer information. See field 'Host Raw Manufacturer' for scanned details
Host Model string true For virtual machines, model of the Hypervisor machine
Host Processor string true For virtual machines, processor type of the Hypervisor machine
Host Number Of Processors numeric true For virtual machines, number of processors of the Hypervisor machine
Host Number Of Cores numeric true For virtual machines, number of cores of the Hypervisor machine
Host Number Of Logical Processors numeric true For virtual machines, number of logical processors of the Hypervisor machine
Host Physical Memory Gi B numeric false Physical Memory of the Host in GiB
Host Custom Field1 string false Available for custom data for this machine, not used by OctoSAM Inventory.
Host Custom Field2 string false Available for custom data for this machine, not used by OctoSAM Inventory.
Host Custom Field3 string false Available for custom data for this Machine, not used by OctoSAM Inventory
Host Custom Field4 string false Available for custom data for this Machine, not used by OctoSAM Inventory
Host Last Scan date true For virtual machines, last scan date/time of the Hypervisor machine
Virtualization Management System string false Name
VMS System string false Name of the Management System
VMS Version string false Version of the Management System
Current Date Time date false Date and time the query was run. For reference if you use and save query results.

Main entities referenced from this query

Query information

Property Value Description
Query Guid f03aabc0-d975-41ef-b13a-75b74ea02bab The internal id of the query. Must be unique
SupportsDesktop true If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb true If true, the query can be started from the OctoSAM Web UI