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
|