Most of you should be aware of “Invoke-SQLCMD” to run a SQL Query to a SQL Server and get the Result in PowerShell. Invoke-SQLCMD needs to be installed with the PowerShell Module SQLServer. But what to do when you cannot install the Module or even need to run a SQL Query in System Center Orchestrator, […]
Query SQL with PowerShell without a Module Read More »
I am using Pipedrive as my CRM System, and I use a lot of PowerShell Scripts to automate all things related to my Customers. In this Blog Post, I want to show you how to connect your PowerShell to Pipedrive API and invoke the first Web Request. API Details To connect our PowerShell Script to
Control Pipedrive CRM with PowerShell – Start and connect Read More »
Here I want to show you an example on how to upload a Profile Photo to your Azure AD Account with PowerShell and Graph API If you are new to MS Graph API, I would recommend reading this Posts on my Blog: Use Microsoft Graph API with PowerShell – Part 1 » TechGuy Preparation As
Upload Profile Photo with MS Graph API to Azure AD Read More »
This Article will show, how to migrate a System Center Orchestrator Server to a new Machine, when connected to a System Center Service Manager Server. So the Challenge is. To keep the Runbook ID and change the Orchestrator SCSM Connector to the new URL otherwise, SCSM will sync each Runbook again, and you need to
Migrate Orchestrator Server in an SCSM Environment Read More »
I have written a Blog Series, on how to use Microsoft Graph REST API Part 1 – Authentication and Azure App – Use Microsoft Graph API with PowerShell – Part 1 » TechGuyPart 2 – Oauth2.0 – Use Microsoft Graph API with PowerShell – Part 2 » TechGuyPart 3 – First Powershell Script to get a Teams
Paging in Microsoft Graph REST API Read More »
Last year I bought a new Lawn Mower, a Husqvarna 435x AWD. The best thing, besides he is doing an awesome job in our Garden, there is an API to include the Mower in our Home Automation. That fact brought me to an Idea, can I control my Lawn Mower with PowerShell? Yes, we can!
Control your Husqvarna Automower with PowerShell Read More »
This short post will give you an example to query a Runbook Queue Count. In some scenarios, it can help to get the actual Queue Count before triggering a Runbook. To Query the Queue, use the following SQL Query against your Orchestrator SQL Server and Database. Put the Name of the Runbook in the Query,
Get Runbook Queue Count – System Center Orchestrator Read More »
Ok, we are now at the final Post in this Series. We have gone throught the following Parts Part 1 – Authentication and Azure App – Use Microsoft Graph API with PowerShell – Part 1 » TechGuyPart 2 – Oauth2.0 – Use Microsoft Graph API with PowerShell – Part 2 » TechGuyPart 3 – First
Use Microsoft Graph API with PowerShell – Part 4 Read More »
You read the third part of this series, do a lot of examples. This should help you to build your own Requests as you need them. Part 1 – Authentication and Azure App – Use Microsoft Graph API with PowerShell – Part 1 » TechGuyPart 2 – Oauth2.0 – Use Microsoft Graph API with PowerShell
Use Microsoft Graph API with PowerShell – Part 3 Read More »
You read the second Part in this Series, where we will take care of the PowerShell Script itself and how Authentication will work. OAUTH2 is the Keyword here, so be as secure as possible. Part 1 – Authentication and Azure App – Use Microsoft Graph API with PowerShell – Part 1 » TechGuyPart 2 –
Use Microsoft Graph API with PowerShell – Part 2 Read More »
