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


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

One 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