// Create the event HistorianEvent historianEvent = new HistorianEvent { ID = Guid.NewGuid(), EventTime = DateTime.Now, ReceivedTime = DateTime.Now, //Source_Name = "MyObject", Type = "TestEventType", }; // Add custom properties if (!historianEvent.AddProperty("RandomName", "This is a custom event message", out error)) { Console.WriteLine("Failed to add 'Message' property: " + error?.ErrorDescription); } if (!historianEvent.AddProperty("Severity", "high", out error)) { Console.WriteLine("Failed to add 'Severity' property: " + error?.ErrorDescription); } if (!historianEvent.AddProperty("IsAlarm", false, out error)) { General Console.WriteLine("Failed to add 'IsAlarm' property: " + error?.ErrorDescription); } // Add the event to the Historian if (!historianProcessAndEvent.AddStreamedValue(historianEvent, out error)) { Console.WriteLine("Failed to add event: " + error?.ErrorDescription); } else { Console.WriteLine("Event added successfully."); }
Above is the code I have used to create some custom properties for the events and add the events.
I am using this query
SELECT * FROM Events WHERE EventTime between '2025-07-31 0:00' and '2025-08-01 0:00'
to see the events added in Aveva Historian Query tool. I can see these events added in the query results. But the table does not show the custom properties added using my code (For instance the property RandomName).
How will I be able to see the custom properties that I set using the Query.
I can retrieve back the value for RandomName using the code provided in SDK but I need to get the query to view it in Aveva Query Tool