# TechGuy

> Service Management, Automation, PowerShell, Azure Automation, Logic Apps, and more


## Pages

- [Cookie Policy (EU)](https://www.techguy.at/cookie-policy-eu/)
- [Privacy Policy](https://www.techguy.at/datenschutzerklaerung/)
- [Webcast Terms](https://www.techguy.at/webcast-terms/)
- [Vembu - Partner Page](https://www.techguy.at/vembu-partner-page/)
- [PowerShell](https://www.techguy.at/powershell/)
- [System Center Orchestrator](https://www.techguy.at/system-center-orchestrator/)
- [System Center Service Manager](https://www.techguy.at/system-center-service-manager/)
- [System Center 2012 Data Protection Manager Buch](https://www.techguy.at/system-center-2012-data-protection-manager-buch/)
- [System Center Data Protection Manager](https://www.techguy.at/system-center-data-protection-manager/)
- [Hyper-V Server](https://www.techguy.at/hyper-v-server/)
- [EN Hyper-V Hints](https://www.techguy.at/hyper-v-server/en-hyper-v-hints/)
- [Subscribe](https://www.techguy.at/newsletter/)
- [Me](https://www.techguy.at/me/)
- [Newsletter Danke](https://www.techguy.at/newsletter-danke/)
- [Gewinnspiel Teilnahmebedingungen](https://www.techguy.at/gewinnspiel-teilnahmebedingungen/)
- [Partnerlinks](https://www.techguy.at/partnerlinks/)
- [](https://www.techguy.at/tgwiki/)
- [Linkfreitag](https://www.techguy.at/linkfreitag/)
- [Eine Seite](https://www.techguy.at/eine-seite/)
- [Impressum](https://www.techguy.at/impressum/)
- [Contact](https://www.techguy.at/kontakt/)



## Posts

- [IT Workflow Automation for SMBs: Simple, Secure, No Coding Required](https://www.techguy.at/workflow-automatisierung-mittelstand-2/)
- [IT Workflow-Automatisierung im Mittelstand: Einfach, sicher, ohne Code-Kenntnisse](https://www.techguy.at/workflow-automatisierung-mittelstand/)
- [IT Self-Service Portal for SMBs: Automation Without Admin Rights](https://www.techguy.at/it-self-service-portal-mittelstand-2/)
- [IT Self-Service Portal für den Mittelstand: Automatisierung ohne Admin-Rechte](https://www.techguy.at/it-self-service-portal-mittelstand/)
- [Azure Automation Self-Service Portal: Control IT Processes Without PowerShell Knowledge](https://www.techguy.at/azure-automation-self-service-portal-2/)
- [Azure Automation Self-Service Portal: IT-Prozesse ohne PowerShell-Kenntnisse steuern](https://www.techguy.at/azure-automation-self-service-portal/)
- [Delegating IT Processes Securely: How It Works Without Admin Rights](https://www.techguy.at/it-prozesse-delegieren-ohne-adminrechte-2/)
- [OneDrive offline Backup with PowerShell and GRAPH API](https://www.techguy.at/onedrive-offline-backup-with-powershell-and-graph-api/)
- [IT-Prozesse sicher delegieren: So funktioniert's ohne Admin-Rechte](https://www.techguy.at/it-prozesse-delegieren-ohne-adminrechte/)
- [External User Lifecycle Management: Automate External Accounts in AD and Azure AD](https://www.techguy.at/external-user-lifecycle-management-2/)
- [Disable IE for PowerShell Authentication Requests](https://www.techguy.at/disable-ie-for-powershell-authentication-requests/)
- [External User Lifecycle Management: Externe Benutzer automatisiert in AD und Azure AD verwalten](https://www.techguy.at/external-user-lifecycle-management/)
- [Automating Azure App Registration Lifecycle Management](https://www.techguy.at/azure-app-registration-lifecycle-management-2/)
- [Find unique SamAccountName and UPN for User Onboarding with the Help of AI](https://www.techguy.at/find-unique-samaccountname-and-upn-for-user-onboarding-with-the-help-of-ai/)
- [Using Azure Key Vault to store your Azure Automation Credentials and Secrets](https://www.techguy.at/using-azure-key-vault-to-store-your-azure-automation-credentials-and-secrets/)
- [Azure App Registration Lifecycle Management automatisieren](https://www.techguy.at/azure-app-registration-lifecycle-management/)
- [Monitor your Azure Secrets, Zerts and SPN's Expire Date with PowerShell - now with an Exclude List](https://www.techguy.at/monitor-your-azure-secrets-zerts-and-spns-expire-date-with-powershell-now-with-an-exclude-list/)
- [Active Directory Management Tools Compared: Delegation Without Admin Rights](https://www.techguy.at/active-directory-management-tools-vergleich-2/)
- [Active Directory Management Tools im Vergleich: Delegation ohne Admin-Rechte](https://www.techguy.at/active-directory-management-tools-vergleich/)
- [Behind the Scenes: Podcast Equipment and Automation Techniques](https://www.techguy.at/behind-the-scenes-podcast-equipment-and-automation-techniques/)
- [Hybrid PIM: Privileged Identity Management for On-Premises and Azure AD](https://www.techguy.at/hybrid-pim-azure-ad-on-premises-2/)
- [Hybrid PIM: Privileged Identity Management für On-Premises + Azure AD](https://www.techguy.at/hybrid-pim-azure-ad-on-premises/)
- [Mail Alerting on Azure Automation Accounts](https://www.techguy.at/mail-alerting-on-azure-automation-accounts/)
- [Run PowerShell via Web Interface: Delegation Without Admin Rights](https://www.techguy.at/powershell-web-interface-delegation-2/)
- [PowerShell über Web-Interface ausführen: Delegation ohne Admin-Rechte](https://www.techguy.at/powershell-web-interface-delegation/)
- [Create a Teams Appointment with MS GRAPH API and Powershell](https://www.techguy.at/create-a-teams-appointment-with-ms-graph-api-and-powershell/)
- [Send a OneDrive File via Mail with MS GRAPH API and Powershell](https://www.techguy.at/send-a-onedrive-file-via-mail-with-ms-graph-api-and-powershell/)
- [Create an Outlook Appointment with MS GRAPH API and Powershell](https://www.techguy.at/create-an-outlook-appointment-with-ms-graph-api-and-powershell/)
- [Use Freshdesk API with PowerShell](https://www.techguy.at/user-freshdesk-api-with-powershell/)
- [Draft Mail with PowerShell and Microsoft Graph API](https://www.techguy.at/draft-mail-with-powershell-and-microsoft-graph-api/)
- [Upload a File to OneDrive via Graph API and PowerShell](https://www.techguy.at/upload-a-file-to-onedrive-via-graph-api-and-powershell/)
- [MS Graph API Paging Function](https://www.techguy.at/ms-graph-api-paging-function/)
- [Build dynamic JSON with PowerShell](https://www.techguy.at/build-dynamic-json-with-powershell/)
- [Another Breaking Change in Agent-based Azure Hybrid Worker](https://www.techguy.at/another-breaking-change-in-agent-based-azure-hybrid-worker/)
- [1-Year Notion, or how au2mator is doing internal automation.](https://www.techguy.at/1-year-notion-or-how-au2mator-is-doing-internal-automation/)
- [Create and delete Azure App Regs - Manage Azure App Reg with PowerShell and MSGRAPH API - Part 1](https://www.techguy.at/create-and-delete-azure-app-regs-manage-azure-app-reg-with-powershell-and-msgraph-api-part-1/)
- [Control Secrets in Azure App Reg - Manage Azure App Reg with PowerShell and MSGRAPH API - Part 2](https://www.techguy.at/control-secrets-in-azure-app-reg-manage-azure-app-reg-with-powershell-and-msgraph-api-part-2/)
- [Add and Remove Permission in Azure App Reg - Manage Azure App Reg with PowerShell and MSGRAPH API - Part 3](https://www.techguy.at/add-and-remove-permission-in-azure-app-reg-manage-azure-app-reg-with-powershell-and-msgraph-api-part-3/)
- [Runbooks not visible in SCO API](https://www.techguy.at/runbooks-not-visible-in-sco-api/)
- [Control Azure VM with PowerShell and Azure REST API](https://www.techguy.at/control-azure-vm-with-powershell-and-azure-rest-api/)
- [Find unique SamAccountName and UPN for User Onboarding in AD with PowerShell](https://www.techguy.at/find-unique-samaccountname-and-upn-for-user-onboarding-in-ad-with-powershell/)
- [Delete a Secret from an Azure Application Registration with PowerShell and MS GRAPH API](https://www.techguy.at/delete-a-secret-from-an-azure-application-registration-with-powershell-and-ms-graph-api/)
- [Add a Secret to an Azure Application Registration with PowerShell and MS GRAPH API](https://www.techguy.at/add-a-secret-to-an-azure-application-registration-with-powershell-and-ms-graph-api/)
- [Create an Azure App Registration with PowerShell and MS GRAPH API](https://www.techguy.at/create-an-azure-app-registration-with-powershell-and-ms-graph-api/)
- [Orchestrator SQL Query to query a specific String in .Net Acticity](https://www.techguy.at/orchestrator-sql-query-to-query-a-specific-string-in-net-acticity/)
- [Upcoming Speaker Engagements](https://www.techguy.at/upcoming-speaker-engagements/)
- [Add an Owner to an Azure Application Registration with PowerShell and MS GRAPH API](https://www.techguy.at/add-an-owner-to-an-azure-application-registration-with-powershell-and-ms-graph-api/)
- [Remove a User from an Azure Resource Group Role with PowerShell and Azure Rest API](https://www.techguy.at/remove-a-user-from-an-azure-resource-group-role-with-powershell-and-azure-rest-api/)
- [Get all your Azure Enterprise Apps with Owner and Usage Count](https://www.techguy.at/get-all-your-azure-enterprise-apps-with-owner-and-usage-count/)
- [PSCONF EU: Use PowerShell to read Inbox and draw a contest Winner](https://www.techguy.at/psconf-eu-use-powershell-to-read-inbox-and-draw-a-contest-winner/)
- [Monitor your Azure Secrets, Zerts and SPN's Expire Date with PowerShell](https://www.techguy.at/monitor-your-azure-secrets-zerts-and-spns-expire-date-with-powershell/)
- [Assign a User to an Azure Resource Group Role with PowerShell and MS Graph API](https://www.techguy.at/assign-a-user-to-an-azure-resource-group-role-with-powershell-and-ms-graph-api/)
- [Remove Azure Resource Group with PowerShell and MS Graph API](https://www.techguy.at/remove-azure-resource-group-with-powershell-and-ms-graph-api/)
- [Update all PowerShell Modules with one Script](https://www.techguy.at/update-all-powershell-modules-with-one-script/)
- [Migrate System Center Orchestrator in an au2mator Environment](https://www.techguy.at/migrate-system-center-orchestrator-in-an-au2mator-environment/)
- [Create Azure Resource Group with PowerShell and MS Graph API](https://www.techguy.at/create-azure-resource-group-with-powershell-and-ms-graph-api/)
- [PowerShell Mapping Function](https://www.techguy.at/powershell-mapping-function/)
- [Change SCSM Report Server URL to HTTPS](https://www.techguy.at/change-scsm-report-server-url-to-https/)
- [Create Azure Guest User with PowerShell and MS Graph API](https://www.techguy.at/create-azure-guest-user-with-powershell-and-ms-graph-api/)
- [Change a Teams Member to an Owner with PowerShell and MS Graph API](https://www.techguy.at/change-a-teams-member-to-an-owner-with-powershell-and-ms-graph-api/)
- [Change a Teams Owner to a Member with PowerShell and MS Graph API](https://www.techguy.at/change-a-teams-owner-to-a-member-with-powershell-and-ms-graph-api/)
- [Create a Channel in Teams with PowerShell and MS Graph API](https://www.techguy.at/create-a-channel-in-teams-with-powershell-and-ms-graph-api/)
- [Remove a Member from a Microsoft Teams Team with PowerShell and MS Graph API](https://www.techguy.at/remove-a-member-from-a-microsoft-teams-team-with-powershell-and-ms-graph-api/)
- [How to update every single Active Directory User Attributes with Powershell - Part 4](https://www.techguy.at/how-to-update-every-single-active-directory-user-attributes-with-powershell-part-4/)
- [Add a Member to a Microsoft Teams Team with PowerShell and MS Graph API](https://www.techguy.at/add-a-member-to-a-microsoft-teams-team-with-powershell-and-ms-graph-api/)
- [How to update every single Active Directory User Attributes with Powershell - Part 3](https://www.techguy.at/how-to-update-every-single-active-directory-user-attributes-with-powershell-part-3/)
- [How to update every single Active Directory User Attributes with Powershell - Part 2](https://www.techguy.at/how-to-update-every-single-active-directory-user-attributes-with-powershell-part-2/)
- [How to update every single Active Directory User Attributes with Powershell - Part 1](https://www.techguy.at/how-to-update-every-single-active-directory-user-attributes-with-powershell-part-1/)
- [Speed up SCSM and SCO Workflows](https://www.techguy.at/speed-up-scsm-and-sco-workflows/)
- [Use PowerShell to query your Bosch Home Connect Devices](https://www.techguy.at/use-powershell-to-query-your-bosch-home-connect-devices/)
- [PowerShell Script to trigger Orchestrator Runbook](https://www.techguy.at/powershell-script-to-trigger-orchestrator-runbook/)
- [Add a Page to a Notion Database with PowerShell](https://www.techguy.at/add-a-page-to-a-notion-database-with-powershell/)
- [Work with NOTION API and PowerShell](https://www.techguy.at/work-with-notion-api-and-powershell/)
- [Pagination with Notion API and PowerShell](https://www.techguy.at/pagination-with-notion-api-and-powershell/)
- [Transfer German Umlaute with Invoke-RestMethod](https://www.techguy.at/transfer-german-umlaute-with-invoke-restmethod/)
- [SQL Query to get Runbook and Parameter ID from SQL - System Center Orchestrator](https://www.techguy.at/sql-query-to-get-runbook-and-parameter-id-from-sql-system-center-orchestrator/)
- [Remove duplicate Managers from SCSM User](https://www.techguy.at/remove-duplicate-managers-from-scsm-user/)
- [Enable Lost Mode for Intune Device with PowerShell and Microsoft Graph API](https://www.techguy.at/enable-lost-mode-for-intune-device-with-powershell-and-microsoft-graph-api/)
- [PowerShell custom Install Module Function](https://www.techguy.at/powershell-custom-install-module-function/)
- [Query Azure SQL Database with PowerShell and Azure App Registration](https://www.techguy.at/query-azure-sql-database-with-powershell-and-azure-app-registration/)
- [This was PDC Conf 2021](https://www.techguy.at/this-was-pdc-conf-2021/)
- [Send Mail with Attachment, PowerShell, and Microsoft Graph API](https://www.techguy.at/send-mail-with-attachment-powershell-and-microsoft-graph-api/)
- [Create Microsoft ToDo Task with PowerShell and Microsoft GRAPH API](https://www.techguy.at/create-microsoft-todo-task-with-powershell-and-microsoft-graph-api/)
- [Create an Azure VM with Azure REST API with PowerShell](https://www.techguy.at/create-an-azure-vm-with-azure-rest-api-with-powershell/)
- [Temporarily Add a User to a Group with Active Directory Privileged Access Management Feature](https://www.techguy.at/temporarily-add-a-user-to-a-group-with-active-directory-privileged-access-management-feature/)
- [Set Out of Office Reply with PowerShell and MS GRAPH API](https://www.techguy.at/set-out-of-office-reply-with-powershell-and-ms-graph-api/)
- [Backup and Restore Last Modified Date for SCSM Change Requests](https://www.techguy.at/backup-and-restore-last-modified-date-for-scsm-change-requests/)
- [PowerShell BackupScript Version 2.0 released](https://www.techguy.at/powershell-backupscript-version-2-0-released/)
- [Assign Windows 365 License with PowerShell and MS GRAPH API](https://www.techguy.at/assign-windows-365-license-with-powershell-and-ms-graph-api/)
- [Squared Up Dashboard Server](https://www.techguy.at/squared-up-dashboard-server/)
- [Send Chat Message to a Teams Channel with PowerShell and MS GRAPH API](https://www.techguy.at/send-chat-message-to-a-teams-channel-with-powershell-and-ms-graph-api/)
- [Send CARD Message to a Teams Channel with PowerShell and MS GRAPH API](https://www.techguy.at/send-card-message-to-a-teams-channel-with-powershell-and-ms-graph-api/)
- [Create Microsoft Team with PowerShell and MS Graph API](https://www.techguy.at/create-microsoft-team-with-powershell-and-ms-graph-api/)
- [Send Mail with PowerShell and Microsoft Graph API](https://www.techguy.at/send-mail-with-powershell-and-microsoft-graph-api/)
- [Use Rebrandly API with PowerShell](https://www.techguy.at/use-rebrandly-api-with-powershell/)
- [Query SQL with PowerShell without a Module](https://www.techguy.at/query-sql-with-powershell-without-a-module/)
- [Query Lenovo Warranty Information with PowerShell](https://www.techguy.at/query-lenovo-warranty-information-with-powershell/)
- [PowerShell Logging Function](https://www.techguy.at/powershell-logging-function/)
- [Control Pipedrive CRM with PowerShell - Start and connect](https://www.techguy.at/control-pipedrive-crm-with-powershell-start-and-connect/)
- [Upload Profile Photo with MS Graph API to Azure AD](https://www.techguy.at/upload-profile-photo-with-ms-graph-api-to-azure-ad/)
- [Migrate Orchestrator Server in an SCSM Environment](https://www.techguy.at/migrate-orchestrator-server-in-an-scsm-environment/)