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)
Anonymous