Querying Remote Databases

The Remote File Details and Remote Last Session window can be invoked in two ways:

1. Either from Admin Main Query menu bar, Query > Project > Remote File details… or by right mouse click in Admin Elements, grid control window.

2. Selecting the Remote File details option displays the window below.

   The main function of this window is to get the file details of one or more databases for the current or any other location.

   

3. Selecting the Remote Last Session option displays a similar window with results relevant to the last session:

   

   In both windows, the Location option lists all the online (not offline) locations. On selecting a location, all the databases of that location will be listed. If the Daemon of the selected location is not working, the Apply button is de-activated and the status of daemon will appear adjacent to the button. While the system establishes connection with the Daemon of the selected location, the status file informs the user. Select one or more databases from the list and click Apply. Now the resulting file detail or session detail of the selected database(s) is listed on the right of the window, along with the database name – see below.

   Results can be stored by entering a file name and clicking the Report option.

   

   The user can Sort By a specific column in the list such as Name or Type.

   The Filter gadget can be used to filter the list to show only databases with a Name that includes the input value. An asterisk (*) can be used as a wildcard. Values entered into the Filter gadget are case sensitive.

   If the daemon is not in contact for the selected location, the Apply button is de-activated and an error shown adjacent to it, as shown below. The Test Communication… button is an additional utility to check the Communication status of the daemon, so that the user can check it before selecting the Location. This shows the Test Project Communication window.