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.  Note that for SQL Server monitoring only, choice of script depends on whether you have installed Ignite 6 or Ignite PI.  Choose the types of monitored servers below: 

Oracle - all Ignite versions

select host_name from v$instance;
select name||'='||value from v$parameter where lower(name) like '%cpu%count%';

 

SQL Server - Ignite PI

select coalesce(SERVERPROPERTY('ComputerNamePhysicalNetBIOS'), SERVERPROPERTY('MachineName')) HOST
select COALESCE(SERVERPROPERTY('InstanceName'),'$DEFAULT') INSTANCE
exec master..xp_msver ProcessorCount

SQL Server - Ignite 6

select serverproperty('MACHINENAME')
exec master..xp_msver ProcessorCount

 

DB2 - all Ignite versions

select HOST_NAME from TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS SYSTEMINFO
select total_cpus from TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS SYSTEMINFO

 

Sybase - all Ignite versions

select srvname from sysservers where srvid=0
select max(value) from sysconfigures where name='number of engines at startup' or name='max online engines'

 

Java/J2EE - Contact Confio support