Mauricio Zaragoza MauricioZa
MauricioZa
/ MauAzureBatchAdministrator.json
Created
November 12, 2021 20:12
Azure custom role to create and administer Azure Batch spaces
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "id": "/subscriptions/5141f008-b6ee-4e54-9792-75a237e1c9c1/providers/Microsoft.Authorization/roleDefinitions/e98dcac9-41d1-4a6e-a776-d7abd69f71b9", | |
| "properties": { | |
| "roleName": "Mau Batch Administrator", | |
| "description": "Mau Batch Administrator", | |
| "assignableScopes": [ | |
| "/subscriptions/5141f008-b6ee-4e54-9792-75a237e1c9c1/resourcegroups/rg-batch" | |
| ], | |
| "permissions": [ | |
| { |
MauricioZa
/ TestDatabricksRole.ps1
Created
September 28, 2021 15:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # ------------------------------------------ | |
| # VARIABLES | |
| # ------------------------------------------ | |
| $NetworkRG = "Network" | |
| $DatabricksRG = "Databricks" | |
| $virtualNetworkName = "vn-databricks" | |
| # ------------------------------------------ | |
| # AUTHENTICATION |
MauricioZa
/ MauDatabricksWorkspaceContributor.json
Created
September 28, 2021 15:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "id": "/subscriptions/5141f008-b6ee-4e54-9792-75a237e1c9c1/providers/Microsoft.Authorization/roleDefinitions/8f259318-a77e-4117-ab47-9de16ed8dd0a", | |
| "properties": { | |
| "roleName": "Mau Databricks Workspace Contributor", | |
| "description": "Can create Databricks Workspaces with the principle of least privilege", | |
| "assignableScopes": [ | |
| "/subscriptions/5141f008-b6ee-4e54-9792-75a237e1c9c1" | |
| ], | |
| "permissions": [ | |
| { |
MauricioZa
/ allResourcesExceptHidden
Created
May 4, 2021 15:29
Graph query to retrieve ALL resources (excluding hidden)
MauricioZa
/ allResources.txt
Created
May 4, 2021 15:26
Graph query to retrieve ALL resources (including hidden)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| resources|where (resourceGroup =~ ('rg-INSERT-YOUR-RG-NAME-HERE'))|extend typeDisplayName=case( | |
| type =~ 'microsoft.insights/components','Application Insights', | |
| type =~ 'microsoft.insights/privatelinkscopes','Azure Monitor Private Link Scope', | |
| type =~ 'microsoft.insights/webtests','Availability test', | |
| type =~ 'microsoft.insights/workbooks','Azure Workbook', | |
| type =~ 'microsoft.insights/workbooktemplates','Azure Workbook Template', | |
| type =~ 'microsoft.appplatform/spring','Azure Spring Cloud', | |
| type =~ 'microsoft.appplatform/tanzu','Azure Spring Cloud', | |
| type =~ 'microsoft.cache/redisenterprise','Redis Enterprise', | |
| type =~ 'microsoft.cache/redisenterprise/databases','Cache', |
MauricioZa
/ MariaDBconfigTable.csv
Last active
April 1, 2021 13:49
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Subscription_name | Subscription_ID | Databases_Resouce_Group_Name | Storage_account_name | Storage_account_resource_group | Notes | |
|---|---|---|---|---|---|---|
| Mauricio Zaragoza AIA | 9dete535-38c6-45ec-ab26-a0fc132f4b4a | rg-Joseph-MariaDB | josephmariadb | rg-Joseph-MariaDB | First subscription | |
| Mauricio Zaragoza AIA | 9dete535-38c6-45ec-ab26-a0fc132f4b4a | rg-Joseph-MariaDB2 | josephmariadb2 | rg-Joseph-MariaDB2 | second subscription |
MauricioZa
/ New-MariaDBMonitoringConfiguration.ps1
Created
April 1, 2021 13:48
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| .SYNOPSIS | |
| Enables Diagnostic Settings Audit Logs and Slow Query Logs for MariaDB servers and output to Storage Account | |
| .DESCRIPTION | |
| Enables Diagnostic Settings Audit Logs and Slow Query Logs for MariaDB servers and output to Storage Account | |
| .PARAMETERS | |
| All parameters are requested interactively | |
| .EXAMPLE | |
| .\New-MariaDBMonitoringConfiguration.ps1 | |
| .OUTPUTS |
MauricioZa
/ configTable.csv
Last active
March 30, 2021 20:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Subscription_name | Subscription_ID | Compute_Resource_group_name | Storage_account_name | Storage_account_resource_group | Notes | |
|---|---|---|---|---|---|---|
| MySubscription | 1234fbd5-38c6-45ec-ab26-a0fc132f4b4a | rg-Joseph | linux78 | rg-Joseph | First subscription | |
| EnterprisePRD | 8769876 | rg-2 | storage2 | rg-srotage2 | secon subs |
MauricioZa
/ new-AzureTableMonitoringLinuxConfigWithCsv.ps1
Last active
March 30, 2021 20:33
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Global variables | |
| $configTableFilePath = "Z:\Mauricio\E\Trabajo\Microsoft\CSA\CAMS\C-AMS monitoring\configTable.csv" | |
| $publicSettingsFilePath = "Z:\Mauricio\E\Trabajo\Microsoft\CSA\CAMS\C-AMS monitoring\publicSettings.json" | |
| $protectedSettingsFilePath = "Z:\Mauricio\E\Trabajo\Microsoft\CSA\CAMS\C-AMS monitoring\protectedSettings.json" | |
| # Connect | |
| #Connect-AzAccount | |
| # Read the table |
MauricioZa
/ New-VMAsrProtectionForKurt.ps1
Last active
March 29, 2021 13:19
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # --------------------------------------------------------- | |
| # Sign in to your Microsoft Azure subscription | |
| # --------------------------------------------------------- | |
| Connect-AzAccount | |
| #VM subscription | |
| Set-AzContext -SubscriptionId "fd8bab10-c92e-474d-8e64-0474b8980ec8" | |