Skip navigation

Official support for module(s)

score 40
You have not voted. Below Review Threshold

I find that the ENT_CONF_MODULE.GET_STR_VALUE is very helpful for finding the 'active configuration metric' at a given time.

 

As a contrived example, this is my real environment (minus real device names).   The pay off is that you can now make a summary chart that totals resources based on a point of time (i.e. first of every month this year). 

 

select *

from

(select sysid,

ent_conf_module.get_num_value('SYS', sysid, 'TOTAL_REAL_MEM', 'GLOBAL', 0, current_date) as memnow, current_date,

ent_conf_module.get_num_value('SYS', sysid, 'TOTAL_REAL_MEM', 'GLOBAL', 0, current_date-45) as mem2, current_date-45 as date2,

ent_conf_module.get_num_value('SYS', sysid, 'TOTAL_REAL_MEM', 'GLOBAL', 0, current_date-450) as mem3, current_date-450 as date3

from pv_system

where 1=1

--AND systypeid = 25

--AND sysid = 166776

) foo

where memnow <> mem2

;

 

 

sysidmemnowdatemem2date2mem3date3
11,56688,600,5202020-05-2888,600,5442020-04-1388,600,5202019-03-05
171,887549,741,936,6402020-05-28549,745,076,469.762020-04-13<null>2019-03-05
171,885549,741,936,6402020-05-28549,745,076,469.762020-04-13<null>2019-03-05
171,888549,741,936,6402020-05-28549,745,076,469.762020-04-13<null>2019-03-05
166,77621,466,888,273.922020-05-2817,178,191,462.42020-04-13<null>2019-03-05
166,8015,102,454,702.082020-05-285,106,565,1202020-04-13<null>2019-03-05
166,779102,870,338,764.82020-05-28103,162,891,468.82020-04-13<null>2019-03-05
166,8041,911,554,0482020-05-281,939,865,6002020-04-13<null>2019-03-05
11,5521,061,179,3902020-05-281,061,171,2002020-04-131,061,179,3902019-03-05
11,59988,600,4002020-05-2888,600,4402020-04-1388,600,4002019-03-05
11,59388,600,2322020-05-2888,600,2082020-04-1388,600,2322019-03-05
11,59588,600,4162020-05-2888,600,4082020-04-1388,600,4162019-03-05


As mentioned in this old post there are other modules that are useful that should be promoted to 'officially supported'  and therefore documented.

We wonder what other modules are available but not official

 

SERIES_MODULE.GET_IND_NUM_VALUE

threshold_module.get_by_entity

ENT_CONF_MODULE.GET_STR_VALUE

 

Is it safe to use SERIES_MODULE and ENT_CONF_MODULE in SQL queries?

Comments

Vote history