SOLVED
Home

SQL Azure OMS-Job Monitoring

%3CLINGO-SUB%20id%3D%22lingo-sub-113915%22%20slang%3D%22en-US%22%3ESQL%20Azure%20OMS-Job%20Monitoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113915%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20OMS%20portal%20to%20get%20the%20failure%20notification%26nbsp%3Bfor%20runbook%20failure%20created%20under%20Azure%20automation%20account.%20I%20have%20used%20below%20query%20to%20set%20the%20alert%20and%20getting%20failure%20notification%20as%20an%20email.%20However%20the%20challenge%20is%2C%20I%20am%20not%20getting%20NAME%20of%20job%20in%20the%20email%20notification.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EType%3DAzureDiagnostics%20ResourceProvider%3D%22MICROSOFT.AUTOMATION%22%20Category%3DJobStreams%20StreamType_s%3DError%20%7C%20measure%20count()%20by%20JobId_g%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20anyother%20query%20or%20any%20other%20solution%20which%20can%20help%20me%20to%20identify%20the%20job%20name%20during%20email%20notification.%20I%20am%20attaching%20the%20image%20of%20email%20notification.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E--%20Kailash%20Jain.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-113915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114969%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Azure%20OMS-Job%20Monitoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114969%22%20slang%3D%22en-US%22%3EHi%20Unfortunately%20this%20is%20not%20possible.%20If%20you%20switch%20to%20the%20new%20query%20language%20there%20could%20be%20some%20workaround%20by%20concatenating%20the%20name%20and%20the%20jobID%20and%20than%20aggregate%20on%20the%20new%20concatenated%20value.%3C%2FLINGO-BODY%3E
null null
Occasional Visitor

Hello Team,

 

I am using OMS portal to get the failure notification for runbook failure created under Azure automation account. I have used below query to set the alert and getting failure notification as an email. However the challenge is, I am not getting NAME of job in the email notification.

 

Type=AzureDiagnostics ResourceProvider="MICROSOFT.AUTOMATION" Category=JobStreams StreamType_s=Error | measure count() by JobId_g

 

Let me know if anyother query or any other solution which can help me to identify the job name during email notification. I am attaching the image of email notification.

 

-- Kailash Jain.

 

1 Reply
Solution
Hi Unfortunately this is not possible. If you switch to the new query language there could be some workaround by concatenating the name and the jobID and than aggregate on the new concatenated value.