Bought the Q7 with no repair history in barely running condition.
Initially had tons of hard set short to ground codes that turned out to be a HPFP had failed and took out the ECU.

New HPFP(s), new pump cam followers, new correct spark plugs, new coils (8), all new injectors, intake runner's cleaned (oddly only the right bank was dirty, left bank was very clean??), new ECU, new battery.

Still have same basic issue. All short to ground faults were fixed with the new ECU and HPFPs.
Random cylinder misfires are so bad it's un-drivable and eventually stalls out.

I'm concerned its cam timing or chain related but there aren't any codes pointing to that.

I need some hope.

Code:
Thursday,05,December,2019,09:48:45:46475
VCDS -- Windows Based VAG/VAS Emulator Running on Windows 10 x64
VCDS Version: 19.6.2.0 (x64)
Data version: 20190930 DS308.0
www.Ross-Tech.com





--------------------------------------------------------------------------------
--------------------------------------------------------------------------------


                Address 01: Engine       Labels: 079-907-560-BAR.clb
Control Module Part Number: 4L0 910 560 G    HW: 4L0 907 560 B
  Component and/or Version: 4.2l V8/4V          0020
           Software Coding: 01210009190F0960
            Work Shop Code: WSC 31414 790 00001
                      VCID: 2C57768D8FBEBC2F2B-8078
7 Faults Found:

000768 - Random/Multiple Cylinder Misfire Detected 
               P0300 - 001 - 
             Freeze Frame:
                    Fault Status: 01100001
                    Fault Priority: 2
                    Fault Frequency: 1
                    Reset counter: 255
                    Mileage: 217246 km
                    Time Indication: 0
                    Date: 2007.06.02
                    Time: 08:28:29

             Freeze Frame:
                    RPM: 1934 /min
                    Load: 36.8 %
                    Speed: 0.0 km/h
                    Temperature: 36.0°C
                    Temperature: 21.0°C
                    Absolute Pres.: 990.0 mbar
                    Voltage: 13.208 V

000772 - Cylinder 4 
               P0304 - 001 - Misfire Detected
             Freeze Frame:
                    Fault Status: 01100001
                    Fault Priority: 2
                    Fault Frequency: 1
                    Reset counter: 255
                    Mileage: 217246 km
                    Time Indication: 0
                    Date: 2007.06.02
                    Time: 08:28:29

             Freeze Frame:
                    RPM: 1934 /min
                    Load: 36.8 %
                    Speed: 0.0 km/h
                    Temperature: 36.0°C
                    Temperature: 21.0°C
                    Absolute Pres.: 990.0 mbar
                    Voltage: 13.208 V

000773 - Cylinder 5 
               P0305 - 001 - Misfire Detected
             Freeze Frame:
                    Fault Status: 01100001
                    Fault Priority: 2
                    Fault Frequency: 1
                    Reset counter: 255
                    Mileage: 217246 km
                    Time Indication: 0
                    Date: 2007.06.02
                    Time: 08:28:31

             Freeze Frame:
                    RPM: 1777 /min
                    Load: 46.6 %
                    Speed: 0.0 km/h
                    Temperature: 36.0°C
                    Temperature: 21.0°C
                    Absolute Pres.: 990.0 mbar
                    Voltage: 13.208 V

000774 - Cylinder 6 
               P0306 - 001 - Misfire Detected
             Freeze Frame:
                    Fault Status: 01100001
                    Fault Priority: 2
                    Fault Frequency: 1
                    Reset counter: 255
                    Mileage: 217246 km
                    Time Indication: 0
                    Date: 2007.06.02
                    Time: 08:28:31

             Freeze Frame:
                    RPM: 1777 /min
                    Load: 46.6 %
                    Speed: 0.0 km/h
                    Temperature: 36.0°C
                    Temperature: 21.0°C
                    Absolute Pres.: 990.0 mbar
                    Voltage: 13.208 V

000775 - Cylinder 7 
               P0307 - 001 - Misfire Detected
             Freeze Frame:
                    Fault Status: 01100001
                    Fault Priority: 2
                    Fault Frequency: 1
                    Reset counter: 255
                    Mileage: 217246 km
                    Time Indication: 0
                    Date: 2007.06.02
                    Time: 08:28:31

             Freeze Frame:
                    RPM: 1777 /min
                    Load: 46.6 %
                    Speed: 0.0 km/h
                    Temperature: 36.0°C
                    Temperature: 21.0°C
                    Absolute Pres.: 990.0 mbar
                    Voltage: 13.208 V

000262 - Manifold / Barometric Pressure Sensor (G71) / (F96) 
               P0106 - 008 - Implausible Signal
             Freeze Frame:
                    Fault Status: 01101000
                    Fault Priority: 2
                    Fault Frequency: 1
                    Reset counter: 255
                    Mileage: 217246 km
                    Time Indication: 0
                    Date: 2007.06.02
                    Time: 08:29:45

             Freeze Frame:
                    RPM: 2374 /min
                    Load: 31.4 %
                    Speed: 0.0 km/h
                    Temperature: 47.0°C
                    Temperature: 21.0°C
                    Absolute Pres.: 990.0 mbar
                    Voltage: 13.335 V

005241 - Brake Boost Vacuum System 
               P1479 - 008 - Mechanical Failure
             Freeze Frame:
                    Fault Status: 01101000
                    Fault Priority: 2
                    Fault Frequency: 1
                    Reset counter: 255
                    Mileage: 217246 km
                    Time Indication: 0
                    Date: 2007.06.02
                    Time: 08:29:48

             Freeze Frame:
                    RPM: 490 /min
                    Load: 83.1 %
                    Speed: 0.0 km/h
                    Temperature: 47.0°C
                    Temperature: 21.0°C
                    Absolute Pres.: 990.0 mbar
                    Voltage: 12.192 V


Readiness: 0110 1101