Log analytics for report generation

%3CLINGO-SUB%20id%3D%22lingo-sub-1469610%22%20slang%3D%22en-US%22%3ELog%20analytics%20for%20report%20generation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469610%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20the%20azure%20log%20analytics%2C%20can%20we%20send%20out%20query%20output%20as%20a%20weekly%20or%20monthly%20report%3F.%20If%20not%20possible%20please%20let%20me%20know%20any%20other%20service%20that%20I%20can%20integrate%20with%20log%20analytics%20service%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1469610%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-1469821%22%20slang%3D%22en-US%22%3ERe%3A%20Log%20analytics%20for%20report%20generation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F701665%22%20target%3D%22_blank%22%3E%40alchem_rj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%2C%20This%20is%20how%20I%20would%20do%20it.%26nbsp%3B%20I%20prefer%20a%20Azure%20Monitor%20Workbook%20and%20let%20the%20person%2Fteam%20view%20or%20download%20the%20data%20as%20required%2C%20its%20simple.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%20if%20you%20do%20need%20automation%2C%20please%20use%20a%20Logic%20App%20(playbook).%26nbsp%3B%20This%20is%20one%20of%20mine%20as%20a%20example%3A%3C%2FP%3E%0A%3CP%3E1.%20The%20%3CSTRONG%3ERecurrence%3C%2FSTRONG%3E%20-%20sets%20the%20schedule%2C%20this%20one%20runs%20on%20Friday%20at%2023%3A00%3C%2FP%3E%0A%3CP%3E2.%20We%20use%20the%20%22%3CSTRONG%3ERun%20query..%3C%2FSTRONG%3E%22%20to%20send%20the%20KQL%20commands%20and%20create%20a%20output.%26nbsp%3B%20I%20actually%20run%20two%20queries%2C%20as%20I%20need%20a%20Capacity%20report%20(shown)%20and%20a%20Performance%20report.%26nbsp%3B%20By%20adding%20a%20parallel%20branch%20you%20can%20do%20more%20or%20less.%3C%2FP%3E%0A%3CP%3E3.%20Use%20an%20email%20connector%20like%20%22%3CSTRONG%3Esend%20an%20email...%3C%2FSTRONG%3E%22%20-%20as%20I%20use%20O365%2C%20to%20send%20the%20output%20to%20the%20desired%20people%2Fteam.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Annotation%202020-06-17%20081316.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199177iB7B1881D4407EC62%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-06-17%20081316.jpg%22%20alt%3D%22Annotation%202020-06-17%20081316.jpg%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3CBR%20%2F%3EIn%20my%20case%20in%20Step2%20I%20used%20a%20time%20chart%2C%20you%20can%20see%20the%20other%20options%20here%3A%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%22Annotation%202020-06-17%20081751.jpg%22%20style%3D%22width%3A%20978px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199179i902CBFED9A45BA8F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-06-17%20081751.jpg%22%20alt%3D%22Annotation%202020-06-17%20081751.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

 

From the azure log analytics, can we send out query output as a weekly or monthly report?. If not possible please let me know any other service that I can integrate with log analytics service?

 

Thanks in advance

1 Reply
Highlighted

@alchem_rj 

 

Hi, This is how I would do it.  I prefer a Azure Monitor Workbook and let the person/team view or download the data as required, its simple.

 

However if you do need automation, please use a Logic App (playbook).  This is one of mine as a example:

1. The Recurrence - sets the schedule, this one runs on Friday at 23:00

2. We use the "Run query.." to send the KQL commands and create a output.  I actually run two queries, as I need a Capacity report (shown) and a Performance report.  By adding a parallel branch you can do more or less.

3. Use an email connector like "send an email..." - as I use O365, to send the output to the desired people/team.

 



Annotation 2020-06-17 081316.jpg 
In my case in Step2 I used a time chart, you can see the other options here:

 

Annotation 2020-06-17 081751.jpg