PowerShell

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)

2020-06-30

4,389 reads

Blogs

Basic XML Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Don’t Stop at Just Enabling Read Committed Snapshot Isolation (RCSI)

By

This past week I had a great Client ask an even greater question, and...

Query Compile Time

By

A question that came up recently was how to track the query compile time....

Read the latest Blogs

Forums

SELECT column based on parameter

By tshad

Is there a way in the same SELECT statement to show different columns without...

Restore WITH RECOVERY freezing on source DB after tail of log backup

By J-M.L

Hello everyone, I've encountered this scenario twice so far and I still don't understand...

SQL SMO property to determine if server is named or default instance

By TangoVictor

I'm using my registered server list to generate a collection of servers in powershell. The...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers