Search <book_title>...

APTARE IT Analytics Backup Manager Solution for ServiceNow Installation and Configuration Guide

Last Published: 2022-09-01

Product(s): APTARE IT Analytics (10.6)

Step-4: Enable ServiceNow incident creation

Compile user package for incidents:
- CD to /opt/aptare/database/tools/.
- Back up the user_package.sql file.
- Edit the user_package.sql file as follows:
  - Change
    IF summaryStatus = constant.JOB_STATUS_ERROR THEN
    To
    IF summaryStatus = constant.JOB_STATUS_ERROR THEN NULL;
  - Change:
    INSERT INTO apt_job_ticket ( job_id,
    To
    /* INSERT INTO apt_job_ticket ( job_id,
  - Change:
    (sysdate - to_date('01-JAN-1970','DD-MON-YYYY')) * (86400));
    To
    (sysdate - to_date('01-JAN-1970','DD-MON-YYYY')) * (86400));*/
- Compile the package using these commands at the sqlplus prompt.
```
su -aptare
sqlplus portal/portaluserpassword@scdb @/opt/aptare/database/
tools/user_package.sql
```
Set up the ServiceNow alert.
See ServiceNow: Job Finalized Alert Rule section in the APTARE IT Analytics User Guide for more information.