Hi, Im tring to retrieve some data from the Database, I need to get this events types:
PH_SYSTEM_EVENTS_PER_SEC
PH_SYSTEM_STORED_EVENTS_PER_SEC
PH_SYSTEM_SUMM_EVENTS_STORED_EPS
PH_SYSTEM_EVENTS_FWD_STAT
PH_SYSTEM_INTERNAL_EVENTS_PER_SEC
PH_SYSTEM_PERF_EVENTS_PER_SEC
PH_SYSTEM_IP_EVENTS_PER_SEC
PH_SYSTEM_DEVAPP_EVENTS_PER_SEC
PH_SYSTEM_EPS_GLOBAL
PH_SYSTEM_EPS_NODE
PH_SYSTEM_EPS_ORG
PH_PROF_ET_116_EPS
This types are listed in the "ph_event_type" table, but I need to get their histogram data like is shown in the GUI of fortisiem.
Nominating a forum post submits a request to create a new Knowledge Article based on the forum post topic. Please ensure your nomination includes a solution within the reply.
Hi @Melon_Molusk ,
The logs are stored not stored in cmdb, but in eventdb. Which is structured more like linux file system and not sql.
You can run historical search using same condition system event category = 3 and add required filters.
What is that you are looking for in backend that's not available in GUI > Analytics ?
Hi @premchanderr , Thanks for you answer, I want to integrate with another plataform, I already get all incidents from the ph_incident table from the database, but now I need those analitycs metrics.
this eventdb is located in the server? (I dont have access yet so I have to ask for them), this are just logs? there is an API to make requests?
Thanks!
Hi @Melon_Molusk ,
For API Integration of Events and Report:
Another method to forward syslog received in Fortisiem:
You can export event in backend to CSV:
If you face any issue in these methods I would suggest you to open ticket with Fortinet TAC and an engineer would be glad to assist you.
For any general query on these topics you are welcome to discuss here.
Select Forum Responses to become Knowledge Articles!
Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.
User | Count |
---|---|
1698 | |
1092 | |
752 | |
446 | |
228 |
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2024 Fortinet, Inc. All Rights Reserved.