FortiSIEM Discussions
gauravpawar
New Contributor

FortiSIEM db table info

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.

1 Solution
mnovelli
Staff
Staff

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

psql -U phoenix phoenixdb

\dt

select * from <table name>

View solution in original post

4 REPLIES 4
mnovelli
Staff
Staff

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

psql -U phoenix phoenixdb

\dt

select * from <table name>

gauravpawar
New Contributor

@mnovelli thanks for the help 

mnovelli

you're welcome!  

FSM_FTNT
Staff
Staff

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

Announcements

Welcome to your new Fortinet Community!

You'll find your previous forum posts under "Forums"