Query to pull the machine detials

wanted to know if we have query to pull the machine details like serial no. , logged on user and others it should give the unique record for machine by checking for last reported date/time, so we dont ger duplicate records. please provide me info urgently