Browsing: get most recent records

Question from configmgr technet forum : Need SQL Query for disk space <500 MB (windows drive) for servers from most…