Problem: How to query configuration
information from the report server
Solution: SSRS Report Server Database
Tables
Inside report server database there is a table which stores
configuration information, In which the list of details are switches
information like whether the configuration is on or off.
Example:
In this article, I am going to show we can query list of
information that’s present on the report server table which shows configuration
information.
SELECT [ConfigInfoID]
,[Name]
,[Value]
FROM [dbo].[ConfigurationInfo]
Results:
|
ConfigInfoID
|
Name
|
Value
|
|
BD040D46-1A57-4F74-B516-EF0870094E04
|
EditSessionCacheLimit
|
5
|
|
FFB8AB85-EAC6-4E93-B86E-89DE8A27E065
|
EditSessionTimeout
|
7200
|
|
3144866F-E929-405E-A32C-8233C1BF5EB1
|
EnableClientPrinting
|
True
|
|
90802E57-272B-4A90-B0A8-F72F914D8A03
|
EnableExecutionLogging
|
True
|
|
AF9F7A21-889F-40C0-8708-D4F0BDF7C125
|
EnableIntegratedSecurity
|
true
|
|
66A6C48C-F3D3-4026-9282-CE70908D774F
|
EnableLoadReportDefinition
|
True
|
|
D75A8160-7BD0-4E43-95A0-527907D4CF27
|
EnableMyReports
|
False
|
|
38AE1626-D94B-427D-A923-77AEBA1438E6
|
EnableRemoteErrors
|
False
|
|
86D02BAC-E9EC-427D-A2E2-2CE0037868D5
|
EnableReportDesignClientDownload
|
True
|
|
12450F53-D49E-42BF-8DB6-303800FED723
|
EnableTestConnectionDetailedErrors
|
True
|
|
57CCDB6E-D6CD-4BA7-89E9-453B38FA3453
|
ExecutionLogDaysKept
|
60
|
|
BE40E8C9-CA1B-4726-9A09-2BFFA0F88A2A
|
ExecutionLogLevel
|
Normal
|
|
D1A55C0E-56F6-481F-9112-1CDDD370D3EA
|
ExternalImagesTimeout
|
600
|
|
D48C8EA5-B8C2-42F3-9932-4A77E1550EF4
|
MyReportsRole
|
My Reports
|
|
82F26114-9F0B-40A0-A8C9-ABDD296AA167
|
RDLXReportTimeout
|
1800
|
|
656AB17F-0645-43B6-BD0C-0C448C222313
|
ReportBuilderLaunchURL
|
|
|
0581EB60-274F-40FE-9651-6858CC3AD0F5
|
SessionTimeout
|
600
|
|
A4E1BCAF-FED1-4866-8AF0-D730035B69F2
|
SharePointIntegrated
|
False
|
|
C986C8AF-1F11-478E-8D77-FF566D86E285
|
SiteName
|
SQL Server Reporting Services
|
|
43CA30A8-8105-4316-A550-08CA1856DD6D
|
SnapshotCompression
|
SQL
|
|
D4A3F019-CC29-44CD-BEBC-C022F3E8FEFE
|
StoredParametersLifetime
|
180
|
|
B8767556-99BD-43FE-97F1-DDD99893D235
|
StoredParametersThreshold
|
1500
|
|
C7F84709-F3B3-4CB8-A4BA-7E7BC1B0B4FB
|
SystemReportTimeout
|
1800
|
|
EB607865-6E94-408D-8741-504D567A84B9
|
SystemSnapshotLimit
|
-1
|
|
9ED7111E-BDA4-4EDA-8508-68DE04C4760E
|
UseSessionCookies
|
true
|
0 comments:
Post a Comment