vScriptStatus

vScriptStatus

procedure status for each client

Column Name

Type

Purpose

Machine_GroupID

varchar(201), null

A concatenated representation of the machine id and the group id it is associated with.

agentGuid

numeric(26,0), null

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

machName

varchar(100), null

Machine Name used for each agent

groupName

varchar(100), null

Organization, then machine group the machine is assigned to.

scriptName

varchar(260), null

Name of procedure

LastExecTime

datetime(3), null

Time stamp string representing the last time that the procedure was executed

lastExecStatus

varchar(1000), null

Status of the last execution. The string will be one of the following:

  • Procedure Summary: Success <ELSE or THEN>
  • Procedure Summary: Failed <ELSE or THEN> in # step

String replacements:

  • <ELSE or THEN> is replaced with the respective word ELSE or THEN.
  • # is replaced by the number of steps that failed in the procedure. (This is not useful unless the process is allowed to continue after a failure.)
  • step is replaced by the work steps if the procedure failed more than 1 step.

AdminLogin

varchar(100), null

Admin name that last scheduled this procedure. (Dont name this column adminName because that is a primary key used by database migration. adminName and emailAddr should not appear in the same table.