To add data to the maintenance-window table in an auxiliary database

Purpose

Perform this procedure to add an NE or service as the target of Analytics reporting to monitor downtime, for example, during a network maintenance window. You add the NE or service information to the custom auxiliary database table named samdb.analytics_MaintenanceWindow_ct.

The following is an example of the table format:

Figure 14-6: Example of the samdb.analytics_MaintenanceWindow_ct table format
Example of the samdb.analytics_MaintenanceWindow_ct table format
Steps
 
1 

Log in as the root user on an NFM-P main server station.

2 

Open a console window.

3 

Enter the following:

# cd /opt/nsp/nms/bin ↵

4 

Use a plain-text editor to create the following file in the directory that holds the source maintenance-window data:

NodeAvailability_Table.csv

5 

The following define the table columns:

Note: The epoch time must be in milliseconds.

  • maintenanceType—node or service

  • affectedObjec—NE system or site ID, or service name

  • fullnameAffectedObjecteither—either:

    • NE FDN, in the format network:address

    • NFM-P service ID, in the format svc-mgr:service_ID

    An NFM-P NE properties form lists the NE system address..

    The NFM-P Manage Services form lists NFM-P service IDs.

  • startTime—maintenance window start; Unix epoch time, in milliseconds

  • endTime—maintenance window end; Unix epoch time, in milliseconds

  • description—optional object description; displayed as input option

For example:

maintenanceType,affectedObject,fullnameAffectedObject,startTime,endTime,description
node,203.0.113.169,network:203.0.113.169,1681104600000,1681111800000,Maintenance-1
node,203.0.113.182,network:203.0.113.182,1681129800000,1681138800000,Maintenance-2
service,N/A,svc-mgr:service-1,1681203600,1681210800,Maintenance-3
6 

Save and close the file.

7 

Enter the following to insert the data from the CSV file into the custom table:

# ./customData.bash --importData samdb.analytics_MaintenanceWindow_ct NodeAvailability_Table.csv ↵

You are prompted for the password of the samauxdb user.

8 

Enter the password.

The file data is imported to the samdb.analytics_MaintenanceWindow_ct table.

9 

Close the console window on the main server station.

10 

Log in as the root user on an auxiliary database station.

11 

Enter the following:

# cd /opt/vertica/bin ↵

12 

Enter the following:

# ./vsql -U samauxdb ↵

You are prompted for the password of the samauxdb user.

13 

Enter the password.

A database console session opens.

14 

Enter the following:

select * from samdb.analytics_MaintenanceWindow_ct; ↵

The table data is inserted, and the table content is displayed.

15 

Verify that the table content matches the information provided in the CSV file:

16 

When the verification is complete, enter the following:

exit ↵

The database console session closes.

17 

Close the console window on the auxiliary database station.

End of steps