This ARM template deploys an automated monitoring solution for Azure Arc-enabled SQL Servers. It monitors the health status of SQL Server data uploads to Azure and alerts when servers fail to upload metrics successfully.
| management.azure.com | |
| login.microsoftonline.com | |
| gbl.his.arc.azure.com | |
| packages.microsoft.com | |
| download.microsoft.com |
| # yaml-language-server: $schema=https://aka.ms/configuration-dsc-schema/0.2 | |
| properties: | |
| resources: | |
| - resource: HyperVDsc/VMHyperV | |
| id: ArcBox-Win2K25 | |
| directives: | |
| description: Configure VM ArcBox-Win2K25 | |
| settings: | |
| Name: ArcBox-Win2K25 |
| # Reports workspces with legacy data sources confgiured to be migrated to Azure Monitor Data Collection Rules | |
| # set your tenant id | |
| $TenantID = 'XXXX' | |
| $Context = Connect-AzAccount -Tenant $TenantID | |
| # Get the access token for the management API | |
| $Token = (Get-AzAccessToken -ResourceUrl 'https://management.azure.com/').Token | |
| $DataSourceKinds = @('WindowsEvent', 'WindowsPerformanceCounter', 'LinuxPerformanceObject','LinuxSyslog','IISLogs') | |
| $Headers = @{Authorization = "Bearer $Token"} |
| # !!!!!!! Use with -whatif first to verify the the correct routes to be deleted. !!!!!!! | |
| [CmdletBinding( | |
| SupportsShouldProcess = $true, | |
| ConfirmImpact = 'High' | |
| )] | |
| Param( | |
| $TenantID = 'xxxxx-xxxxx-xxxx-xxxxx-xxxxx', | |
| $Subscription = 'Subscription Name', | |
| $RouteTable = 'RouteTable name', |
| # Define the port number to listen on | |
| # specify the port and run the script on your target server before installing server software, then from your client test the port connection. | |
| param( | |
| [int]$port = 7070 | |
| ) | |
| # Create a new TCP listener | |
| $listener = [System.Net.Sockets.TcpListener]::new([System.Net.IPAddress]::Any, $port) | |
| # Start the listener |
| # sets the ip address of local gateway connection to the public ip where the script runs. I use this script to update my lab connection to the dynamic public ip of my home router. | |
| #requires -Modules Az.Accounts, Az.Network | |
| # Specify the Resource Group Name and Gateway Name | |
| $resourceGroupName = 'rg-con-prd-001' | |
| $gatewayName = 'lng-con-vpn-001' | |
| $TenantID= 'xxxxx' | |
| $SubscriptionID = 'yyyyy' | |
| # Requires Azure PowerShell module |
| # sets the proxy of all azure monitor agent for arc agents. | |
| $ProxyAdress = "http://yourproxy:portnumber" | |
| # the defaults settings below are for anonymous proxy authentication. Read the comments and set as necessary. | |
| # leave the username and password as is if you dont use them. | |
| $UserName = 'Username' | |
| $PassWord = 'Password' |
| $source = "xxxxz" | |
| $Params = @("vvv","zzz") | |
| $Message = "Something happend to {0}, and another thing happened to {1}" -f $Params[0],$Params[1] | |
| $ResultantArray = @($Message) | |
| $Params | ForEach-Object { | |
| $ResultantArray += $_ | |
| } | |
| if (![System.Diagnostics.EventLog]::SourceExists($source)) { | |
| [System.Diagnostics.EventLog]::CreateEventSource($source, "Application") |
| # run: python Get-ResoursoucesToMove.py <directory that includes tf files> <csvPath> | |
| import os | |
| import hcl2 | |
| import csv | |
| import sys | |
| # Check if the correct number of arguments is provided | |
| if len(sys.argv) != 3: | |
| print("Usage: python script_name.py <directory> <csvPath>") | |
| sys.exit(1) |