search

microsoft / ARI

Azure Resource Inventory - It's a Powerful tool to create EXCEL inventory from Azure Resources with low effort
MIT License
1.12k stars 397 forks source link

changing the output method from excel to SQL or table storage #181

Closed Pieterle-Roux closed 6 months ago

Pieterle-Roux commented 7 months ago

How would I run the script so the output is written directly to a SQL database or table storage instead of into excel ?

Claudio-Merola commented 6 months ago

Hello there @Pieterle-Roux

The easiest way I can think if is to change every module to modify the Export-Excel part to input that variable into a SQL db

Pieterle-Roux commented 6 months ago

Hi Claudio

Your response is much appreciated.

We managed to do exactly that and we are appending the outputs to the database so we now have the ability to track historical changes as well

regards

Pieter Le Roux Lead: Cloud Altron Digital Business [altron.com digital business website]https://altron.com/digital-business w: altron.com/digital-businesshttps://altron.com/digital-business%20

This document is protected by Altron - labelled as General Business Information From: Claudio Merola @.> Sent: Wednesday, May 8, 2024 10:48 PM To: microsoft/ARI @.> Cc: Pieter Le Roux @.>; Mention @.> Subject: Re: [microsoft/ARI] changing the output method from excel to SQL or table storage (Issue #181)

You don't often get email from @.*** Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification

Hello there @Pieterle-Rouxhttps://github.com/Pieterle-Roux

The easiest way I can think if is to change every module to modify the Export-Excel part to input that variable into a SQL db

- Reply to this email directly, view it on GitHubhttps://github.com/microsoft/ARI/issues/181#issuecomment-2101411090, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BGKLYCR2RUB6CXUCVMEGLQLZBKFP7AVCNFSM6AAAAABGM5DZWSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMBRGQYTCMBZGA. You are receiving this because you were mentioned.Message ID: @.***>