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
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@@.
See Administration tools.
- URL option: Access the machine remotely via VNC by passing @@AM_ASSET.NETWORK_IDENTIFIER@@.
- Stored procedure option: Run the stored procedure My_procedure on user account 40000 by passing @@AM_ASSET.ASSET_TAG@@ and @@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 .
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 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.