Frequently used Azure powershell commands

Few of my frequently used powershell commands on Azure

#


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


# All Logs 
Login-AzureRmAccount
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
 Login-AzureRmAccount
 $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 (https://portal.azure.com -> 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)
Login-AzureRmAccount
 
$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 : https://vijredblog.wordpress.com/2018/05/23/how-to-point-in-time-restore-azure-sql-database-after-deleting-the-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




Ref:
https://docs.microsoft.com/en-us/azure/search/search-manage-powershell

Advertisements
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

w

Connecting to %s