Source
Change-ticket exports: what to paste and which columns are read
A change management tool's export of change records for the period: number, configuration item, short description, requested by, approver, approval date, implementation date, type (standard, normal, emergency) and implemented by.
A header row it reads
the change population boxnumber, configuration item, short description, requested by, approved by, approval date, implementation date, type, implemented by
Headers are matched by name, in any order, in any case; CSV, tabs and pipes all work. Times in ISO, US or UK formats are read, and the result states the time zone and the date order it used.
Every column name recognised
155 aliases| Field | Column names read as it |
|---|---|
| change id | id, number, no, #, pr, pr number, pr id, pull request, pull request id, merge request, mr, mr id, change, change id, change number, change no, key, record |
| title | title, summary, description, short description, name, subject, pr title, change title |
| system | system, repository, repo, application, app, service, component, project, configuration item, ci, affected system, product |
| author | author, created by, opened by, developer, submitted by, committer, login, user, owner, implementer, change owner, raised by |
| requested by (who set an automated author to work) | requested by, requester, prompted by, triggered by, initiated by, assignee, assigned to |
| reviewers (read as approvers only when there is no approver column) | reviewers, reviewed by, requested reviewers, reviewer |
| approver | approver, approved by, approvers, approval by, cab approver, change approver, signed off by, authorized by, authorised by, sign off |
| approved at | approved at, approved, approval date, approved on, approval time, approved date, approval, authorized at, authorised at, approved time |
| merged at | merged at, merged, merge date, merged on, merge time, closed at, completed at, merged date |
| deployed at | deployed at, deployed, deploy date, deployment date, released at, release date, implemented at, implementation date, actual end, production date, deployed on, go live |
| deployed by | deployed by, released by, implemented by, deployer, released |
| environment (non-production rows are shown, not read for findings) | environment, env, target, target environment, stage |
| change type | type, change type, category, class, change class, change category |
| ticket or change reference | ticket, change ref, change reference, issue, work item, linked ticket, change request, rfc, cr, story, reference, ref, linked issue, ticket id |
| in scope (rows marked out of scope are shown, not read for findings) | in scope, sox, sox scope, sox relevant, financially significant, key system, sox in scope, scope |
| test evidence | tests, test evidence, testing, ci status, checks, test result, uat, test, test run, qa |
| commit | commit, sha, commit sha, merge commit, revision, hash |