Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class
716 views

what is system table ?

Hello Team,

what is system table and what it contains ?

Thanks in advance.

Regards,

Naresh

Labels (1)
0 Likes
4 Replies
Absent Member.
Absent Member.

Export system tables – CORR-E - ESM service down

command :Getting a system dump, referred to as export system tables

Oracle: $ARCSIGHT_HOME/bin/arcsight export_system_tables /@ORACLE_SID Example: /opt/arcsight/db/bin/arcsight export_system_tables arcsight/arcsight@arcsight Output file is in $ARCSIGHT_HOME/arcsight.dmp

MySQL: ​/sbin/service arcsight_services stop manager Execute the following command from /opt/arcsight/manager/bin to export the tables: ./arcsight export_system_tables <mysql_username>  <mysql_dabatbase> Example: /arcsight export_system_tables arcsight arcsight arcsight Output file is: /opt/arcsight/manager/tmp/arcsight_dump_sy stem_tables.sql start the Manager: /sbin/service arcsight_services start manager

0 Likes
Commodore Commodore
Commodore

Are there anyone know this?

Please help me answer it!

Never give up
0 Likes
Absent Member.
Absent Member.

​, ​,

As ​ alluded to above in his response, System Tables are the collection of all User Custom Content, plus some System Specific Content tables -  basically almost everything stored in the mysql database EXCEPT the arcsight.user_sequences table and the arcsight.arc_event table.  The arc_event table is special because it represents the data stored via the Logger Data Chunks/proprietary storage engine plugin to mysql.  It would not be practical for many reasons to dump this into an SQL file.

Hopefully this helps clarify things a bit.

Thanks and Regards,

Michael Lumsden

ESM Product Manager

0 Likes
Fleet Admiral
Fleet Admiral

Hi Naresh,

System table is crucial sql file that contains all manager content (rules, filters, etc..) up to date that file has created. But it does not has db data and trend data. So its good practice for maintain system table at lease monthly.

Cheers

Gayan

Mr
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.