Home Menu

Page dedicated to query creation.

Create a new directory

• in the user's folder
• in the shared folder

It is not possible to create a folder in the Query templates panel.

This tool is a wizard for query scheduling.

Start by selecting an object in the panel Existing and shared requests .

You can select :

• a subdirectory of the local queries directory
• a subdirectory of the published queries directory
• any query from the published queries

Allows to get a command line or a url allowing the execution of the selected query.

The first screen allows you to choose :

• the type of output.
• runtime parameters
• the formatting of the decimals
• a username if you don't want to use the one defined by default in the menu Automatic execution of the AdminTool.

Depending on the type of restore, you may have additional control parameters.

The assistant then builds you

• the URL of the request
• two command lines:
  • one for historical windows scripts (cmd)
  • the other for the Powershell language.

You can copy/paste these strings, and possibly enrich them.

Refer to

• detailed schedule syntax.
• the url syntax

Allows to get a command line allowing automatic execution of all the requests present in the selected directory.

The first screen allows you to choose (optionally):

• an email of the recipient of the execution report
• a limit to the number of lines to be extracted
• a username if you do not want to use the one defined by default in the Automatic execution of the AdminTool.

The wizard then builds two command lines for you:

• one for historical windows scripts (cmd)
• the other for the Powershell language.

You can copy/paste these strings, and possibly enrich them. Refer to detailed syntax for more information.

Classic copy/cut/paste editing menu. Applies to objects selected in the Existing / Shared Queries panel

• Show / hide the Query templates panel or the status bar
• Update the list of requests