Microsoft SQL Server core licensing (Internal Incubating)¶
LICENSE license option required
This query requires the LICENSE license option.
OctoSAM incubating internal query
Incubating queries have beta status. They might be experimental. These queries are likely to change considerably with future builds of the OctoSAM software. Once matured, these queries may get moved to the regular query tree. Consult with Octosoft if and when to use this query.
SQL Server core licensing analysis.
Info
This query does not cover the special case when SQL Server is installed on a machine that hosts VMs that have also SQL Server instances installed. Also not covered are SQL cluster configurations or scenarios involving SQL Server Always On availability groups.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| 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 |
| Machine | string | true | Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| 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 |
| Manufacturer | string | false | Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information |
| Model | string | false | Model of the Machine as defined in WMI |
| Name | string | true | Machine name (computer name) |
| Virtual Machine | bool | true | True if this is a virtual machine |
| Host | string | false | For virtual machines: The host machine that runs the virtual machine. |
| Host Manufacturer | string | false | For virtual machines: The manufacturer of the host machine. |
| Host Model | string | false | For virtual machines: The model of the host machine. |
| Host Number Of Cores | numeric | false | For virtual machines: The number of cores of the host machine. |
| Host Os Family | string | true | For virtual machines: Operating system family of the host. |
| Number Of Cores | numeric | true | Number of cores as reported by WMI |
| Licenses | numeric | true | The number of SQL Server 2-core license packs required for the machine |
| Instance Names | string | true | A comma separated list of SQL Server instances installed on the machine |
| Instances | numeric | true | The number of SQL Server instances installed on the machine |
| Last Scan | date | true | Date/Time this entity got scanned last |
| 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 | 22ec8f6d-b0dc-4825-8b1a-cec5ec0b0194 | 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 |