Scripts


Definition

The wizard for starting scripts is used to run scripts using .vbs and .bat files, open a URL in a new page and run a stored procedure.

It can be called from certain forms (e.g. Quick Call, Incidents, Actions, Employees, Equipment, Service requests, Investment requests) by passing arguments via contextual variables.

EndDefinition

Notes

  • Scripts must be stored in a shared network folder so that all Service Desk technicians can have access to them.
    • The folder is defined using the {ADMIN} Script Directory other parameter.
    • It must comply with UNC.
  • As scripts are run outside Service Manager. No log files are generated.

Caution

  • You can only run .vbs and .bat files using Internet Explorer version 8 or earlier. This is because security on browsers such as Firefox, Chrome and Internet Explorer version 9 or later blocks the execution of these scripts.
  • Customers must develop the stored procedures they require.
  • Remote access via VNC requires a java virtual machine on the workstation where the script is run.

Menu access

Administration > Parameters > Scripts

Screen description

       Scripts launch wizard.png

Description: Script name.

Type: Used to indicate the type of processing performed by the script.

  • Script option: Used to run .bat or .vbs files.
  • URL option: Used to open the URL in a new window. The fields below will appear:
    • Window Width: Width of the window.
    • Window Height: Height of the window.
    • Use POST Request Method: Used to indicate if information is sent using the POST method (box is checked) or GET method (box is not checked).
  • Stored procedure option: Used to run a set of precompiled SQL instructions stored in the database. 

Contents: Script command line.

Examples of scripts

  • Script option: Run the ping.bat script by passing @@AM_ASSET.NETWORK_IDENTIFIER@@.
             Open url.png  See Administration tools.
ping.bat @@AM_ASSET.NETWORK_IDENTIFIER@@
  • URL option: Access the machine remotely via VNC  by passing @@AM_ASSET.NETWORK_IDENTIFIER@@.
http:>>@@AM_ASSET.NETWORK_IDENTIFIER@@:5800
  • Stored procedure option: Run the stored procedure My_procedure on user account 40000 by passing @@AM_ASSET.ASSET_TAG@@ and @@AM_ASSET.SERIAL_NUMBER@@.
Execute 40000.My_procedure @@AM_ASSET.ASSET_TAG@@, @@AM_ASSET.SERIAL_NUMBER@@

List of variables that can be passed as arguments

  • @@TABLE.FIELDNAME@@: Name of the table followed by the name of the field.
    The table can be:
    • AM_ASSET : Equipment table.
    • SD_REQUEST : Service request table. Note: Only if the script is run in an incident, request, action or quick call.

      example  @@AM_ASSET.NETWORK_IDENTIFIER@@: Equipment network identifier.

  • @@CONNECTED@@: Name of the logged-in user.
  • @@CONNECTED.LOGIN@@: Login of the logged-in user.
  • @@RECIPIENT@@: Name of the recipient of the incident, request or action.
  • @@RECIPIENT.LOGIN@@: Login of the recipient of the incident, request or action.
  • @@REQUESTOR@@: Name of the requesting person of the incident, request or action.
  • @@REQUESTOR.LOGIN@@: Login of the requesting person of the incident, request or action.
  • @@UID@@: Unique ID of SMS collections and publications generated when calling the script or URL.
  • @@COUNTER@@: Counter incremented with each script or URL called. Note: Starts with the value 1.

Procedure and Wizards

How to set up scripts

Step 1: Specify the script folder.

1. Select Administration > Parameters > Other Parameters in the menu.

2. Edit the {ADMIN} Script Directory parameter.

3. Specify the local folder or network folder in compliance with UNC.

example  172.16.4.1\scripts

 

Step 2: Configure scripts

1. Select Administration > Parameters > Scripts in the menu.

2. Click Add icon.png.

3. Enter the information of the script.

4. Click Finish.
 

Step 3: Add a command button on the form.

1. Open the form you want.

2. Click Browse grey points icon.png in the top banner and select Edit Form.

The form editor will open. The main form presentation will appear.

3. Add a command button.

4. Link it to the Execute script wizard and select the script you want.

5. Click Save.
 

Step 4: Check that the wizard is correctly configured.

1. Click Save and Close.

You will return to the form.

2. Check that the button works correctly to run the wizard.

Wizards

Configure

Tags:
Last modified by Unknown User on 2022/02/22 20:38
Created by Administrator XWiki on 2015/06/01 10:41

Shortcuts

Recent changes
•  EV Service Manager
•  Service Apps
•  EV Self Help
•  Service Bots

Powered by XWiki ©, EasyVista 2021