I managed to run a SQL query >
SELECT [Guid]
,[Name]
FROM [Symantec_CMDB].dbo.[vResourceItem]
WHERE Guid='dee347e2-d502-48ad-96ea-0395216adcc3'
This pointed me in the right direction that it was an issue with one of our site servers. Rebuilt the site server that the query pointed to and we are now looking good.
I am not a SQL guy just stumbled across it by opening SQL Server Management Studio > opened the database > opened Views > looked down the objects and found dbo.vResourceItem right clicked on this and choose to select top 1000 rows > there was far too much to go through so removed the "TOP 1000 " from the query and also removed all the irrelevant columns (everything bar Guid and Name) and added the WHERE Guid='BlahBlah'
Result!