Sending mail to team about patch report of all VMS from all subscriptions using logic app

sns 9,226 Reputation points
2023-11-16T08:23:16.6566667+00:00

I have PS script which generate report in csv format of patch status across all subscriptions for all VMs ( it is done from update manger)

I want to send mail that report to particular team every week, Could you please provide me high level steps on how it can be done using logic apps.

If there is not logic apps is there any method to achieve it?

Thank you.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,948 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MayankBargali-MSFT 69,931 Reputation points
    2023-11-16T11:39:28.7133333+00:00

    @sns Thanks for reaching out. If the report are uploaded to OneDrive/storage account etc. or any other place where it is accessible then you can use the logic app reoccurrence trigger

    Workflow:

    Reoccurrence trigger (configure to trigger every week) --> Get the CSV file either using difference connectors (in case if it is in one drive then you can use OneDrive connector/ in case of store use storage connector/ HTTP call if it is accessible over HTTP) --> Send email V2 (outlook/office365 connector) attaching the byte content of your excel file.

    0 comments No comments