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.