| Summary: |
[RFE] collect the "created_by" field of a VM into it's configuration history |
| Product: |
[Retired] oVirt
|
Reporter: |
Yaniv Lavi <ylavi> |
| Component: |
ovirt-engine-dwh | Assignee: |
Yaniv Lavi <ylavi> |
| Status: |
CLOSED
CURRENTRELEASE
|
QA Contact: |
Barak Dagan <bdagan> |
| Severity: |
medium
|
Docs Contact: |
|
| Priority: |
unspecified
|
|
|
| Version: |
3.3 | CC: |
acathrow, bazulay, bdagan, dyasny, gklein, iheim, jkt, pstehlik, Rhev-m-bugs, yeylon
|
| Target Milestone: |
--- | Keywords: |
FutureFeature, Reopened |
| Target Release: |
3.4.0 | |
|
| Hardware: |
x86_64 | |
|
| OS: |
Linux | |
|
| Whiteboard: |
infra |
|
Fixed In Version:
|
ovirt-3.4.0-beta
|
Doc Type:
|
Enhancement
|
|---|
|
Doc Text:
|
|
Story Points:
|
---
|
|---|
|
Clone Of:
|
896139
|
Environment:
|
|
|---|
|
Last Closed:
|
2014-03-31 15:05:59 UTC
|
Type:
|
Bug
|
|---|
|
Regression:
|
---
|
Mount Type:
|
---
|
|---|
|
Documentation:
|
---
|
CRM:
|
|
|---|
|
Verified Versions:
|
|
Category:
|
---
|
|---|
|
oVirt Team:
|
---
|
RHEL 7.3 requirements from Atomic Host:
|
|
|---|
|
Cloudforms Team:
|
---
|
Target Upstream Version:
|
|
|---|
|
Embargoed:
|
|
| |
|---|
| Bug Depends On: |
883778, 896139
|
|
|
| Bug Blocks: |
896140, 1052388
|
|
|
Verified on: ovirt-engine-3.4.0-0.11.beta3.el6.noarch ovirt-engine-dwh-3.4.0-0.3.el6.noarch 1) psql -d engine -c 'select vm_name, vm_type, created_by_user_id, _create_date from vm_static;' | less -S vm_name | vm_type | created_by_user_id | _create_date ---------+---------+--------------------------------------+------------------------------- Blank | 0 | | 2013-12-25 15:31:54.367179+02 vm1 | 0 | fdfc627c-d875-11e0-90f0-83df133b58cc | 2014-02-24 13:57:12.285818+02 VM-1 | 0 | fdfc627c-d875-11e0-90f0-83df133b58cc | 2014-02-23 15:24:33.371194+02 VM-2 | 0 | fdfc627c-d875-11e0-90f0-83df133b58cc | 2014-02-23 15:24:45.689163+02 VM-3 | 0 | fdfc627c-d875-11e0-90f0-83df133b58cc | 2014-02-23 15:24:57.938341+02 VM-4 | 0 | fdfc627c-d875-11e0-90f0-83df133b58cc | 2014-02-23 15:25:09.897878+02 (6 rows) 2) psql -d engine -c 'select vm_name, vm_type, created_by_user_id, create_date from dwh_vm_configuration_history_view;' | less -S vm_id | vm_name | vm_type | create_date | user_name | created_by_user_id -------+---------+---------+-------------+-----------+-------------------- (0 rows) 3) psql -d engine_history -c 'select vm_id, vm_name, vm_type, create_date, created_by_user_name as user_name, created_by_user_id from vm_configuration;' | less -S vm_id | vm_name | vm_type | create_date | user_name | created_by_user_id --------------------------------------+---------+---------+----------------------------+-----------+-------------------------------------- b891974a-3514-452b-a56f-0fecc3fea520 | vm1 | 0 | 2014-02-24 13:57:12.285+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc a3e7b4e4-5351-4faf-92f7-8d1352101de0 | VM-1 | 0 | 2014-02-23 15:24:33.371+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc f2f86f68-ca47-49e8-a3fa-fb92fad511a8 | VM-2 | 0 | 2014-02-23 15:24:45.689+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc b7e9b3d1-6f99-4868-9fcb-5740c19ea10b | VM-3 | 0 | 2014-02-23 15:24:57.938+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc 6dc3fbfd-7518-428b-b57b-d9de99633395 | VM-4 | 0 | 2014-02-23 15:25:09.897+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc (5 rows) 4) psql -d engine_history -c 'select vm_id, vm_name, vm_type, create_date, created_by_user_name as user_name, created_by_user_id from v3_4_latest_configuration_vms;' | less -S vm_id | vm_name | vm_type | create_date | user_name | created_by_user_id --------------------------------------+---------+---------+----------------------------+-----------+-------------------------------------- b891974a-3514-452b-a56f-0fecc3fea520 | vm1 | 0 | 2014-02-24 13:57:12.285+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc a3e7b4e4-5351-4faf-92f7-8d1352101de0 | VM-1 | 0 | 2014-02-23 15:24:33.371+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc f2f86f68-ca47-49e8-a3fa-fb92fad511a8 | VM-2 | 0 | 2014-02-23 15:24:45.689+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc b7e9b3d1-6f99-4868-9fcb-5740c19ea10b | VM-3 | 0 | 2014-02-23 15:24:57.938+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc 6dc3fbfd-7518-428b-b57b-d9de99633395 | VM-4 | 0 | 2014-02-23 15:25:09.897+02 | admin | fdfc627c-d875-11e0-90f0-83df133b58cc (5 rows)