search

dsccommunity / SqlServerDsc

This module contains DSC resources for deployment and configuration of Microsoft SQL Server.
MIT License
360 stars 225 forks source link

Get-SqlDscReportingServices: New command proposal #2011

Open johlju opened 6 months ago

johlju commented 6 months ago

Command proposal

Returns an [hashtable] array of all installed SQL Server Reporting Services instances.

Proposed parameters

Parameter Mandatory Data type Description Default value Allowed values
ParameterName Yes String Detailed description None None

Special considerations or limitations

There could also be an additional command that uses the same logic but returns Power BI Report Server instances, e.g. Get-SqlDscPowerBIReportServer.

Should at least return the following properties:

Property name Data type Description
CurrentVersion String Returns the version of the installed Microsoft SQL Server Reporting Service instance.
ServiceName String Returns the name of the Microsoft SQL Server Reporting Service instance Windows service.
ServiceAccount String Returns the account that runs of the Microsoft SQL Server Reporting Service instance Windows service.
ErrorDumpDirectory String Returns the path to error dump log files.
WebPortalApplicationName String Should use the code here: https://github.com/dsccommunity/SqlServerDsc/blob/026647ca36ce154a86facf195d00c27c2668281a/source/DSCResources/DSC_SqlRS/DSC_SqlRS.psm1#L1034-L1041