iNeed is UNICC's official ticketing platform (web-based).
For every completed task that has an iNeed WO or SR:
The asset name = contexts.asset_number in Support Tracker for the relevant application.
See README.md for full mapping table.
Radius WOs → asset name: Missions Radius Service (context: Mission Pin Code)
Carlos receives a daily report showing WOs with missing assets (team-wide).
He fills only his own WOs.
ST query to find WOs with missing assets:
SELECT i.description, sr.sr_number, wo.wo_number, sr.asset_added
FROM work_orders wo
JOIN service_requests sr ON wo.sr_id = sr.id
JOIN items i ON sr.item_id = i.id
WHERE sr.asset_added = false OR sr.asset_added IS NULL;
Goal: automate via Playwright (iNeed is web-based, already tested with Comet browser).
POC tracked in Mission Control tracker.
Each activity: description of work done + hours + minutes worked.