Is it possible to store the realtime stats/logs generated by Managment console in to a table

opper20

Hi,
Can it be possible to store the log/stats generated by management console and store those to a table.If yes how can e pull those stats/logs from console?

LenoyJ

Any more info on what logs/stats you are trying to store to a table?
MC pulls all the data it needs to generate those charts from Vertica system tables in the first place. See: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/VerticaSystemTables.htm
You may find what you're looking for there.
 
You can also get a list of queries that MC uses by looking at the xml files here:
/opt/vconsole/reports

opper20

Thanks Lenoy

opper20

Hi, there is a feature extended monitoring in management console to stream data from source vertica and using kafka , we can load into target table.
However i have one issues.
1.i have 2 cluster (SRC1,SRC2) and using Kafka i stream and load into Target cluster, but the problem is both Source cluster data is getting loaded into same table of target cluster(dcschema).in that case how can i identify which data belong to which cluster.can we define 2 different schema for 2 src cluster.
Let me know if it is possible
thanks

SruthiA

It is possible. Please create 2 microbatches each for one source cluster. you can create two different schemas for two difference source clusters.

opper20

Hi Sruthi,
Thanks for the reply but can you please explain bit more, where exactly the schema needs to be defined as it takes automatically dcschema.