Share via

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

sns 9,231 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,996 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 70,016 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