• Note to self: last status check per computer
    Without data, it's harder to see what's going on, but you could try this pattern.  I'm using AdventureWorks2014 for data.

    -- for each customer, get his 3 most expensive invoices.
    SELECT c.CustomerID
        , t.Subtotal
    FROM Sales.Customer c
    CROSS APPLY (SELECT TOP 2 SubTotal
                FROM Sales.SalesOrderHeader soh
                WHERE soh.CustomerID = c.CustomerID
                ORDER BY soh.TotalDue DESC) t;

    To fit this to your example, your top query would be for the computer, and then the CROSS APPLY would be against the status checks. You could just just TOP 1.