License Key Scripts
Execute these scripts on your servers to be monitored and return the results to Confio. This exact data will be used to generate the permanent license keys for your installation. Choose the types of monitored servers below:
Oracle
select distinct 'ORACLE' DB_TYPE, i.host_name HOST, p.value TOTAL_CORES, v.*
from v$instance i, v$parameter p, v$version v
where lower(p.name) like '%cpu%count%'
and lower(v.banner) like '%oracle%';
SQL Server
Run the following query in SQL Server Management Studio:
select 'SQL SERVER' DB_TYPE,
@@servername VIRTUALNAME,
coalesce(SERVERPROPERTY('ComputerNamePhysicalNetBIOS'), SERVERPROPERTY('MachineName')) HOST,
COALESCE(SERVERPROPERTY('InstanceName'),'$DEFAULT') INSTANCE,
SERVERPROPERTY('isclustered') isclustered;
If you need to use SQLCMD, use the following format:
sqlcmd -S <SERVER\INSTANCE> -U <YOURUSERNAME> -P <YOURPASSWORD> -W -Q "select 'SQL SERVER' DB_TYPE, @@servername VIRTUALNAME, coalesce(SERVERPROPERTY('ComputerNamePhysicalNetBIOS'), SERVERPROPERTY('MachineName')) HOST, COALESCE(SERVERPROPERTY('InstanceName'),'$DEFAULT') INSTANCE, SERVERPROPERTY('isclustered') isclustered;"
DB2
select 'DB2' DB_TYPE, HOST_NAME HOST, total_cpus TOTAL_CORES from TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS SYSTEMINFO;
Sybase
select 'SYBASE' DB_TYPE, s.srvname HOST, v.maxval TOTAL_CORES
from sysservers s,
(select max(value) maxval from sysconfigures
where name='number of engines at startup' or name='max online engines') v
where s.srvid=0;
|