Forum Widgets
Latest Discussions
RateCard API - Disk Meters
Hello, Did you use RateCard API to get information about the cost of Managed Disks? I found some problems with find differences between LRS and ZRS. {'EffectiveDate': '2021-02-01T00:00:00Z', 'IncludedQuantity': 0.0, 'MeterCategory': 'Storage', 'MeterId': '32d2a836-3069-5c59-aa89-5fd8703e5b4d', 'MeterName': 'P70 Disks', 'MeterRates': {'0': 2279.532663}, 'MeterRegion': 'EU North', 'MeterStatus': 'Active', 'MeterSubCategory': 'Premium SSD Managed Disks', 'MeterTags': [], 'Unit': '1/Month'} {'EffectiveDate': '2019-05-01T00:00:00Z', 'IncludedQuantity': 0.0, 'MeterCategory': 'Storage', 'MeterId': 'ae33b259-d35e-422e-8b76-a3c8435fb894', 'MeterName': 'P70 Disks', 'MeterRates': {'0': 1519.677198}, 'MeterRegion': 'EU North', 'MeterStatus': 'Active', 'MeterSubCategory': 'Premium SSD Managed Disks', 'MeterTags': [], 'Unit': '1/Month'} Two meters are similar, the only differences are Id, Date and price. The API returns good prices but does not describe the type. Regards, Mateusz
Blueprint as code from scratch
Hi, I want to create blueprint as code from scratch. There isn't proper documentation about this issue. I have read and test templates from github. Articles are not so advanced. There isn't any visual studio 2019 templat for blueprint. Any advice / document suggestion would be appreciated. Best Jasmine
connectivity issues with Azure SQL Database
error messages when the connection to Azure SQL Database or Azure SQL Managed Instance fails. These connection problems can be caused by reconfiguration, firewall settings, a connection timeout, incorrect login information' Use Below Power Shell Code to detect connection issue. $parameters = @{ # Supports Single, Elastic Pools and Managed Instance (please provide FQDN, MI public endpoint is supported) # Supports Azure Synapse / Azure SQL Data Warehouse (*.sql.azuresynapse.net / *.database.windows.net) # Supports Public Cloud (*.database.windows.net), Azure China (*.database.chinacloudapi.cn), Azure Germany (*.database.cloudapi.de) and Azure Government (*.database.usgovcloudapi.net) Server = '.database.windows.net' # or any other supported FQDN Database = '' # Set the name of the database you wish to test, 'master' will be used by default if nothing is set User = '' # Set the login username you wish to use, 'AzSQLConnCheckerUser' will be used by default if nothing is set Password = '' # Set the login password you wish to use, 'AzSQLConnCheckerPassword' will be used by default if nothing is set ## Optional parameters (default values will be used if omitted) SendAnonymousUsageData = $true # Set as $true (default) or $false RunAdvancedConnectivityPolicyTests = $true # Set as $true (default) or $false, this will load the library from Microsoft's GitHub repository needed for running advanced connectivity tests CollectNetworkTrace = $true # Set as $true (default) or $false #EncryptionProtocol = '' # Supported values: 'Tls 1.0', 'Tls 1.1', 'Tls 1.2'; Without this parameter operating system will choose the best protocol to use } $ProgressPreference = "SilentlyContinue"; if ([string]::IsNullOrEmpty($parameters.RepositoryBranch)) { $branch = 'master' } else { $branch = $parameters.RepositoryBranch } if ("AzureKudu" -eq $env:DOTNET_CLI_TELEMETRY_PROFILE) { $scriptFile = '/ReducedSQLConnectivityChecker.ps1' } else { $scriptFile = '/AzureSQLConnectivityChecker.ps1' } $scriptUrlBase = 'raw.githubusercontent.com/Azure/SQL-Connectivity-Checker/' + $branch Invoke-Command -ScriptBlock ([Scriptblock]::Create((Invoke-WebRequest ($scriptUrlBase + $scriptFile) -UseBasicParsing).Content)) -ArgumentList $parameters #end
Azure AD Provisioning with Salesforce. Attribute with the Application Groups that a user belong
Hi, I have SSO between Salesforce and Azure AD using Salesforce App available in Azure. I'm also using provisioning to create the users in Salesforce. Everything works fine, but I need another field to pass to Salesforce: The Application Groups that the user belongs. It is possible to add a field to the User in Azure AD with this information and mapping it in Provisioning -> Attribute Mapping ? Let's say something similar with SingleAppRoleAssignment([appRoleAssignments]), but with all the groups that the user belong regarding only this particular Application. For user provisioning I have created several groups in the app. For each group I assign a role(profile in Salesforce). Then I assign users to the specific groups. The provisioning start and I also want to send the group(s) that the user is member.
Azure Logic App JSON Array Data Operation
We have a scenario where we are getting an JSON array response from Hubspot webhook Ex- this JSON array may have length upto 40 or 50. Now I want to check if 'subscriptionType' contains 'company' then set variable 'Iscompany' to 'true' else If 'subscriptionType' contains 'contact' then set variable 'Iscontact' to 'true' else if 'subscriptionType' contains 'company' and 'contact' then set variable 'Iscompany' and 'Iscontact' to 'true'. Example- Now the problem is this - suppose if there is length of JSON array is 40 or 50 and we got our variables 'IsContact' and 'IsCompany' is set to 'True' in its first 2 or 3 iterations so why do i check in full array? Is there any alternate way to achieve this logic- if 'subscriptionType' contains 'company' then set variable 'Iscompany' to 'true' else If 'subscriptionType' contains 'contact' then set variable 'Iscontact' to 'true' else if 'subscriptionType' contains 'company' and 'contact' then set variable 'Iscompany' and 'Iscontact'. like if JSON Body contains 'company' or 'contact' as value of keys then set variables to true or false.Can we run azure functions locally in VSCode without admin rights
Whenever I tried to debug the azure functions locally in vscode, a dialog box appears and it asks to install azure function core tools. After installing, it throws an error as Unable to import azure.functions pylint(import-error). When I tried to debug one more time without modifying anything, it is asking to install azure function core tools again. I don't understand why it is asking multiple times to install azure function core tools and also also why it is throwing error as could not import azure.functions. Please help on this. I am trying the above steps as a local user. If I tried to do using admin user, it is working.
Logic Apps: Value mapping (key-value pair) - XML Transformation
Hi all, I have just started with Logic Apps. My first app is running. It contains a XML transformation (XSLT3). Within the XSLT I have to map some values. My first approach was to put this mapping values as xsl:map into the stylesheet. Works fine. Actually, I want this part to be more flexible. I am looking for something where I can store the value mapping table, which can be easily changed, e.g. a separate XML which will be passed to the XSLT (xsl:params) or parameters from the app. I was wondering if you can point me to the right direction what can be used for that. Thank you in advance Seb
