For retrieving the SQL Server Reporting Services configurations using custom program in C# or .NET we need to use WMI (Windows Management Instrumentation) script. The process involves the following steps. RETRIEVING WMI NAMESPACE FOR SSRS For retrieving the WMI namespace we write the following function. public static string GetNamespace( string machineName) { string rSroot = @"root\Microsoft\SqlServer\ReportServer" ; string strNamespace = "" ; System.Management. ManagementClass mc = new ManagementClass ( new ManagementScope ( @"root\Microsoft\SqlServer\ReportServer" ), new ManagementPath ( "__namespace" ), null ); foreach ( ManagementObject ns in mc.GetInstances()) { if (ns[ "Nam...
The blog includes article on Datawarehousing, Business Intelligence, SQL Server, PowerBI, Python, BigData, Spark, Databricks, DataScience, .Net etc.