Category: Powershell

Top 10 things to document in SSRS

Top 10 things to document in SSRS

Today is my last day at Monster Worldwide and it occurred to me in the lead up to it that there is quite a few components of SSRS and metadata that I’ve documented, put under source control or extracted over the years. I luckily didn’t experience any catastrophic failures where I needed ALL of these…

By Craig 27th February 2018 0

I published a PowerShell Module!

I published a PowerShell Module!

I’ve been working with Power BI metadata a lot lately. Analysing and sourcing information about the security, content and workspaces we hold and I always found myself re-using authentication code or I’d end up approaching problems differently as my PowerShell skills progressed over the last 12 months. It was a few  months ago that I…

By Craig 16th January 2018 0

Administering SSRS with PowerShell

Administering SSRS with PowerShell

I’ve covered a lot of SSRS security tasks using PowerShell over on SQL Shack where I connect directly using the New-WebServiceProxy command. For T-SQL Tuesday I wanted to do a quick comparison between my original method and the official Reporting Services module and see what else the module offers. The first thing you’ll want to do is…

By Craig 12th September 2017 0

AD Group Auditing with Powershell

AD Group Auditing with Powershell

Here’s another handy Powershell script Ive created. It borrows components from another(credited at the bottom of the post) and expands on the repadmin functionality in the Active Directory Powershell module. The main aim of this is to keep track of members being added or removed to Active Directory groups. There is functionality to do this within…

By Craig 27th September 2016 0

SPN & Delegation backup script

SPN & Delegation backup script

I use SPNs quite extensively to allow Reporting Services to talk to databases severs,  Sharepoint etc. It’s a core component of any new server setup I perform. We also employ Kerberos delegation that allows credentials to be passed down from the user through SSRS to the database server. In most service accounts delegation is simply set…

By Craig 29th April 2016 0