You can ignore warnings. It's the errors you should be concerned about.
When you select the faulty filter, narrow that down to faulty assets only and remove missing dependencies and faulty dependencies because those items confuse things.
Next to the name Fault, is an arrow.
Click on the arrow and the filters will expand.
On the far right are plus (+) and minus (-) signs.
Next to Missing dependencies, click on the - to remove that line.
Repeat with Faulty dependencies.
Where the filter is now called "Custom", click save and call that Faulty - only or something similar. This is what I call mine.
If you've done this right, you'll have a much better time finding out what's truly faulty and what's not.
Once you select and view errors and warnings, exit the screen and come back in. This will refresh the database and show you anything that's truly faulty. I had about 34 assets that were faulty. Two of the assets I had imported from backups and I needed to run PEV's Images2TGA on them, the others were old and I deleted them because I hadn't used them in 20 years.
In addition to focusing on the faulty assets, I highly recommend checking for any updates. There have been some updates to DLC packages as well as assets on the DLS. These may also repair some of your faulty content.