Using SEPM reporting should be able to assist with this need. It may be necessary to compare SEPM report results to a separately managed inventory list, but this would be true in the case of any management database that relies on client communications to maintain a status.