I have the filters on the report set to this: If you do an auto report make sure to NOT include the date in the file path and make sure to overwrite old files. I have this on an auto-report which saves the CSV file to a UNC path on a network share every night at 6:00 PM. It must have the Computer Name and Computer Serial Number fields, but it can contain additional fields as well if you want. I couldn't find a great solution so I decided to automate importing some data into PDQ to make this work.
One of my coworkers was tasked with pulling reports of old computers that need to be replaced which sent me down a rabbit hole of trying to automatically determine that based on data in PDQ Inventory.