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;