Carsten_Schmitz

Make your own License Overview

Discussion created by Carsten_Schmitz on Mar 18, 2019
Latest reply on Mar 19, 2019 by ThierryTarrason

Instructions:

 

  • feed to SQL client of choice
  • add "where HOST_ACTIVE=1" to list/count only active agents (e.g. for making counts against license pools)
  • you can even automate this in Automic to log your agent count into reports every day (or hour. or minute. but not second).

 

Disclaimer:

 

  • take this only as inspiration/to save you some typing - you might have other odd entries in your HOST table I do not have (whew, we actually have half-baked entries from UC4 3.02B in there!). If you are unsure, start out with no "where" clauses and find your own filter criteria that work for you! I am not responsible if my choice of data source or choice of "where" clause filters generate any results that cause you to violate any licensing deals.

 

select

  HOST_SMDISPLAYNAME as "ServMgr Name",

  HOST_HOSTNAME as Hostname,

  HOST_HTYP_HW as Hardware,

  HOST_HTYP_SW as Software,

  HOST_HTYP_SWVERS as "Software Version",

  HOST_HOSTATTRTYPE as Platform,

  HOST_TCPIPADDR as IP,

  HOST_TCPIPPORT as Port,

  HOST_ACTIVE as ACTIVE,

  HOST_AUTHENTICATED as Authenticated,

  HOST_VERSION as Version,

  HOST_LICCATEGORY as "License Category"

  from HOST

  where HOST_VERSION is not NULL

  and HOST_HOSTATTRTYPE not in ('W', 'C')

  and HOST_LICCATEGORY is not NULL

  order by HOST_LICCATEGORY;

 

More practical or exciting queries:

 

 

select

  HOST_LICCATEGORY,

  count(HOST_LICCATEGORY)

  from HOST

  group by HOST_LICCATEGORY;


select

  HOST_HOSTATTRTYPE,

  count(HOST_HOSTATTRTYPE)

  from HOST

  group by HOST_HOSTATTRTYPE;

 

select

  HOST_VERSION,

  count(HOST_VERSION)

  from HOST

  where HOST_VERSION is not NULL

  group by HOST_VERSION;

Outcomes