Name: TaskSchedulerRunHistory

Display Field: task_name

Type: Table

Description: Task Scheduler run history derived from the Microsoft-Windows-TaskScheduler/Operational log.

Copyright Text:

Max Record Count: 5000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• server_name (type: esriFieldTypeString, alias: Server Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• audit_batch_id (type: esriFieldTypeString, alias: Audit Batch ID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ingested_at_utc (type: esriFieldTypeDate, alias: Ingested At (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• task_name (type: esriFieldTypeString, alias: Task Name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• task_path (type: esriFieldTypeString, alias: Task Path, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• task_full_name (type: esriFieldTypeString, alias: Task Full Name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• run_key (type: esriFieldTypeString, alias: Run Key, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• instance_id (type: esriFieldTypeString, alias: Instance ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• run_status (type: esriFieldTypeString, alias: Run Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• user_context (type: esriFieldTypeString, alias: User Context, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• action_names (type: esriFieldTypeString, alias: Action Names, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• command_target_name (type: esriFieldTypeString, alias: Command Target Name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• command_target_type (type: esriFieldTypeString, alias: Command Target Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• computer_name (type: esriFieldTypeString, alias: Computer Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• start_time_utc (type: esriFieldTypeDate, alias: Start Time (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• end_time_utc (type: esriFieldTypeDate, alias: End Time (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• duration_seconds (type: esriFieldTypeDouble, alias: Duration Seconds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• duration_minutes (type: esriFieldTypeDouble, alias: Duration Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• result_code (type: esriFieldTypeDouble, alias: Result Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• result_text (type: esriFieldTypeString, alias: Result Text, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• start_record_id (type: esriFieldTypeDouble, alias: Start Record ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• end_record_id (type: esriFieldTypeDouble, alias: End Record ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• action_start_record_id (type: esriFieldTypeDouble, alias: Action Start Record ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• action_end_record_id (type: esriFieldTypeDouble, alias: Action End Record ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• min_event_record_id (type: esriFieldTypeDouble, alias: Min Event Record ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• max_event_record_id (type: esriFieldTypeDouble, alias: Max Event Record ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• event_count (type: esriFieldTypeInteger, alias: Event Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• is_completed (type: esriFieldTypeInteger, alias: Is Completed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• is_success (type: esriFieldTypeInteger, alias: Is Success, SQL Type: sqlTypeOther, nullable: true, editable: true)
• is_error (type: esriFieldTypeInteger, alias: Is Error, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/24/2026 3:13:49 PM

Schema Last Edit Date: 4/24/2026 3:13:46 PM

Data Last Edit Date: 4/24/2026 3:13:49 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat