V4.2 Fix Pack 1:

Checking schema updates

You can check which fixpack and interim fix schema updates have been applied to the NCIM topology database.

About this task

You can perform this check in one of the following ways:
  • By running the following select statement on the NCIM topology database:
    SELECT * FROM ncim.schemaAudit ORDER BY lastTraced;
  • By running the list_applied_updates.pl script. To do this, first source your environment, and then run the script using a command similar to the following:
    $NCHOME/precision/bin/ncp_perl $NCHOME/precision/scripts/sql/list_applied_updates.pl -domain DOMAIN_NAME
    Note: If you have more than one domain that shares the same login details, you only need to run the script for one of the domains. Running the script for the other domains that use those same login details will simply produce the same output.