Bug 1161625
Summary: | [RFE] Expose creator of vm via api and/or gui | ||
---|---|---|---|
Product: | [oVirt] ovirt-engine | Reporter: | Sven Kieske <s.kieske> |
Component: | RestAPI | Assignee: | Marek Libra <mlibra> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Israel Pinto <ipinto> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | --- | CC: | asegundo, bugs, gklein, juan.hernandez, lsurette, lsvaty, melewis, mgoldboi, michal.skrivanek, rbalakri, s.kieske, srevivo, vanoppen.koen, ykaul |
Target Milestone: | ovirt-4.1.0-alpha | Keywords: | FutureFeature |
Target Release: | 4.1.0.2 | Flags: | mgoldboi:
ovirt-4.1?
ipinto: testing_plan_complete+ ylavi: planning_ack? rule-engine: devel_ack+ rule-engine: testing_ack+ |
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Enhancement | |
Doc Text: |
With this update, virtual machines can now be searched for by the user who created them. Using the REST API, the search query is ".../api/vms?search=created_by_user_id%3D[USER_ID]". The required User ID can be retrieved by using ".../api/users". In addition, the Administration Portal shows the creator's name in the virtual machine general sub-tab. However, it is possible for the user to have been removed from the system since the virtual machine was created.
|
Story Points: | --- |
Clone Of: | Environment: | ||
Last Closed: | 2017-02-01 14:53:06 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | Virt | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: | |||
Bug Depends On: | |||
Bug Blocks: | 1427755 |
Description
Sven Kieske
2014-11-07 14:03:47 UTC
Yaniv, is this information available in some existing report? As per the ML-Thread, this is already stored in the DB: We have it on database, but I don't see it exposed on API: engine=# select vm_static.vm_name, users.name, users.domain from vm_static, users where vm_static.created_by_user_id = users.user_id; -[ RECORD 1 ]----- vm_name | vm01 name | admin domain | internal -[ RECORD 2 ]----- vm_name | test name | admin domain | internal ... Does this provide the needed info? No Sven, I was asking Yaniv Dary if there is an existing ovirt-reports report that contains this information, as may useful as a workaround. Anyhow it is good to have the query in the bug, thanks. *** Bug 1161629 has been marked as a duplicate of this bug. *** (In reply to Juan Hernández from comment #1) > Yaniv, is this information available in some existing report? Yes, via ad hoc and inventory I believe. need to remember that the user id might be invalid after some time.. (creating user can be deleted..) (In reply to Omer Frenkel from comment #6) > need to remember that the user id might be invalid after some time.. > (creating user can be deleted..) I the reports it's kept forever, so this might be the best solution. so...the reporting solves this in a better way.... Don't know what info you need. Do you need the information if the provided information via reports does solve this? I would say no for the following reasons: Reports do not offer any (REST) api (I know of). I do not even have reports installed. It would at best be very clumsy to automate such a data retrieval process, as I understand it, reports generates pdfs and you could parse them for the information this BZ requests but it would still be a dirty hack. This BZ was about providing information witch is already stored in the DB via the already implemented apis, in order to process and query this information in a dynamic and automated fashion. I don't know if reports can provide this but I would rather use the existing rest api than install yet-another-software. I hope this was the information you requested. just need to bear in mind the limitation when the user is removed/renamed this is unlikely to be picked up for maintenance branch, so moving target release to 3.6 This bug did not make it in time for 3.6 release, moving into the next one Target release should be placed once a package build is known to fix a issue. Since this bug is not modified, the target version has been reset. Please use target milestone to plan a fix for a oVirt release. The fix for this issue should be included in oVirt 4.1.0 beta 1 released on December 1st. If not included please move back to modified. Verify with Engine: 4.1.0-.2.master.20161213122836.git2cd5587.el7.centos Host: OS Description:Red Hat Enterprise Linux Server 7.3 (Maipo) Kernel Version:3.10.0 - 514.el7.x86_64 KVM Version:2.6.0 - 27.1.el7 LIBVIRT Version:libvirt-2.0.0-10.el7 VDSM Version: vdsm-4.18.999-1138.git6c51957.el7.centos Polarion run: https://polarion.engineering.redhat.com/polarion/#/project/RHEVM3/testrun?id=VIRT%20Search%20Functionality&tab=records&result=passed |