%3CLINGO-SUB%20id%3D%22lingo-sub-2105829%22%20slang%3D%22en-US%22%3EView%20and%20query%20Log%20Analytics%20with%20Kibana%20and%20Azure%20Data%20Explorer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2105829%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%3CU%3EView%20and%20Query%20Log%20Analytics%20in%20Kibana%20dashboard%20using%20Azure%20Data%20Explorer%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EThis%20experience%20enables%20you%20to%20query%20Azure%20Log%20Analytics%20in%20%3CA%20href%3D%22https%3A%2F%2Fwww.elastic.co%2Fkibana%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EKibana%3C%2FA%3E%2C%20using%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-explorer%2Fk2bridge%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Data%20Explorer%20and%20Kibana%20integration%3C%2FA%3E%26nbsp%3Band%20the%20cross-service%20query%20ability%20between%20Azure%20Data%20Explorer%20and%20Azure%20Log%20Analytics%20(see%20more%20info%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fadxproxy%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehere%3C%2FA%3E)%20so%20you%20could%20join%20and%20analyze%20all%20your%20data%20in%20one%20place.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22OREN_SALZBERG_0-1611836616272.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F250243i6DA2BFC031C5D5D1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22OREN_SALZBERG_0-1611836616272.png%22%20alt%3D%22OREN_SALZBERG_0-1611836616272.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFollow%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-explorer%2Fk2bridge%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Einstructions%3C%2FA%3E%20to%20set%20up%20an%20integration%20between%20your%20Kibana%20instance%20and%20your%20Azure%20Data%20Explorer%20cluster%2C%20than%2C%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-explorer%2Fkusto%2Fmanagement%2Fcreate-function%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ecreate%20a%20function%3C%2FA%3E%26nbsp%3Bin%20Azure%20Data%20Explorer%20with%20the%20following%20pattern%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-html%22%3E%3CCODE%3Ecluster('https%3A%2F%2Fade.loganalytics.io%2Fsubscriptions%2F%3CSUBSCRIPTION-ID%3E%2Fresourcegroups%2F%3CRESOURCE-GROUP-NAME%3E%2Fproviders%2Fmicrosoft.operationalinsights%2Fworkspaces%2F%3CWORKSPACE-NAME%3E').database('%3CWORKSPACE-NAME%3E').%3CTABLENAME%3E%0A%3C%2FTABLENAME%3E%3C%2FWORKSPACE-NAME%3E%3C%2FWORKSPACE-NAME%3E%3C%2FRESOURCE-GROUP-NAME%3E%3C%2FSUBSCRIPTION-ID%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20data-unlink%3D%22true%22%3ENow%2C%20the%20function%20is%20in%20Kibana%20and%20you%20can%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.elastic.co%2Fguide%2Fen%2Fkibana%2Fcurrent%2Findex-patterns.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Econfigure%20an%20index%20pattern%3C%2FA%3E%26nbsp%3Band%20query%20your%20Log%20Analytics%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENote%20that%20the%20ability%20to%20query%20Log%20Analytics%20from%20Azure%20Data%20Explorer%20is%20in%20public%20preview%2C%20for%20any%20questions%20please%20contact%20%3CA%20href%3D%22mailto%3Aadxproxy%40microsoft.com%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EADXProxy%3C%2FA%3E%20team.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2105829%22%20slang%3D%22en-US%22%3E%3CP%3EQuery%20Log%20Analytics%20workspace%20using%20Azure%20Data%20Explorer%20data%20through%20Kibana%20(part%20of%20the%20ELK%20stack)%20to%20join%20and%20analyze%20all%20your%20data%20in%20one%20place.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

View and Query Log Analytics in Kibana dashboard using Azure Data Explorer

This experience enables you to query Azure Log Analytics in Kibana, using the Azure Data Explorer and Kibana integration and the cross-service query ability between Azure Data Explorer and Azure Log Analytics (see more info here) so you could join and analyze all your data in one place.

 

OREN_SALZBERG_0-1611836616272.png

 

Follow the instructions to set up an integration between your Kibana instance and your Azure Data Explorer cluster, than, create a function in Azure Data Explorer with the following pattern:

 

cluster('https://ade.loganalytics.io/subscriptions/<subscription-id>/resourcegroups/<resource-group-name>/providers/microsoft.operationalinsights/workspaces/<workspace-name>').database('<workspace-name>').<tablename>

 

 

Now, the function is in Kibana and you can configure an index pattern and query your Log Analytics data.

 

Note that the ability to query Log Analytics from Azure Data Explorer is in public preview, for any questions please contact ADXProxy team.