1 of 1 people found this helpful
The Alert Triggered Time is under the TimeStamp column of AlertHistoryView.
The location of the related node/device is not in the AlertHistoryView. You can try joining with the Nodes view to get the node custom properties and then in the WHERE clause, you have to mention the specific custom property name and value regarding the node's location.
Hope this helps.
Also, it looks like you want to focus only on High Link utilization data.
It appears that the query you composed has FORCED the name by including the part :
Name = 'High Interface Transmit Percent Utilization'
However, that will not filter out any other alert names. You need to do the filtering in the WHERE Clause.