roles

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 (1)

2020-06-30

3,850 reads

Blogs

Fixing the PoSh Hotkey in ADS

By

I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...

Capture Execution Plans Only For Long Running Queries

By

I love questions. Most of all, I love questions I can answer. I spotted...

Daily Coping 28 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

API Newbee

By thedeadzeds

Hi Guys, I'm completely new to API's and i was wondering if there is...

Simple Python question...

By pietlinden

I have a table in SQL Server like this: CREATE TABLE #SymptomData (  ...

Regular expressions in script component

By sqlfriend

In one of our SSIS package we have a script component that validate a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers