Exporting and importing queries

You can export and import any queries you create. All queries export as XML files. If you export the same query filename more than once, it will overwrite the existing file. To avoid this, you may want to copy the file to another location once it's exported.

The export and import features are useful in two scenarios:

• If you need to reinstall your database, use the export/import features to save your existing queries for use in a new database.
  
  For example, you could export the queries, then move them to a directory unaffected by a database reinstall. After reinstalling the database, you could move the queries back into the queries directory on your Web server, then import them into the new database.

• You can use the export/import features to copy queries to other databases.
  
  For example, you could export a query to a queries directory on your Web server, then e-mail or FTP it to someone. That person could then place the queries into the queries directory on another Web server, then import them into a different database. You could also map a drive and directly copy queries into the queries directory on another Web server.

To export a query

Complete these steps while connected to a database that has a query you want to export.

1. In the left navigation pane, click Reporting > Queries.
2. On the Custom queries page, click the query name you want to export. Click Edit.
3. On the Edit query page, click the Export toolbar button to export the query to disk.
4. On the Query exported page, right-click the query to download it as an XML file to a selected directory. The query becomes the XML file.

Note that if you export the same query filename more than once, it will overwrite the existing file. To avoid this, you may want to copy the file to another location once it's exported.

If you want to eventually import the query back into a database, you must move it to the queries directory recognized by the Web server, by default c:\inetpub\wwwroot\LANDesk\LDMS\queries.

To import a query

Complete these steps while connected to a database to which you want to import a query.

1. In the left navigation pane, click Reporting > Queries.
2. On the Custom queries page, click New.
3. On the Edit query page, click the Import toolbar button.
4. Select the query you want to import. If you want to verify the parameters of this query before importing it, click View.
5. Click Import to load the query in the Edit query page.
6. Once the query is loaded, scroll down and click Save query to save it into this database.