After deleting the 'All Installed Software' report by accident and then re-creating it (from the SQL you kindly provided), I find that I am unable use the search by software box on the web console.
The auto-complete function works (identifies the software that exists on the network) but all items have a red cross next to them and a search using it will always yield no results.
Any help getting this up and running again would be greatly appreciated
Thanks 🙂