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
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
Best Response confirmed by Dan Hansen (New Contributor)
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.

Hi David.

 

Thank you, greatly appreciated