Export data as excel

[clhambone]

I know within the DBADash gui there is a way to export data to excel but is there a way to automate that? I looked for other general discussions but could not find anything related to it so that is why I started a new discussion.

[DavidWiseman]

There isn't a way to do this by the app but you could probably use Invoke-DbaQuery with Export-Excel to accomplish this. The query used to generate the report in the app will have an associated stored procedure in the repository database you can run. This wouldn't include any formatting the app might do.

Hope this helps

[clhambone]

Thanks

…

On Fri, Dec 1, 2023, 4:10 AM David Wiseman ***@***.***> wrote: There isn't a way to do this by the app but you could probably use Invoke-DbaQuery <https://docs.dbatools.io/Invoke-DbaQuery> with Export-Excel to accomplish this. The query used to generate the report in the app will have an associated stored procedure in the repository database you can run. This wouldn't include any formatting the app might do. Hope this helps — Reply to this email directly, view it on GitHub <#775 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BD2MFLWJ6AMKYHLWMCFNFS3YHGNKDAVCNFSM6AAAAABABNU7FWVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM3TOMRXGEYDG> . You are receiving this because you authored the thread.Message ID: ***@***.***>