Scripts Launch Wizard


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.

Notes

  • Scripts must be stored in a shared network folder so that all Service Desk technicians can have access to them. This folder is defined in Other Parameters ({ADMIN} Script Directory) and must comply with UNC, e.g. 172.16.4.1\scripts.
  • As scripts are run outside Product name - ev itsm.png, 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.

Screen description

        Scripts launch wizard.png

Menu access: Administration > Parameters > Scripts

Description: Script name.

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

  • Type = Script: Used to run .bat or .vbs files.
  • Type = URL: 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).
  • Type = Stored procedure: Used to run a set of precompiled SQL instructions stored in the database. 

Contents: Script command line.
         Example documentation icon FR.png

  • Type = Script:   ping.bat @@AM_ASSET.NETWORK_IDENTIFIER@@
              ==>  run the ping.bat script by passing @@AM_ASSET.NETWORK_IDENTIFIER@@
             Open url.png  See the description in Administration tools
  • Type = URL:   http:>>@@AM_ASSET.NETWORK_IDENTIFIER@@:5800

>  access the machine remotely via VNC  by passing @@AM_ASSET.NETWORK_IDENTIFIER@@

  • Type = Stored procedure :   Execute 40000.My_procedure @@AM_ASSET.ASSET_TAG@@, @@AM_ASSET.SERIAL_NUMBER@@
              ==>  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 : an equipment table.
    • SD_REQUEST : a service request table. Note: Only if the script is run in an incident, request, action or quick call.
      Example documentation icon FR.png  @@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: How to set up scripts

1. Define the path of the script folder.

  • Select Administration > Parameters > Other Parameters in the menu.
  • Edit Other Parameters {ADMIN} Script Directory and specify the local folder or network folder in compliance with UNC, e.g. 172.16.4.1\scripts.

2. Define and configure scripts.

  • Select Administration > Parameters > Scripts in the menu. 
  • Click Add icon.png.
  • Enter the elements of the script.
  • Click [ FINISH ].

3. Add a button to the form where you want to set up the wizard for running scripts.

  • Click Tools icon.png > Edit icon Edit to switch to edit mode for the form. 
  • Add a button and configure it. Link it to the Execute script wizard and select the script you want.
Tags:
Last modified by Unknown User on 2018/06/01 20:53
Created by Administrator XWiki on 2015/06/01 10:41

Shortcuts

Recent Updates

Haven't been here in a while? Here's what changed recently:

-   Product name - ev itsm.png
-   Product name - ev sas.png

Interesting Content

How to Automate Integration
Add a Shortcut to an App
History
Quick Dashboard
Full text search - Stop Words

Powered by XWiki ©, EasyVista 2018