Ticket system overview
Only users with the required permissions on a resource can perform controlled operations directly. CloudDM routes SQL execution, database changes, and access requests through configured approval and execution workflows. It keeps a record of each stage. Open WorkOrder in the navigation to work with tickets.
Green marks steps involving the requester. Blue marks steps involving the approver or execution. CloudDM can use its built-in engine or a connected third-party approval system. Check the ticket details for the current stage.
Ticket types
- SQL Ticket submits SQL for controlled execution.
- Change Ticket handles approvals in a CI/CD change workflow.
- Auth Ticket requests access to database resources and permission to perform operations on them.
Click Submit on the WorkOrder page to choose SQL Ticket or Auth Ticket. CI/CD change workflows create change tickets.
Workflow stages
Ticket details show progress through five stages.
- Create. The requester submits the ticket.
- Analysis. CloudDM analyzes the ticket contents.
- Approval. The built-in engine or a third-party system handles approval.
- Confirmation. The approved ticket is confirmed before execution.
- Execution. CloudDM executes the confirmed operations and records the outcome.
Available actions depend on the ticket type, current stage, environment settings, workflow template, and ticket permissions of the signed-in account.