1 of 1 people found this helpful
unfortunately, i don't think it will be that easy.
If I'm understanding properly, you are not looking for a breakdown by engine, so those fields wont help.
we'd need to get info from each of the elements tables that count towards licensing and the where clause would tie into the group table or column.
First, we need to know what elements are [not] counted towards licensing... (i.e. are "unmanaged" interfaces counted on license)?
The statusinfo table, I think, is commonly used amongst the elements' tables and if you look at that, #9 is unmanaged, but #28 is "not licensed".
I'm pretty sure unmanaged rows are counted based on some queries I ran and the number of elements on the polling engines page for nodes...
You'd have to have a custom property on tables: nodes, interfaces, volumes (for NPM licensing) that was set appropriately for every element at site B. then you'd do a count for each table like:
select count(*) from nodes where site='B'
select count(*) from interfaces where site='B'
select count(*) from volumes where site='B'
given that "site" is the custom property in each table and 'B' is the value assigned to "site B"
Someone correct me if I missed something or am wrong...
That is exactly what i need. Hopefully i can get it on here.
This question came up again today so i figured I might try asking again.
Any way i can report on elements/licenses used per site?
If site (Custom Property) is CA, how many elements are then tied to that site?
Custom table -> Custom SQL datasource
select city as site, count(city) as elements_per_site from nodes group by city
City is your custom property. Similar can be done with Volumes, interfaaces
Thanks. All I need now is to include the elements. Interfaces, Volumes, SAM Components, IP SLA Operations etc