automation

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,490 reads

Blogs

Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements

By

The next batch of exciting updates to the block editor is live on WordPress.com....

Are You a Diverse User Group or Event?

By

One of the things that I’ve seen crop up at various points in my...

Daily Coping 18 Jun 2021

By

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

Read the latest Blogs

Forums

Deceptive Visualizations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deceptive Visualizations

Argument syntax for SSIS Execute Process Task Editor

By Isabelle2378

Hi, I'm trying to modify my SSIS packages to use sftp and since it...

Seeking input on Best Method to Join on First or Last Row in a 1:M Join

By YSLGuru

I have included the DDL to re-create the 2 tables in this examples. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers