automation tools
4 TopicsAutomating Power BI Viewer Role Assignment After Azure Purview Approval
Hello everyone! In my organization we use Azure Purview to manage access requests for our Power BI reports. Our current flow is: A user requests access to a data product (Power BI report) from Purview. I approve the request in the Purview portal. Although the user now has metadata-level access in Purview, to actually view the report they must click “Open in Power BI (Fabric)”—and that only works if I manually add them as Viewer to the workspace or app. This manual step is very tedious when there are dozens of requests per day. I’m looking for ideas to automate it so that, upon approval in Purview, the user is granted the Viewer role on the Power BI workspace/app for that report without any manual intervention. Has anyone implemented something similar or knows of an out-of-the-box approach? Perhaps a Purview extension (even in preview), third-party tool, or community solution that automates this provisioning? Thanks in advance for any pointers or examples!Solved230Views0likes5CommentsAutomation script for list out all resources
Hi all, This script will help you to list out all resources under you subscriptions. It's fully automation, in a single click you can get all resources details in you environment. How it's working: getting all subscription details, getting all resource group details under your subscription list out all resources one by one --------------------------------------------------------------------------------------------------------------- Automation Script: #Get Subscription count subcount=$(az account list --query [].name |jq '. |length') num=0 while [ $num -lt $subcount ] do #Getting Subscription ID subname=$(az account list --query [${num}].id -o tsv) #Getting Subscription Name subname1=$(az account list --query [${num}].name -o tsv) #setting up Subscription az account set --subscription $subname echo "$subname1" #Getting Resource Group count count=$(az group list --subscription $subname --query [].name | jq '. | length') number=0 while [ $number -lt $count ] do #Getting Resource Group Name name=$(az group list --subscription $subname --query [${number}].name -o tsv) echo " Resource Group Name= $name " #list out all resources az resource list --resource-group $name --query "[].{ResourceName:name, Type:type,CreationDate:createdTime}" --output table number=$(( number+1)) done num=$((num+1)) done --------------------------------------------------------------------------------------------------------------- Sample Output: Subscription name XXXXXXXXXXXXXXXXX Resource Group name XXXXXXXXXXXXX Resource Name Type CreationDate xxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx Resource Group Name XXXXXXXXXXXX Resource Name Type CreationDate xxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx Hope this will help, more query please ping me.904Views0likes0CommentsWhat are the best UI Test Automation Tools?
First published on MSDN on Nov 09, 2018 Authored by Edwin Hernandez Are you a Software Test Professional? If so, what test tool do you use? As most of people when they start in QA, you may have to become proficient with only one or two test tools because you are restricted to what is being used in your company, or what was best to test a specific application or perhaps because it aligned better with your teams' ALM tool stack.91KViews3likes2CommentsHow Do I - Run a PS Script automatically when Insert USB drive to verify credentials, start program?
I want to have a PowerShell script that runs automatically when I insert a USB drive. Here's exactly what I want to see happen: Step 1. -- Insert USB Step 2. -- A script runs automatically that pops up a window requesting I enter my credentials Step 3. -- Those credentials are verified against Active Directory Step 4. -- If the credentials are good, then a program is executed (let's say outlook.exe) Step 5. -- If the credentials are bad, it prompts me a maximum of 3 times before NOT running the program and displaying a bad credentials message or something to that effect. Info: The program (outlook or anything), PowerShell, and the script will all be on the USB drive. Please forgive me if something like this is already posted but I did a search and couldn't find exactly what I was looking for. Any help would be greatly appreciated and I promise to contribute when I become good at this. Thanks.5.3KViews0likes0Comments