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:

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.