topic Can I extract data from solr database using command line? in General Topics

Can I extract data from solr database using command line?

Blason_R — Sat, 16 Dec 2023 05:50:29 GMT

Hello,

Since checkpoint uses solr database and the documents are indexed, wondering if those can be queried using solr binary? Which does not seems to appearing on OS.

Just like elasticsearch I was thinking if I could query and get the output from solr database for particular search query?

TIA

Blason R

Re: Can I extract data from solr database using command line?

Timothy_Hall — Sat, 16 Dec 2023 15:17:36 GMT

I'd imagine there would be some way to directly query the indexed log database, but I doubt it would be supported.

If you are trying to search logs from a CLI, be aware that version 1.6.1 of the management API added the "show logs" command which can be used to execute log searches through the API. I presume these searches would be run through the indexer just as they would be in the SmartConsole.

https://sc1.checkpoint.com/documents/latest/APIs/index.html#cli/show-logs~v1.6.1%20

Re: Can I extract data from solr database using command line?

Blason_R — Sun, 17 Dec 2023 04:51:02 GMT

Hmm - Thats nice point but I would really want checkpoint to provide solr binary to query the indices directly.