groupscripts

124 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GScriptID INT 10 √ null
GroupID INT 10 null
ScriptID INT 10 null
ScriptType INT 10 null
RunTime DATETIME 19 null
Repeat INT 10 null
SearchID INT 10 null
Parameters VARCHAR 255 null
GroupScriptGuid VARCHAR 40 null
IncludeSubGroups INT 10 null
EffectiveStartDate DATETIME 19 √ null
ExcludeTimeStart TIME 8 √ null
ExcludeTimeEnd TIME 8 √ null
DistributionWindowType INT 10 null
DistributionWindowAmount INT 10 null
ScheduleType INT 10 null
Interval INT 10 null
ScheduleWeekofMonth INT 10 null
ScheduleDayofWeek INT 10 null
RepeatType INT 10 null
RepeatAmount INT 10 null
RepeatStopAfter INT 10 null
SkipOffline INT 10 null
OfflineOnly INT 10 null
WakeOffline INT 10 null
WakeScript INT 10 null
DisableTimeZone INT 10 null
RunScriptOnProbe INT 10 null
Priority INT 10 null
ticketpriority.Priority Implied ConstraintR
Last_User VARCHAR 30 null
Last_Date DATETIME 19 null
ScriptTarget INT 10 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc GScriptID
GroupID Performance Asc GroupID
ScriptID Performance Asc ScriptID
SearchID Performance Asc SearchID

Relationships

Close relationships within degrees of separation