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 |