DX PM query vertica DB

[ISAAC VELASCO]

Hello friends.

Some of you know how I can get data from an item within the vertical database.
Since through CA PC it is not possible since the item is as "filtered".

[Jeffrey Pinard]

You would need to login to /opt/vertica/bin/vsql -U dauser (or whatever you used during DA install).

You can query the table for item_id = <item id of the filtered item>.
Table would be like:
Interfaces:  ifstats_rate
CPUs:  nrm_cpustats_rate
Memory:  physical_memstats_rate
Availability:  avail_rate
Reachability:  reach_rate

The table prefix (before _rate) is defined in the metric family definition:   http://DA:8581/typecatalog/metricfamilies/<internal-name>
Eg. Interface is NormalizedPortInfo internal-name.  In the results is <TableName> field.