Hey, Is there a way to view what KQL is the backup report actually using? Thank you

@sameermhaisekar Currently backup reports have been made non-editable. However there are plans to make it editable in near future. Updating the answer for follow up query. Technically it is possible to know the queries used as Backup Reports template, which is publicly accessible from Workbooks github repo. You can visit this link , copy the contents of the file into a new workbook and then edit it to see the queries used. Please be informed that these queries are not very suited for customization. So our Product teams recommendation is to wait for edit functionality to be made available later this year, however if your requirement is time sensitive you can also use the above method to see the queries. Please feel free to circle back if you have any further queries. Thank you

Backup Reports workbook - Microsoft Q&A

Accepted answer

bharathn-msft 5,086 Reputation points Microsoft Employee

2020-08-03T22:07:35.867+00:00

@sameermhaisekar Currently backup reports have been made non-editable. However there are plans to make it editable in near future.

Updating the answer for follow up query. Technically it is possible to know the queries used as Backup Reports template, which is publicly accessible from Workbooks github repo. You can visit this link , copy the contents of the file into a new workbook and then edit it to see the queries used.

Please be informed that these queries are not very suited for customization. So our Product teams recommendation is to wait for edit functionality to be made available later this year, however if your requirement is time sensitive you can also use the above method to see the queries.

Please feel free to circle back if you have any further queries. Thank you
Please sign in to rate this answer.
Badger 56 Reputation points MVP

2020-08-04T04:30:05.023+00:00

I see, thank you. Is it possible to get the queries used somehow?

Cheers

bharathn-msft 5,086 Reputation points Microsoft Employee

2020-08-05T05:31:10.387+00:00

@sameermhaisekar Apologies for the delay in circling back on your follow up query , was checking with our team on this. Seems that technically it is possible to know the queries used as Backup Reports template, which is publicly accessible from Workbooks github repo. You can visit this link , copy the contents of the file into a new workbook and then edit it to see the queries used.

Please be informed that these queries are not very suited for customization. So our Product teams recommendation is to wait for edit functionality to be made available later this year, however if your requirement is time sensitive you can also use the above method to see the queries.

Hope this information helps. Please revert back if you have any further queries. Thank you

bharathn-msft 5,086 Reputation points Microsoft Employee

2020-08-05T17:34:31.313+00:00

@sameermhaisekar Please review the above information and let us know if you have any queries. Thank you

bharathn-msft 5,086 Reputation points Microsoft Employee

2020-08-18T06:06:00.307+00:00

@sameermhaisekar Please review the above information and let us know if you have any queries. Thank you
Sign in to comment

Share via

Backup Reports workbook

0 additional answers