SQL

Query Azure SQL Database with PowerShell and Azure App Registration

As you already know, I love to use Azure App Registration to authenticate with Microsoft Cloud Services. Now I had a Use Case to Query a SQL Database stored in Azure with a PowerShell Script to Select Data and do some stuff. So how to solve this without an Azure App Registration (Enterprise Applikation)? Let

Query Azure SQL Database with PowerShell and Azure App Registration Read More »

System Center Service Manager–SQL Query to get a full List of your Incidents

In the most cases, the Reporting has to be done through the Data warehouse DB for SCSM, but in some cases you have to get all the Data from the ServiceManager DB. For Example if you don’t have a Data warehouse DB for SCSM or you need some more Details. In this Case you have

System Center Service Manager–SQL Query to get a full List of your Incidents Read More »

System Center Orchestrator–SQL Query detailed Logs and behind the Scene

In some cases it can happen that the Log Purge is not working anymore, or not working correctly. In a real bad situation it can happen, that the daily Log Purge will make more troubles, maybe stops your Runbooks from working. Than you will see a lot of orphaned Runbooks, and in the most cases

System Center Orchestrator–SQL Query detailed Logs and behind the Scene Read More »