security

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

Blogs

Daily Coping 17 Sep 2021

By

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

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

All the Tools in Your Toolbox

By Kathi Kellenberger

Comments posted to this topic are about the item All the Tools in Your...

All the Tools in Your T-SQL Toolbox

By Kathi Kellenberger

Comments posted to this topic are about the item All the Tools in Your...

Get value of rows based on condition

By IdealPR

Hello, I have the table with data as bellow : create table tbl_Fact( IdCmd...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers