Microsoft SQL Server core licensing (Internal Incubating)¶
Note
This query requires the LICENSE license option.
OctoSAM Incubating Internal Query
Incubating queries have beta status. They might be experimental. They are not yet fully tested and might change in the future. Once tested and 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 |
| Name | string | true | Machine name (computer name) |
| Virtual Machine | bool | true | True if this is a virtual machine |
| Host Os Family | string | true | |
| Number Of Cores | numeric | true | Number of cores as reported by WMI |
| Licenses | numeric | true | |
| Instance | string | true | |
| Instances | numeric | true | |
| 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 |