Listing games that are missing specific types of media

[Gaz70]

I've tried researching this but not coming up with much.

I have 7000 games in a platform and only a handful have missing media. Is there a quick and easy way to show all the ones that are missing? The "Games missing media" gives you absolutely everything so a) takes time and b) is a bit of a pain to sort through.

I am aware of the audit which although it gives me what I want and can sort it is fairly slow and unresponsive because of the amount of data there. I wondered if there was a quicker way that I am missing?

[JoeViking245]

1 hour ago, Gaz70 said:

The "Games missing media" gives you absolutely everything so a) takes time and b) is a bit of a pain to sort through.

If it helps any and you have Advanced Search enabled, you can filter it down by platform.

 

1 hour ago, Gaz70 said:

I am aware of the audit which although it gives me what I want and can sort it is fairly slow and unresponsive because of the amount of data there.

This can be exported to Excel (or your spreadsheet app of choice) which should be a lot faster.

 

Otherwise, I don't believe there is another built-in way to do so.

[Gaz70]

That's immensely helpful thank you!

While I was waiting I decided to write a powershell script instead. I also wrote one to find any game that does not have a DB ID number too. Happy to upload either/or if anyone else was interested.