Skip to content

Instantly share code, notes, and snippets.

@johngidt

johngidt/gist:ba71b2184e41c072e984e5798135a66c Secret

Created April 19, 2018 15:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save johngidt/ba71b2184e41c072e984e5798135a66c to your computer and use it in GitHub Desktop.
Save johngidt/ba71b2184e41c072e984e5798135a66c to your computer and use it in GitHub Desktop.
Download ZIP
ManageIQ pending requests
Raw
gistfile1.txt
[root@manageiq ~]# su - postgres
-bash-4.2$ psql -d vmdb_production
vmdb_production=# select id, description, approval_state, type, created_on, updated_on, requester_id, requester_name, request_type, request_state, message, status, userid, source_id, source_type, tenant_id, process from miq_requests where request_state='pending';
id | description | approval_state | type | created_on | updated_on | requester_id | requester_name | request_type | request_state | message | status | userid | source_id | source_type | tenant_id | process
----+--------------------------------------------------------------------------------------+------------------+-----------------------------+----------------------------+----------------------------+--------------+----------------+--------------+---------------+-----------------------------------+--------+--------+-----------+--------------+-----------+---------
2 | Provision from [amzn-ami-hvm-2017.09.1.20180307-x86_64-gp2] to [ittest-instancename] | pending_approval | MiqProvisionRequestTemplate | 2018-03-23 15:30:09.524162 | 2018-04-16 21:49:11.072893 | 1 | Administrator | template | pending | VM Provisioning - Request Created | Ok | admin | 355 | VmOrTemplate | 1 | t
4 | Provision from [amzn-ami-hvm-2017.09.1.20180307-x86_64-gp2] to [cfme###] | pending_approval | MiqProvisionRequestTemplate | 2018-03-23 20:23:38.832164 | 2018-04-16 21:48:30.160585 | 1 | Administrator | template | pending | VM Provisioning - Request Created | Ok | admin | 355 | VmOrTemplate | 1 | t
(2 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment