FortiSIEM db table info

[gauravpawar]

How can I access the database and examine various tables? I require this information for configuring osquery. I have installed FortiSIEM 7.1.3 with ClickHouse.  Detail steps along with creds (if any default) would be helpful.

[mnovelli · Accepted solution]

Hello @gauravpawar , to examine CMDB db tables just run following commands from Supervisor console:

psql -U phoenix phoenixdb

\dt

select * from <table name>

[gauravpawar]

@mnovelli thanks for the help 

[mnovelli]

you're welcome!  

[FSM_FTNT]

Hi, why did you need psql access for configuring OSquery?