The following script outputs a CSV in the Runbook console but what exactly must I add to my script to export/redirect the CSV output to a file to export in my storage account blob container?
$connectionName = "AzureRunAsConnection"
try
{
# Get the connection "AzureRunAsConnection "
$servicePrincipalConnection=Get-AutomationConnection -Name $connectionName
Connect-AzAccount `
-ServicePrincipal `
-TenantId $servicePrincipalConnection.TenantId `
-ApplicationId $servicePrincipalConnection.ApplicationId `
-CertificateThumbprint $servicePrincipalConnection.CertificateThumbprint
}
catch {
if (!$servicePrincipalConnection)
{
$ErrorMessage = "Connection $connectionName not found."
throw $ErrorMessage
} else{
Write-Error -Message $_.Exception
throw $_.Exception
}
}
$a = "------------------------------------------------------------------------------------------------------------------"
$vnetObjs = Get-AzVirtualNetwork
foreach ($vnetobj in $vnetObjs) {
$resultvNet = "vNet Name: " + $vnetObj.Name
$resultvNet
$resultPeering = "Peering: " + (Get-AzVirtualNetworkPeering -Name "*" -VirtualNetwork $vnetObj.Name -ResourceGroupName $vnetobj.ResourceGroupName | Select-Object -ExpandProperty Name)
$resultPeering
if ($vnetobj.DhcpOptions.DnsServers){
$resultDNS = "DNS Server: " + $vnetobj.DhcpOptions.DnsServers
}
else {
$resultDNS = "DNS Server: Azure Default"
}
$resultDNS
$resultIPAddress = $vnetobj | Get-AzVirtualNetworkSubnetConfig | Select-Object Name,AddressPrefix
$resultIPAddress
$a
}
foreach ($user in $users){
write $user
$user | export.csv $FileName -NoTypeInformation -Append
}
$StorageURL = "https://test.blob.core.windows.net/testtesttestet01/"
$FileName = "export.csv"
$SASToken = "xx=xxxxx=xxxxx-xx-20T15:22:29Z&se=2022-07-01T23:22:29Z&sv=xxxx-xx-10&sr=c&sig=SwBLIW%2FEfmjeNjMUHtPsO6Ad2frC8egXNwEPvN6h8gY%3D"
$blobUploadParams = @{
URI = "{0}/{1}?{2}" -f $StorageURL, $FileName, $SASToken
Method = "PUT"
Headers = @{
'x-ms-blob-type' = "BlockBlob"
'x-ms-blob-content-disposition' = "attachment; filename=`"{0}`"" -f $FileName
'x-ms-meta-m1' = 'v1'
'x-ms-meta-m2' = 'v2'
}
Body = $Content
Infile = $FileToUpload
}