These queries are from the 6.0 SP2 version (I wrote a detailed document on this back in February 2005) but shouldn't have changed much since then:

Method: GetAltirisAgentDetailsSection

SELECT vi.CreatedDate 
FROM vResource vr
INNER JOIN vItem vi ON vi.Guid = vr.Guid 
WHERE vr.Guid=@Guid

SELECT MAX(StartTime) as MaxRequestTime 
FROM Evt_NS_Client_Config_Request 
WHERE ResourceGuid = @Guid"

SELECT MAX(w.ModifiedDate) as MaxModifiedDate 
FROM ResourceUpdateSummary w 
INNER JOIN vResource r ON w.ResourceGuid = r.Guid 
WHERE r.Guid=@Guid

SELECT MAX(StartTime) as MaxStartTime 
FROM Evt_NS_Event_History 
WHERE ResourceGuid=@Guid

SELECT * 
FROM Inv_AeX_AC_Client_Connectivity 
WHERE _ResourceGuid=@Guid

SELECT ca.[Agent Name], ca.[Product Version]
FROM Inv_AeX_AC_Client_Agent ca 
JOIN vResource r ON ca._ResourceGuid = r.Guid
WHERE r.Guid = @Guid

... to the Resource Manager View (to be crystal clear):

• vi.CreatedDate = "First Discovered"
• MaxRequestTime = "Last Configuration Request"
• MaxModifiedDate = "Last Inventory Received"
• MaxStartTime = "Last Event Received"

The last two query return multiple results for the "Connectivity" and "Agents" sections.