dashboard in azure from csv aor json data stored in storage account.

Amol Bhalerao 21 Reputation points
2022-06-16T07:21:08.163+00:00

we run a powershell script to collect data in CSV or JSON which is going in storage account as destination every hour . we have a requirement of dashboard for simulations which ran in last 24 hours from this data . this option is available in azure ? any other options do we have?

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,729 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,134 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnuragSingh-MSFT 20,431 Reputation points
    2022-06-17T06:06:18.827+00:00

    @Amol Bhalerao , Thank you for reaching out to Microsoft Q&A for this question.

    Based on my understanding of the issue above, I would suggest using Azure Automation for the periodic/scheduled run of this script. When this script runs (as a runbook job in Azure Automation), the relevant details are recorded and will be available to you as shown in the following screenshot:

    212384-image.png

    You can even click on individual job run as shown in the screenshot above to get details like - error, output, warning, logs etc.
    This link contains a quick start guide to help you get started.

    You can even forward the job status to Log Analytics workspace, from where you would be able to query the details using KQL and create workbooks.

    Please let me know if you have any questions.
    If the suggestion above does not meet your requirement, can you please elaborate the query to help us understand it better - with screenshots/samples etc.