Unable to add field to get computer name in Alert table while pulling historical alert data

%3CLINGO-SUB%20id%3D%22lingo-sub-1288595%22%20slang%3D%22en-US%22%3EUnable%20to%20add%20field%20to%20get%20computer%20name%20in%20Alert%20table%20while%20pulling%20historical%20alert%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288595%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWe%20got%20a%20requirement%20to%20pull%20historical%20alert%20dump%20from%20Azure%20log%20analytics.%20Basically%20our%20alerts%20are%20covering%20simple%20heartbeat%2C%20utilization%20and%20some%20event%20based%20scenarios.%20While%20querying%20%22Alert%22%20table%2C%20unable%20to%20find%20any%20field%20for%20Computer%20value%20on%20which%20target%20these%20alerts%20fired%20for%3F%20We%20needed%20this%20data%20for%20some%20kind%20of%20co%20relation%20in%20a%20third%20party%20automation%20tool%3F%3C%2FP%3E%3CP%3EIs%20there%20any%20kustos%20query%20available%20to%20add%20an%20extra%20field%20to%20get%20Computer%20name%20too%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1288595%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi,

We got a requirement to pull historical alert dump from Azure log analytics. Basically our alerts are covering simple heartbeat, utilization and some event based scenarios. While querying "Alert" table, unable to find any field for Computer value on which target these alerts fired for? We needed this data for some kind of co relation in a third party automation tool?

Is there any kustos query available to add an extra field to get Computer name too?