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;