Frequently used Azure powershell commands

Few of my frequently used powershell commands on Azure


# Login into Azure shell 
Select-AzureRmSubscription -SubscriptionName "SubscriptionName"

# All Logs 
Get-AzureRmSubscription | sort SubscriptionName | Select SubscriptionName
Select-AzureRmSubscription -SubscriptionName ContosoSubscription
Get-AzureRmLog -StartTime 2017-07-26T01:00  | Where-Object {$_.Authorization.Scope -like "*databases/DBNAME"} | Sort-Object EventTimestamp

# Creating and deleting Elastic pools in Azure environment
 $resourcegroupname = "SubscriptionName"
 $SubscriptionId = "SubscriptionID sf43rfe-dsf3reds-dfr3rd-dfedr433re"
 Select-AzureRmSubscription -SubscriptionId $SubscriptionId -ErrorAction Stop
 new-azurermsqlelasticpool -resourcegroupname $resourcegroupname -servername "myserverdr005"  -elasticpoolname "Server05-Pool04" -edition "standard" -dtu 200 -databasedtumin 0 -databasedtumax 100;
 Remove-AzureRmSqlElasticPool -resourcegroupname $resourcegroupname -servername "myserverdr005"  -elasticpoolname "Server05-Pool04" 

# Update Database information (Size Update)
 Login-AzureRmAccount # This statement can be avoided in CloudShell ( -> CloudShell)
$resourcegroupname = "resource-Group-Name"  
$SubscriptionId = "12121212-sdfdf-dfdfd-dfedffd-kdfck3kjnfhk"   
$DBNAme = "DBName"  
$ServerName = "SQLServerName"  
$dbsizeBytes = 268435456000 # 250 GB     

Select-AzureRmSubscription -SubscriptionId $SubscriptionId -ErrorAction Stop  
Set-AzureRmSqlDatabase -ResourceGroupName $resourcegroupname -DatabaseName $DBNAme -ServerName $ServerName -MaxSizeBytes $dbsizeBytes

# Update Elastic pool (Size Update)
$resourcegroupname = "Resource-group-name"
$SubscriptionId = "9374836468-ASDFJDF-DFK4-ASEFJJDF-JF4fedCDFD" 
$ElasticPoolName = "PoolX"
# $StorageMB = 307200  # 300 GB
$StorageMB = 204800  # 200 GB
Select-AzureRmSubscription -SubscriptionId $SubscriptionId -ErrorAction Stop
Set-AzureRmSqlElasticPool -ResourceGroupName $resourcegroupname -ServerName stmdbn2ac001 -ElasticPoolName $Elasticpoolname -StorageMB $StorageMB
# Note: Servername is included in the Update command, not as parameter 

## Restoring to point in time from Deleted Azure SQL Database : 

# List of all Alerts configured in given Resource Group
Get-AzureRmAlertRule -ResourceGroup "stratustime-prod-resource"  | Where-Object {$_.Name -like "Filter*"}  

# List of Disabled Alerts configured in given Resource Group
Get-AzureRmAlertRule -ResourceGroup "resourcegroupname"  | Where-Object {$_.Name -like "Filter*"}  

#Get-AzureRmAlertRule -ResourceGroup "resourcegroupname"  -DetailedOutput | Where-Object {$_.Name -like "FilterCriteria*" -and $_.Properties.Status -ne "Enabled"}  | select Name

# Find pending subscription reads - AzureRM 
Get-AzureRmResourceGroup -Name "ResourceGroupName" -Debug
# Enter option A; look for x-ms-ratelimit-remaining-subscription-reads value;

#Sample script for Point in time restore of a database from the server where the DB is deleted (Note: Restore time must be UTC time from where you run the command
$ResourceGroup = "MyResourceGroupName"
$SubscriptionId = "12315g6c-123a-1234-123a-1cb236ee456d"
$ServerName = "ServernameOnly"
$DatabaseName = "xxxxxxxxx"
$RestoredDatabaseName = "xxxxxx_Restored"
$DBEdition = "Standard"
$DBTier = "S0"
$RestoreTime = "2020-01-21 12:00" 
Login-AzureRmAccount -SubscriptionId $SubscriptionId
$DeletedDatabase = Get-AzureRmSqlDeletedDatabaseBackup -ResourceGroupName $ResourceGroup -ServerName $ServerName -DatabaseName $DatabaseName
Restore-AzureRmSqlDatabase -FromDeletedDatabaseBackup -DeletionDate $DeletedDatabase.DeletionDate -ResourceGroupName $DeletedDatabase.ResourceGroupName -ServerName $DeletedDatabase.ServerName -TargetDatabaseName $RestoredDatabaseName -ResourceId $DeletedDatabase.ResourceID -Edition $DBEdition -ServiceObjectiveName $DBTier -PointInTime $RestoreTime


This entry was posted in Azure, Powershell, Uncategorized and tagged , , , . Bookmark the permalink.

1 Response to Frequently used Azure powershell commands

  1. Pingback: catalog | Blog for reference – Vijred

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s