Hello guys.
I Have ZERO SQL experience so anyone's help will be greatly appreciated.
I need to add on my reports Region
SELECT DISTINCT
ahv.Name 'Alert Name'
,ahv.RelatedNodeCaption 'Parent Device'
,ahv.EntityCaption 'Alert Object'
,ISNULL(lastOne.Qty,0) 'Last 1 Day'
,ISNULL(lastSeven.Qty,0) 'Last 7 Days'
,ISNULL(lastThirty.Qty,0) 'Last 30 Days'
FROM AlertHistoryView ahv
How do I do it PLEASE?
Thanks in advancce to all of you that might help me/ save me