Reporting & Analytics Guide

generate_report:
  content: <markdown from any capability>
  format: pdf           # or pptx
  title: "Instance Health Scan"
  capability: scan-health # optional — used in filename

# Returns: { file_path, size_bytes, format }

generate_report:
  format: pdf
  title: "Comprehensive Instance Audit"
  capability: combined-audit
  sections:
    - title: "Instance Health Scan"
      capability: scan-health
      content: <scan-health markdown>
    - title: "Security Posture Audit"
      capability: scan-security
      content: <scan-security markdown>
    - title: "Code Review Analysis"
      capability: review-code
      content: <review-code markdown>

# Pick any combination of capabilities — 1, 3, or all 26.
# Each section becomes a chapter in the final document.

trend_query:
  table: incident
  date_field: opened_at
  group_by: priority
  periods: 6

# Returns monthly counts grouped by priority level.

run_aggregate_query:
  table: task_sla
  group_by: has_breached
  aggregate: COUNT

# Returns count of breached vs. compliant SLAs.

run_aggregate_query:
  table: incident
  group_by: assignment_group
  query: state!=6
  aggregate: COUNT

get_performance_analytics:
  widget_sys_id: <PA widget sys_id>
  time_range: last_30_days

# Uses the ServiceNow Performance Analytics API:
# GET /api/now/pa/widget/{sys_id}

# 1. Create a new daily script job
create_scheduled_job
  name="Nightly Cleanup"
  script="gs.info('running');"
  run_type="daily"
  run_time="02:00:00"

# 2. Verify the job was created
get_scheduled_job sys_id="<sys_id>"

# 3. Trigger immediately to test
trigger_scheduled_job sys_id="<sys_id>"

# 4. Check execution history
list_job_run_history job_sys_id="<sys_id>"

# 1. List all active scheduled jobs
list_scheduled_jobs active=true

# 2. Update the script or schedule
update_scheduled_job sys_id="<sys_id>"
  fields={script: "// updated script", run_type: "weekly"}