Related Articles
ARM Template – Deployment Error “[Subscription().SubscriptionId]” The request is invalid…
Posted on Author stefanroth
Recently I authored some ARM stuff in Visual Studio and I had a need for getting the current subscription ID the template is being deployed to. So there is a helper function you can call like this… “subscriptionId”: “[subscription().subscriptionId]” I used it in the template like this… …but as soon I tried to deploy the […]
SCOM – Role Permission For Scheduled Reports
Posted on Author stefanroth
Depending on the SCOM role you are using you might need to give the user the ability to see and run scheduled reports. For example you add the user into the SCOM Operator role in addition you create Report Operator role and you assign this Report Operator role permission for Reporting Services. Marnix Wolf has […]
PowerShell – Create “Clean” Custom Objects From DataTable Object
Posted on Author stefanroth
I recently had a need to create “clean” PowerShell custom objects out of a DataTable object. What does that mean? Well, let me explain. When you try to get data out of SQL Server using PowerShell there are many ways to do it. Either you use Invoke-SQLCmd, SQL Server PowerShell (SQLPS), SQL Server Management Objects […]