Why is the database manager query not working on SolarWinds custom query widget

You need to modify your date calculation-> ADDDAY(-30,GETUTCDATE())

and I am not sure about the Table name in SWQL for the alert History. 
you might want to pre-test your queries in SWQL-Studio 

swql is not 100% SQL

Thank you for the suggestion. As you can see below, the query works just fine on the SolarWinds Database Manager. However, the same query does not work on the SolarWinds Dashboard Widget "Custom Query".

When running the query from SolarWinds dashboard, should I prefix the complete table details for columns like Name, Relatenednodecaption, etc ? If so what would it be.

Example: Instead of simply specifying the name, should I specify like AlertHistoryView.AlertObjects.AlertConfigurations, etc

Also, should I use Orion.AlertHistoryView instead of [dbo].[AlertHistoryView ] ?

Error

Custom Widget is asking for a SWQL Query NOT a SQL Query, you can not throw a SQL in there!

Yes, I understand it's different. What would be the SWQL query to fetch the intended information from the table AlertHistoryView ? Could you please advise.

SELECT AH.AlertObjects.AlertConfigurations.DisplayName as AlertName ,ah.AlertObjects.RelatedNodeCaption, Count(ah.AlertObjects.RelatedNodeCaption) as Counter
FROM Orion.AlertHistory as AH
WHERE AH.TimeStamp > ADDDAY(-7,GETUTCDATE())
GROUP BY AH.AlertObjects.AlertConfigurations.DisplayName, ah.AlertObjects.RelatedNodeCaption
ORDER BY Counter DESC

Thank you HerrDoktor 
It works, I added an AND condition by name & it worked as intended.

I think I also swapped some of your columns, I figured you could bring them in the order you want on your own.

Sure thing, thanks again

Sure thing, thanks again