I'm having issues with Report Writer where it does not return FIELDS I expect but most often shows this one field named EVENT TYPE NAME.
For instance, in creating an APM Historical report, I might not get the field name I expect of APPLICATION NAME, but instead I get this EVENT TYPE NAME.
Or else, from this short Report:
SELECT TOP 10000 Nodes.Caption AS NodeName,
VirtualMachines.DisplayName AS DisplayName
FROM
VirtualMachines INNER JOIN Nodes ON (VirtualMachines.HostNodeID = Nodes.NodeID)
In this case, the DISPLAYNAME has a field formatting of EVENT TYPE NAME and not DisplayName.
This results in not getting back value, most especially in APM's Statistic_Data fields.