Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

  • Article

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

5 (2)


4,487 reads


Azure Function Drain mode


(2021-Jun-16) Recently, Google started to notify me that my blog website ( had been experiencing some...


New blog post - Monitor deadlocks in Amazon RDS for SQL Server and set notifications...

Let’s Celebrate Pride by Supporting Nonprofits


For Pride this year, we’re highlighting queer nonprofits and charities. It’s more important than...

Read the latest Blogs


Mirror Database without Domain

By stefgrifon

Hello, I tried to make a mirror for my Demo database My Principal server...

PowerShell script help

By rocky_498

Hi Guys, I am executing a PowerShell script from SSIS (Execute Process Task). Simple...

Performance Counters Missing in SQL 2016 SP2

By ReamerXXVI

Hi, I'm looking for a fix to an issue where performance counters are missing...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers