azure automation
91 TopicsConvert a text string to a correct date time format
Hello folks, I have maybe a simple question for the experienced people around here 🙂 . I have a runbook in azure that is getting the field "CreatedDateTime" of a unified group (Teams Team). The format of this field ist like the following "2020-08-06T06:03:19Z". This is not recognized as a valid DateTime format by the cmdlet: $DateTime=[Datetime]::ParseExact($DateTime, 'MM/dd/yyyy', $null) Can anyone point me to a solution how to get the string "2020-08-06T06:03:19Z" into a string like "2020-08-06" or "06-08-2020". Every hint is appreciated. Thank you all 😉Solved38KViews0likes4CommentsUsing the new Quota REST API
Do you want to automate quota management to improve agility, developer velocity, and efficiency in IT operations? In this blog post, get a brief overview of the newly released Quota REST API and a step-by-step walkthrough for learning how to use it when you reach a quota limit.Compare two csv files
Hello I am trying to get an idea of devices that have not enrolled in Intune, but are accessing exchange online. I am using two .csv files. The intune file contains all devices that have enrolled in intune and the Exchange file contains all devices that are currently found in Exchange online. I want to compare the two files and export the differences to another .csv file. The two files share a common attribute "deviceid" Thank you in advance for any guidance $Intune = import-csv .\intune.csv | Group-Object -AsHashTable -AsString -Property 'DeviceID' $Exchange = import-csv .\mobiledevicereport.csv | Group-Object -AsHashTable -AsString -Property 'DeviceID'Solved22KViews0likes2CommentsInstall-Module MSOnline - not working
Hi all, I am struggling to install: Install-Module MSOnline I get: I have tried: Get-PSRepository WARNING: Unable to find module repositories. When I run: Register-PSRepository -Default I get no error but when trying to run Get-PSRepository again i get WARNING: Unable to find module repositories. Any ideas on how to fix this?Solved21KViews0likes1CommentInvoke-Sqlcmd with Azure Automation for Azure SQL database
In this blog article, we will be illustrating the required steps to use Invoke-Sqlcmd against an Azure SQL database from Azure Automation. We have received a few cases where customers would like to automate a specific script to be executed on their Azure SQL database like select, update, insert or delete.21KViews3likes2CommentsSend message to Teams from Azure Function or Azure Automation
I put together two videos that show how to send a message to Microsoft Teams whenever a specified resource is created in an Azure Subscription. One using Azure Functions, the other Azure Automation. Short blog post and link to the videos below. https://www.ciraltos.com/azure-automation-azure-functions-teams-and-event-grid/18KViews1like0Comments