Dec 17 2021 10:37 AM
Hello,
My script outputs the format as follows:
Subscription Name : DEV
Resource Group : use2-dev-rg
SQL Server Name : dev-rg-sql
DataBase Name : devrg
Creation Date : 10/22/2020 2:33:11 PM
The output above is cutoff as there are multiple resource groups. I'd like for it to be columnar with Subscription Name, Resource Group, etc as the heading.
This is the script for output:
$dateString = (Get-Date).ToString("yyyyMMdd")
$fileName = ("AzrSQLDatabases_" + $SubscriptionName + "_" + $dateString + ".xls")
$AzureSQLBackupInventory | Out-File ("C:\Temp\" + $fileName)
Thanks in advance for your help!
Dec 20 2021 10:19 PM