Using Easy Database Manager

Easy Database Manager allows you to search points that linked to px views, alarm extensions, analytics or template using various filtering options, search results will appear in unsecured points list, from unsecured points list identify and remove unused points.

NOTE

It is recommended that Easy Database Manager should be performed at the end of the engineering process i.e. when all the points from PX pages, link marking, analytics, alarm, history, Favorites in Point List view, and easy templates have been configured.

Remove unused Points

  1. Open Easy Database Manager. - see Launch Easy Database Manager sections.

  2.  In the Licensed Points field, enter the required number of points. This will help to identify the license status for the network.

    The Global Capacity Used update dynamically, indicating the number of points available.

    Example: In the image below you can see, the station has 500 global capacity points (displayed in License Point), out of which 13 points (displayed in Points in Use) are used by MbusNetwork and BACnetNetwork. The number of remaining points displayed in the Remaining section.

    If you enter License Points more than the available global capacity points, then the number of exceeding points displayed in the Remaining section in red color.

    Similarly, when you enter License Points more than the available individual license points, then the number of exceeding points displayed in the Remaining section in red color.

  3. Click Next>. The Easy Database Manager - (OPTIONAL) Find points in this station which need to be deleted for below criteria page is displayed. This optional search allows you to find unused points that are not used in the station.

    NOTE

    By default, no options are selected, therefore it will find points that exist in the station but are not used in any of the specified areas.

    Include points appearing on PX Views

    Include points that are on px pages in the unsecured points list.

    Include points with tag based graphics appearing on PX Views

    Include points that are linked to the other slots in the unsecured points list.

    Include points with Link Marking

    Include points that are linked to the other slots in the unsecured points list.

    Include points with Alarm Extensions

    Include points that are linked to custom alarm extension in the unsecured points list.

    Include points with History Extensions

    Include points that are linked to history extension in the unsecured points list.

    Include points with History Import

    Include points from history import in the unsecured points list.

    Include points associated to Favourites in Point List Views

    Include points that are associated with favorites in a Point List View in the unsecured points list.

    Include points with Analytics Configured

    Include points that are used by the analytics engine in the points list.

    Include points with Easy Template

    Include points that are used by Easy Templating in the unsecured points list.

  4. Select appropriate options and click Next>.

    Example:

    Or

    If you want to search points only on the label bases, click Skip to move to the next window.

    The Easy Database Manager - (OPTIONAL) Find points based on one or more labels matches page is displayed.

    This optional window allows you to find and add unused points and points used for schedule imports/exports, history imports, list marking and PX Views from the station.

    NOTE

    By default, the points option is selected.

    Points

    Includes all the points under selected network and in the unsecured points list

    Schedule Imports and Exports

    Includes points that are used by schedule import and export in the unsecured points list.

    History Imports

    With Analytics Configured

    Includes points that are used by history imports in the unsecured points list.

    Include analytics configured points that are used by history imports in the unsecured points list.

    Objects with Link Marking

    Include objects that are used by link marking in the unsecured points list.

    Objects within PX Views

    Include objects used by PX views in the unsecured points list.

    Points with Tag Based graphics within Px Views

    Include tag based graphics points within the PX views.

    Points with Analytics Configured

    Include points that used by under the analytics engine in the unsecured points list.

    If you want to add an additional search term, click New Search, and enter the new search string.

    If you want to load previously saved search terms, click Reuse Last Criteria, and select the required search criteria.

    If you want to delete a label, click ( ).

    NOTE

    The label matching is case sensitive, special characters like $, % and ' are not allowed.

  5. Select the required options and search criteria and click Next or click Skip to ignore this search.

    The Unwanted criteria dialogue box is displayed.

    NOTE

    You must select one of the points or histories or schedule imports and exports from any of (OPTIONAL) Find points in this station or (OPTIONAL) Find points based on one or more labels matches page. If you don't, an error will pop up.

  6. Select Yes to save the criteria, this allows to reuse the search criteria later or No to continue without saving them.

    NOTE

    Clicking Yes will overwrite the previous saved search criteria.

    The Easy Database Manager - Select Items to delete page displayed, displaying all items matching the search criteria listed in the unsecured points list.

    If any of the points from the network assigned as a secured point, then the secured points displayed in a Points With E-Signature and remaining non secured points displayed in the Points Without E-Signature.

    Steps to assign E-signature to datapoints:

    1. Open electronicSignature palette and drag-drop ElectronicSignature file under Config.

    2. Select ElectronicSignature >Views> select Ax property sheet.

    3. Under Customer > Zone > click Choose Points. This opens Point Selection window.

    4. Click (folder icon),navigate to under config, select the network, and click OK. All the points under network listed in the Unsecured Point List.

    5. Select the required points from the list that need to assign signature. For multiple points selection, press and hold the Ctrl key down while click the mouse.

    6. Click Add signal Signature. This opens ReasonSet Selection Dialog box, click OK. This assigns E-signature to all the points listed in Signal-Signature Point List.

    7. Click OK and save the property sheet.

  7.  Select the checkbox of the points that are to be removed from the station. To select all points, select the checkbox at the top of the column. To sort the columns, click on the column headers. To search for a specific point, enter the name of the specific point in the Search box.
  8. NOTE

    Multiple E-signature points removal not allowed in Easy Database Manager.

  9. Click Next>. The Easy Database Manager - Confirm item removal options window, is displayed displaying the number of points of each type of item that are to be removed from each network.

  10. Select the required options:

    Backup station before deleting items - Backup the station before deleting the specified items.

    Create logs for selected and deleted items - Creates a list of the items that are removed from the station- see View Logs.

    WARNING

    Ensure to run backup of the station before starting Point Database Manager. Deletions made by this tool cannot be undone.

  11.  Click Next> This Final confirmation dialogue box is displayed.

  12. Click Remove. All the selected points will be removed from the station’s database.

    If you are removing E-signature point, then you need to complete the Authentication process of the station before removing the E-secured point.

    Enter the UserName, Password, Comment, and click Sign. Click OK to complete the Authentication.

  13. When the process is complete the Easy Database Manager - Finish window is displayed, displaying status of the license across the networks, points in use and remaining points.

  14. If required, click Start New to start the process again.

Relative Links