IT Operations & Service Management
Vantage connects to monitoring databases, helpdesk systems, and asset management platforms to give IT teams real-time visibility into system health, automated ticket routing, SLA tracking, and infrastructure cost optimization — all through visual workflows and dashboards.
Detect Infrastructure Incidents and Reduce MTTR
Monitor infrastructure health across servers, applications, and network devices with automated incident creation.
Scenario: An IT operations team manages 500+ servers and applications. They need centralized monitoring that detects anomalies, correlates related events, and creates Jira incidents automatically — reducing MTTR (Mean Time to Resolution).
Workflow Steps:
- Schedule Trigger — Run every 2 minutes
- Database Query (PostgreSQL) — Pull system metrics: hostname, CPU %, memory %, disk %, response time (ms), error rate, uptime status, last check timestamp
- Database Query (PostgreSQL) — Pull application metrics: service name, request count, error count, p99 latency, queue depth, active connections
- Aggregation — Calculate rolling 15-minute averages and detect trends
- Filter — Flag alerts:
- CPU > 90% sustained for 10+ minutes
- Memory > 95%
- Disk > 85%
- Error rate > 1% of requests
- Response time > 3x baseline
- Service unreachable (2 consecutive failed checks)
- AI Enrichment — Correlate alerts:
- Group related alerts (same host, same application, same network segment)
- Classify root cause probability: resource exhaustion, application bug, dependency failure, network issue
- Assess business impact based on service criticality tier
- Multi-Conditional — Route by severity:
- Service down or critical component → Create Issue (Jira, Priority: Critical) + Send Email to on-call engineer + Send Message (Slack #incidents) + Dashboard Output (Event Monitor Tile)
- Performance degradation → Create Issue (Jira, Priority: High) + Send Message (Slack #ops-alerts)
- Capacity warning → Dashboard Output (List Tile for capacity planning review)
- Dashboard Output — Populate:
- Event Monitor Tile — Active incidents with severity and assigned engineer
- Map Tile — Data center / cloud region status with host health indicators
- Metric Tile — Uptime %, open incidents, MTTR, alert count (24h)
- Line Tile — CPU, memory, response time trends by critical service
- Bar Tile — Incidents by category (infrastructure, application, network, security)
- Stat Tile — Services: healthy / degraded / down
Key Nodes: Schedule Trigger, Database Query, Aggregation, Filter, AI Enrichment, Multi-Conditional, Create Issue (Jira), Send Email, Send Message, Dashboard Output
Route Helpdesk Tickets Intelligently and Track SLAs
Automatically classify, prioritize, and route helpdesk tickets, with SLA compliance tracking.
Scenario: An IT helpdesk receives 200+ tickets daily. They need automated classification, intelligent routing to the right support group, and real-time SLA compliance dashboards.
Workflow Steps:
- Schedule Trigger — Run every 5 minutes
- Zendesk — List Tickets — Pull newly created tickets: subject, description, requester, department, urgency
- AI Enrichment — Classify each ticket:
- Category: Hardware, Software, Network, Access/Permissions, Email, Printing, Security
- Complexity: L1 (how-to/password reset), L2 (configuration/troubleshooting), L3 (engineering/development)
- Priority: Critical, High, Medium, Low (based on requester VIP status, department criticality, and issue type)
- Database Query (PostgreSQL) — Pull SLA definitions by category and priority: response time target, resolution time target
- Multi-Conditional — Route by classification:
- L1 tickets (password resets, how-to) → Message AI Response (generate auto-reply with knowledge base article link) + Dashboard Output
- L2 tickets → Assign to the appropriate support group + Send Message (Teams) to the team lead
- L3 tickets → Create Issue (Jira) for engineering + Send Email to the IT manager
- Critical tickets (VIP or system-wide) → Send Email to IT director + Send Message (Slack #it-escalation) + Dashboard Output (Event Monitor Tile)
- Dashboard Output — Populate:
- Metric Tile — Open tickets, SLA compliance %, average first response time, average resolution time
- Bar Tile — Ticket volume by category
- Pie Tile — Tickets by support tier (L1/L2/L3)
- Line Tile — Daily ticket volume and resolution trends
- Table Tile — Open tickets with SLA countdown (time remaining to breach)
- Event Feed Tile — Real-time ticket activity stream
- Comparison Tile — SLA compliance this week vs. last week
Key Nodes: Schedule Trigger, Zendesk List Tickets, AI Enrichment, Database Query, Multi-Conditional, Message AI Response, Create Issue (Jira), Send Email, Send Message, Dashboard Output
Relevant Integrations: Zendesk, Jira, Slack, Teams Chat
Manage IT Assets from Procurement Through Retirement
Track hardware and software assets from procurement through retirement, monitor warranty status, and optimize costs.
Scenario: An IT asset manager oversees 2,000 laptops, 500 servers, and 150 software licenses. They need lifecycle tracking, warranty monitoring, and license compliance dashboards.
Workflow Steps:
- Schedule Trigger — Run weekly
- Database Query (PostgreSQL) — Pull asset inventory: asset tag, type, make/model, serial number, assigned user, purchase date, warranty expiration, cost, status (active, spare, repair, retired)
- Database Query (MSSQL) — Pull software license inventory: product, license type, seats purchased, seats used, renewal date, annual cost
- Computed Column — Calculate:
- Asset age: months since purchase
- Warranty remaining: months until expiration
- Replacement eligibility: assets > 4 years old or out of warranty
- License utilization:
seats_used / seats_purchased * 100 - Cost per user:
annual_license_cost / seats_used
- Aggregation — Summarize by department:
- Total asset value
- Average asset age
- Replacement forecast: units eligible for refresh next quarter
- License spend vs. utilization
- Filter — Flag action items:
- Warranties expiring in next 90 days
- Assets > 5 years old still in active use
- Software licenses < 10% utilized (optimization candidates)
- Software licenses > 95% utilized (need additional seats)
- Multi-Conditional — Route by type:
- Warranty expiration → Send Email to procurement with renewal list
- Over-licensed software → Send Email to IT finance for cost optimization review
- Under-licensed (usage > purchased) → Send Email to compliance with gap analysis
- Aging hardware → Dashboard Output to refresh planning queue
- Dashboard Output — Populate:
- Table Tile — Full asset inventory with status, age, warranty, and assigned user
- Bar Tile — Asset distribution by type and age bracket
- Pie Tile — Software license utilization (utilized vs. shelfware)
- Metric Tile — Total asset value, average age, upcoming renewals, shelfware cost
- Forecast Tile — Hardware refresh budget projection for next 4 quarters
- Line Tile — Monthly IT asset spend trend
Key Nodes: Schedule Trigger, Database Query (PostgreSQL, MSSQL), Computed Column, Aggregation, Filter, Multi-Conditional, Send Email, Dashboard Output
Track Changes and Deployments with DORA Metrics
Track IT change requests through approval, implementation, and post-deployment verification.
Scenario: An IT change management team needs to track all system changes (patches, deployments, configurations), ensure proper approval workflow, and correlate changes with post-deployment incidents.
Workflow Steps:
- Schedule Trigger — Run every 30 minutes
- Database Query (PostgreSQL) — Pull change records: change ID, system, type (standard, normal, emergency), requested by, approved by, scheduled date, status (pending, approved, in-progress, completed, rolled back)
- Search Issues (Jira) — Pull related deployment tickets and their status
- Join — Link change records to Jira deployment tickets
- Computed Column — Calculate:
- Change lead time: days from request to implementation
- Change failure rate: changes that required rollback / total changes
- Post-change incident correlation: incidents within 4 hours of a change
- Aggregation — Calculate change management KPIs (rolling 30 days):
- Total changes, standard vs. emergency ratio
- Approval cycle time
- Change success rate
- DORA metrics: deployment frequency, lead time, failure rate, MTTR
- Filter — Flag issues:
- Emergency changes (require post-hoc review)
- Changes without proper approval
- Changes with post-deployment incidents
- Dashboard Output — Populate:
- Gantt Tile — Change schedule with implementation windows
- Metric Tile — Change success rate, DORA metrics, compliance rate
- Bar Tile — Changes by type and system
- Timeline Tile — Change → deployment → verification sequence
- Line Tile — Monthly change volume and failure rate trend
- Table Tile — Change backlog with approval status
Key Nodes: Schedule Trigger, Database Query, Search Issues (Jira), Join, Computed Column, Aggregation, Filter, Dashboard Output
Example Dashboard: IT Service & Infrastructure Dashboard
Build this dashboard to give your IT leadership visibility into system health, helpdesk performance, asset status, and change management.
Row 1 — IT Health
| Tile | Name | What It Shows |
|---|---|---|
| Metric | System Uptime | Overall infrastructure uptime percentage with sparkline (target: ≥ 99.9%) |
| Metric | Open Incidents | Count of active incidents by severity (P1/P2/P3/P4) with trend |
| Metric | Ticket SLA Compliance | Percentage of helpdesk tickets resolved within SLA with comparison to last week |
| Stat | Active P1 Incidents | Count with red/green indicator and time since oldest P1 |
Row 2 — Infrastructure Status & Alerts
| Tile | Name | What It Shows |
|---|---|---|
| Map | Infrastructure Map | Data center and cloud region status with host/service health indicators. Green = healthy, yellow = degraded, red = down. Click any host for CPU/memory/disk detail |
| Event Monitor | Incident Tracker | Active incidents with severity, affected system, assigned engineer, MTTR countdown, and status (investigating, identified, resolving, resolved) |
Row 3 — Helpdesk & Asset
| Tile | Name | What It Shows |
|---|---|---|
| Step | Ticket Lifecycle | New → Classified → Assigned → In Progress → Resolved. Shows count and average time at each stage. Bottleneck stages highlighted |
| Pie | Tickets by Category | Distribution across Hardware, Software, Network, Access, Email, Security with month-over-month change indicators |
Row 4 — Asset Management & Change
| Tile | Name | What It Shows |
|---|---|---|
| Bar | Software License Utilization | Each software product showing purchased seats vs. used seats. Shelfware (unused licenses) highlighted for cost optimization |
| Gantt | Change Calendar | Upcoming and in-progress changes with implementation windows, approval status, and risk level |
Row 5 — Performance & Trends
| Tile | Name | What It Shows |
|---|---|---|
| Line | Helpdesk Volume Trend | Daily ticket volume and resolution count over 90 days with moving average. Shows seasonal patterns and staffing needs |
| Comparison | DORA Metrics | Deployment frequency, lead time, change failure rate, and MTTR — this month vs. last month with trend indicators |
Data Sources: Database Query to monitoring databases (PostgreSQL), Zendesk List Tickets for helpdesk data, Jira Search Issues for change management. Schedule Trigger refreshes every 2 minutes for monitoring, every 5 minutes for tickets.
Getting Started
To build IT operations workflows:
- Connect your monitoring databases — Add your infrastructure and application monitoring data sources under Integrations
- Connect your helpdesk — Authenticate Zendesk and/or Jira under Integrations
- Start with monitoring — Build a Schedule Trigger → Database Query → Filter → Multi-Conditional workflow for system health alerts
- Automate ticket routing — Use AI Enrichment to classify helpdesk tickets and Multi-Conditional to route them
- Build the IT dashboard — Event Monitor, Metric, and Bar tiles for system status at a glance