FortiSIEM db table info

Forum|Forum|2 years ago
March 27, 2024
4 replies
1813 views

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.

Fortisiem

Best answer by mnovelli

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

psql -U phoenix phoenixdb

\dt

select * from <table name>

mnovelliAnswer

Staff

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

psql -U phoenix phoenixdb

\dt

select * from <table name>

gauravpawarAuthor

Explorer III

@mnovelli thanks for the help

mnovelli

Staff

you're welcome!

FSM_FTNT

Staff

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

Sign up

Login with SSO

Login to the community

Login with SSO