Page History

...

• This script cleans all INVENTORY_* database tables in the Reporting database.
• It expects the database connection setting in ./config/reporting_hibernate.cfg.xml.
• This script has three arguments to identify a specific JobScheduler instance. These are
  
  • JobScheduler Id
  • Host
  • HTTP port
• With the single argument info a list of existing JobScheduler instances from the inventory will be displayed.
  • This call is helpful to see the exact values of Id, host and HTTP port.

• If this script is called without an argument then you get its usage:

  Code Block
  Usage: cleanup_inventory_tables.(cmd|sh) [JobSchedulerId JobSchedulerHost JobSchedulerHTTPPort] | [info] JobSchedulerId | The Id, hostname and http port of a JobSchedulerHost | JobScheduler which data should be JobSchedulerHTTPPort | removed in the INVENTORY tables of the | reporting database. or info | Shows a list of existing JobScheduler | instances in the INVENTORY tables

• Example for an info output:

  Code Block
  JobSchedulerId | Host | Port --------------------------------------------------------------------------- scheduler.1.11-reporting | OH | 40413 scheduler.1.11-x86 | OH | 40186 SP_41110x1 | SP | 40119 scheduler.1.11 | OH | 40411 scheduler.1.11-reporting | OH | 40423 scheduler.1.11.1 | OH | 40471

Clean up

...

Audit Log Table

...