Share via

SSRS find strings (username) in data sources

sco gordo 301 Reputation points
2023-02-15T11:57:30.76+00:00

I'm generating a permissions report. Is there a powershell script that'll go through the SSRS db to output a list of accounts used in Data Sources or elsewhere in my environment?

Thanks!

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,012 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,628 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,868 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,451 Reputation points Microsoft External Staff
    2023-02-16T07:26:06.33+00:00

    Hi @sco gordo

    Sorry I don't know much about Powershell, I found these links about SSRS Powershell Commands

    PowerShell Commands for SQL Server Reporting Services

    Reporting Services PowerShell

    Hope these can help you.

    Best regards,

    Aniya

    0 comments
  2. Limitless Technology 44,666 Reputation points
    2023-02-16T12:33:25.1866667+00:00

    Hello there,

    Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

    This article includes and describes a sample Reporting Services RSS script that copies content items and settings from one SQL Server Reporting Services report server to another report server, using the RS.exe utility.

    PowerShell cmdlets for Reporting Services SharePoint mode https://learn.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/powershell-cmdlets-for-reporting-services-sharepoint-mode?view=sql-server-2016

    Hope this resolves your Query !!

    --If the reply is helpful, please Upvote and Accept it as an answer--

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.