Description

How to execute a query against Data Insight repository to get listing of classification pool members.

• On the Management Server, open a command window with elevated permissions (Run as administrator), and navigate to \Program Files\DataInsight\bin
• Run the following command to return a list of Nodes:

> configdb.exe -p -T node

The output will be similar to this:

C:\Program Files\DataInsight\bin>configdb.exe -p -T node
#|(L)ocal/(R)emote|ID|Name|IP|Queryd_port|Commd_port|isConsole|isIndexer|isCollector|Ctr|
|L|1|MS.VTAS.LOCAL|MS.VTAS.LOCAL|8282|8383|1|1|1|0|
|R|2|IDX.VTAS.LOCAL|IDX.VTAS.LOCAL|8282|8383|0|1|1|0|
|R|3|VIC.VTAS.LOCAL|VIC.VTAS.LOCAL|8282|8383|0|0|0|0|
|R|4|COL.VTAS.LOCAL|COL.VTAS.LOCAL|8282|8383|0|1|1|0|
|R|8|POR.VTAS.LOCAL|POR.VTAS.LOCAL|8282|8383|0|0|0|0|
|R|9|WINNAS.VTAS.LOCAL|WINNAS.VTAS.LOCAL|8282|8383|0|0|0|0|

• Run the following command to list the secondary nodes of the Classification Pool

> configdb.exe -p -T objattr | findstr "vic.master.id"

The output will be similar to this:

C:\Program Files\DataInsight\bin>configdb.exe -p -T objattr | findstr "vic.master.id"
node:9:vic.master.id=3
node:8:vic.master.id=3

We can see in this example that POR.VTAS.LOCAL & WINNAS.VTAS.LOCAL are seocndary nodes and VIC.VTAS.LOCAL is the primary node in a Classification Pool