vScriptStatus

script status for each client

Column Name

Type

Purpose

Machine_GroupID

varchar

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

agentGuid

numeric

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

machName

varchar

Machine Name used for each agent

groupName

varchar

Group Name used for each agent

ScriptName

varchar

Name of script

LastExecTime

datetime

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

lastExecStatus

varchar

Status of the last execution. The string will be one of the following:Script Summary: Success <ELSE or THEN>Script Summary: Failed <ELSE or THEN> in # step<ELSE or THEN> is replaced with the respective word ELSE or THEN.# is replaced by the number of steps that failed in the script (not useful unless allowing the processing to continue after a failure)step is replaced by the work steps if the script failed more than 1 step.

AdminLogin

varchar

Admin name that last scheduled this script. (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.