SOLVED

Getting failed connections from ServiceMap using Analytics

%3CLINGO-SUB%20id%3D%22lingo-sub-185889%22%20slang%3D%22en-US%22%3EGetting%20failed%20connections%20from%20ServiceMap%20using%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185889%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20wondering%20if%20it%20is%20possible%20to%20have%20a%20query%20that%20would%20retrieve%20all%20the%20failed%20connections%20that%3C%2FP%3E%3CP%3Ewe%20see%20in%20servicemap%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anybody%20done%20this%20and%20would%20like%20to%20share%20the%20solution%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThx%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-185889%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-186211%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20failed%20connections%20from%20ServiceMap%20using%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-186211%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20David.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20greatly%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-186138%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20failed%20connections%20from%20ServiceMap%20using%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-186138%22%20slang%3D%22en-US%22%3E%3CP%3EDan%2C%20right%20now%20you%20can%20only%20get%20information%20about%20connections%2C%20including%20failed%20connections%2C%20from%20the%20Service%20Map%20API.%26nbsp%3B%20That%20data%20is%20not%20in%20Log%20Analytics%20yet%2C%20but%20it%20is%20something%20that%20we%20are%20actively%20working%20on.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20attached%20a%20sample%20script%20that%20queries%20the%20API%20for%20connection%20data%20and%20writes%20it%20to%20a%20CSV.%26nbsp%3B%20It%20doesn't%20specifically%20target%20failed%20connections%2C%20but%20that%20would%20be%20a%20small%20change.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all.

 

We are wondering if it is possible to have a query that would retrieve all the failed connections that

we see in servicemap ?

 

Has anybody done this and would like to share the solution ?

 

Thx in advance

2 Replies
Highlighted
Solution

Dan, right now you can only get information about connections, including failed connections, from the Service Map API.  That data is not in Log Analytics yet, but it is something that we are actively working on.

 

 

I have attached a sample script that queries the API for connection data and writes it to a CSV.  It doesn't specifically target failed connections, but that would be a small change.

Highlighted

Hi David.

 

Thank you, greatly appreciated