Displaying 1 result from an estimated 1 matches for "basemanagedentityid".
2011 Aug 16
9
Rails Looping with different attributes
...t 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) from state where basemanagedentityid =
s.basemanagedentityid)",
:order => "s.LastModifi...