Bug 1052383 - [RFE] collect the "created_by" field of a VM into it's configuration history
Summary: [RFE] collect the "created_by" field of a VM into it's configuration history
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: oVirt
Classification: Retired
Component: ovirt-engine-dwh
Version: 3.3
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: ---
: 3.4.0
Assignee: Yaniv Lavi
QA Contact: Barak Dagan
URL:
Whiteboard: infra
Depends On: 883778 896139
Blocks: 896140 1052388
TreeView+ depends on / blocked
 
Reported: 2014-01-13 18:17 UTC by Yaniv Lavi
Modified: 2014-07-13 23:20 UTC (History)
10 users (show)

Fixed In Version: ovirt-3.4.0-beta
Clone Of: 896139
Environment:
Last Closed: 2014-03-31 15:05:59 UTC
oVirt Team: ---
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 23064 0 None None None Never
oVirt gerrit 23065 0 None None None Never

Comment 1 Barak Dagan 2014-02-25 13:23:43 UTC 
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)
Comment 2 Sandro Bonazzola 2014-03-31 15:05:59 UTC 
This is an automated message: moving to Closed CURRENT_RELEASE since oVirt 3.4.0 has been released.
Note You need to log in before you can comment on or make changes to this bug.