Displaying 1 result from an estimated 1 matches for "healthstate".
2011 Aug 16
9
Rails Looping with different attributes
...olution. I hope i will get some help here.
I am using these three find methods to get different types of
devices. I dont have any relationships between any models.
windows_devices = BaseManagedEntity.find(:all,
:select => "b.BaseManagedEntityInternalId, c.NetworkName,
c.IPAddress, s.HealthState, s.LastModified",
:joins => "as b INNER JOIN mt_computer as c ON
c.basemanagedentityid = b.basemanagedentityid
INNER JOIN state as s ON b.basemanagedentityid =
s.basemanagedentityid",
:conditions => "IsManaged = 1 and s.LastModified = (select
MAX(LastModified)...