Automic Workload Automation

 View Only
Expand all | Collapse all

Make your own License Overview

  • 1.  Make your own License Overview

    Posted Mar 18, 2019 01:00 PM

    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;



  • 2.  Re: Make your own License Overview

    Posted Mar 19, 2019 04:35 AM

    Hi Carsten,

    Thank you for sharing.

    Regards,

    Thierry