Menu

#1552 [HHQ-2094] Most resources imported by hqadmin are owned by t

Bug
open
None
5
2012-10-09
2008-05-15
No

http://jira.hyperic.com/browse/HHQ-2094
When I import a bunch of platforms as hqadmin, the subject_id in the EAM_RESOURCE table registers as 0 for most resources as opposed to 1 which is the hqadmin user.



Not sure if this is the intended behavior but it breaks the ownership critter and is confusing how this occurs especially to a user.



Big question is: Why are some resources owned by hqadmin and others as admin??



mysql> select r.subject_id, count() from HQ_AVAIL_DATA_RLE rle JOIN EAM_MEASUREMENT m on rle.measurement_id = m.id JOIN EAM_RESOURCE r on m.resource_id = r.id where (rle.endtime = 9223372036854775807) and m.resource_id is not null group by r.subject_id;


+------------+----------+


| subject_id | count(
) |


+------------+----------+


| 0 | 658 |


| 1 | 47 |


+------------+----------+


2 rows in set (0.00 sec)

Discussion

Anonymous
Anonymous

Add attachments
Cancel





Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.