Command: GetSystemProps
list system properties.
SSRS Version:
2000, 2005 (N), 2005 (I), 2008 (N), 2008 (I),2008r2(N), 2008r2(I), 2012(N), 2012(I), Azure
(N)=Native
(I)=Integrated
Syntax
GetSystemProps
Parameters
None
Examples
\>getsystemprops
Properties
-----------
EnableClientPrinting : True
EnableExecutionLogging : True
EnableIntegratedSecurity : true
EnableMyReports : False
EnableRemoteErrors : False
EnableReportDesignClientDownload : True
ExecutionLogDaysKept : 60
ExternalImagesTimeout : 600
MyReportsRole : My Reports
sessiontimeout : 601
SiteName : SQL Server Reporting Services
SnapshotCompression : SQL
StoredParametersLifetime : 180
StoredParametersThreshold : 1500
SystemReportTimeout : 1800
SystemSnapshotLimit : -1
UseSessionCookies : true
Remarks
List of System Properties by SSRS Version
Property
|
Description
|
SiteName
|
The name of the report server site displayed on the user interface. The default value is Microsoft Report Server. This property can be an empty string. The maximum length is 8,000 characters.
|
SystemSnapshotLimit
|
The maximum number of snapshots that are stored for a report. Valid values are -1 through 2,147,483,647. If the value is -1, there is no snapshot limit.
|
SystemReportTimeout
|
The default report processing timeout value, in seconds, for all reports managed in the report server namespace. This value can be overridden at the report level. If this property is set, the report server attempts to stop the processing of a report when the specified time has expired. Valid values are -1 through 2,147,483,647. If the value is -1, reports in the namespace do not time out during processing. The default value is 1800.
|
UseSessionCookies
|
Indicates whether the report server should use session cookies when communicating with client browsers. The default value is true.
|
SessionTimeout
|
The length of time, in seconds, that a session remains active. The default value is 600.
|
EnableMyReports
|
Indicates whether the My Reports feature is enabled. A value of true indicates that the feature is enabled.
|
MyReportsRole
|
The name of the role used when creating security policies on user's My Reports folders. The default value is My Reports Role.
|
EnableExecutionLogging
|
Indicates whether report execution logging is enabled. The default value is true.
|
ExecutionLogDaysKept
|
The number of days to keep report execution information in the execution log. Valid values for this property include 0 through 2,147,483,647. If the value is 0 entries are not deleted from the Execution Log table. The default value is 60.
|
SnapshotCompression
|
Defines how snapshots are compressed. The default value is SQL. The valid values are as follows:
SQL = Snapshots are compressed when stored in the report server database. This is the current behavior.
None = Snapshots are not compressed.
All = Snapshots are compressed for all storage options, which include the report server database or the file system.
|
EnableClientPrinting
|
Determines whether the RSClientPrint ActiveX control is available for download from the report server. The valid values are true and false. The default value is true. For more information about additional settings that are required for this control, see Enable and Disable Client-Side Printing for Reporting Services.
|
EnableIntegratedSecurity
|
Determines whether integrated security is supported for report data source connections. The default is True. The valid values are as follows:
True = Integrated security is enabled.
False = Integrated security is not enabled. Report data sources that are configured to use integrated security will not run.
|
EnableRemoteErrors
|
Includes external error information (for example, error information about report data sources) with the error messages that are returned for users who request reports from remote computers. Valid values are true and false. The default value is false.
|
|
Property
|
Description
|
SiteName
|
The name of the report server site displayed on the user interface. The default value is Microsoft Report Server. This property can be an empty string. The maximum length is 8,000 characters.
|
SystemSnapshotLimit
|
The maximum number of snapshots that are stored for a report. Valid values are -1 through 2,147,483,647. If the value is -1, there is no snapshot limit.
|
SystemReportTimeout
|
The default report processing timeout value, in seconds, for all reports managed in the report server namespace. This value can be overridden at the report level. If this property is set, the report server attempts to stop the processing of a report when the specified time has expired. Valid values are -1 through 2,147,483,647. If the value is -1, reports in the namespace do not time out during processing. The default value is 1800.
|
UseSessionCookies
|
Indicates whether the report server should use session cookies when communicating with client browsers. The default value is true.
|
SessionTimeout
|
The length of time, in seconds, that a session remains active. The default value is 600.
|
EnableMyReports
|
Indicates whether the My Reports feature is enabled. A value of true indicates that the feature is enabled.
|
MyReportsRole
|
The name of the role used when creating security policies on user's My Reports folders. The default value is My Reports Role.
|
EnableExecutionLogging
|
Indicates whether report execution logging is enabled. The default value is true.
|
ExecutionLogDaysKept
|
The number of days to keep report execution information in the execution log. Valid values for this property include 0 through 2,147,483,647. If the value is 0 entries are not deleted from the Execution Log table. The default value is 60.
|
SnapshotCompression
|
Defines how snapshots are compressed. The default value is SQL. The valid values are as follows:
SQL = Snapshots are compressed when stored in the report server database. This is the current behavior.
None = Snapshots are not compressed.
All = Snapshots are compressed for all storage options, which include the report server database or the file system.
|
EnableClientPrinting
|
Determines whether the RSClientPrint ActiveX control is available for download from the report server. The valid values are true and false. The default value is true. For more information about additional settings that are required for this control, see Enabling and Disabling Client-Side Printing for Reporting Services.
|
EnableIntegratedSecurity
|
Determines whether integrated security is supported for report data source connections. The default is True. The valid values are as follows:
True = Integrated security is enabled.
False = Integrated security is not enabled. Report data sources that are configured to use integrated security will not run.
For more information about why you would set this property, see Integrated Security and Elevated Permissions.
|
EnableRemoteErrors
|
Includes external error information (for example, error information about report data sources) with the error messages that are returned for users who request reports from remote computers. Valid values are true and false. The default value is false.
|
|
Property
|
Description
|
SiteName
|
The name of the report server site displayed on the user interface. The default value is Microsoft Report Server. This property can be an empty string. The maximum length is 8,000 characters.
|
SystemSnapshotLimit
|
The maximum number of snapshots that are stored for a report. Valid values are -1 through 2,147,483,647. If the value is -1, there is no snapshot limit.
|
SystemReportTimeout
|
The default report processing timeout value, in seconds, for all reports managed in the report server namespace. This value can be overridden at the report level. If this property is set, the report server attempts to stop the processing of a report when the specified time has expired. Valid values are -1 through 2,147,483,647. If the value is -1, reports in the namespace do not time out during processing. The default value is 1800.
|
UseSessionCookies
|
Indicates whether the report server should use session cookies when communicating with client browsers. The default value is true.
|
SessionTimeout
|
The length of time, in seconds, that a session remains active. The default value is 600.
|
EnableMyReports
|
Indicates whether the My Reports feature is enabled. A value of true indicates that the feature is enabled.
|
MyReportsRole
|
The name of the role used when creating security policies on user's My Reports folders. The default value is My Reports Role.
|
EnableExecutionLogging
|
Indicates whether report execution logging is enabled. The default value is true.
|
ExecutionLogDaysKept
|
The number of days to keep report execution information in the execution log. Valid values for this property include 0 through 2,147,483,647. If the value is 0 entries are not deleted from the Execution Log table. The default value is 60.
|
SnapshotCompression
|
Defines how snapshots are compressed. The default value is SQL. The valid values are as follows:
SQL = Snapshots are compressed when stored in the report server database. This is the current behavior.
None = Snapshots are not compressed.
All = Snapshots are compressed for all storage options, which include the report server database or the file system.
|
EnableClientPrinting
|
Determines whether the RSClientPrint ActiveX control is available for download from the report server. The valid values are true and false. The default value is true. For more information about additional settings that are required for this control, see Enabling and Disabling Client-Side Printing for Reporting Services.
|
EnableIntegratedSecurity
|
Determines whether integrated security is supported for report data source connections. The default is True. The valid values are as follows:
True = Integrated security is enabled.
False = Integrated security is not enabled. Report data sources that are configured to use integrated security will not run.
For more information about why you would set this property, see Integrated Security and Elevated Permissions.
|
EnableRemoteErrors
|
Includes external error information (for example, error information about report data sources) with the error messages that are returned for users who request reports from remote computers. Valid values are true and false. The default value is false.
|
|
Property
|
Description
|
SiteName
|
The name of the report server site displayed on the user interface. The default value is Microsoft Report Server. This property can be an empty string. The maximum length is 8,000 characters.
|
SystemSnapshotLimit
|
The maximum number of snapshots that are stored for a report. Valid values are 1 through 2,147,483,647. If the value is 1, there is no snapshot limit.
|
SystemReportTimeout
|
The default report processing timeout value, in minutes, for all reports managed in the report server namespace. This value can be overridden at the report level. If this property is set, the report server attempts to stop the processing of a report when the specified time has expired. Valid values are 1 through 2,147,483,647. If the value is -1, reports in the namespace do not time out during processing. The default value is 5.
|
UseSessionCookies
|
Indicates whether the report server should use session cookies when communicating with client browsers. The default value is true.
|
SessionTimeout
|
The length of time, in seconds, that a session remains active. The default value is 600.
|
EnableMyReports
|
Indicates whether the My Reports feature is enabled. A value of true indicates that the feature is enabled.
|
MyReportsRole
|
The name of the role used when creating security policies on user's My Reports folders. The default value is My Reports Role.
|
EnableExecutionLogging
|
Indicates whether report execution logging is enabled. The default value is true.
|
ExecutionLogDaysKept
|
The number of days to keep report execution information in the execution log. Valid values for this property include 0 through 2,147,483,647. If the value is 0 entries are not deleted from the Execution Log table. The default value is 60.
|
SnapshotCompression
|
Defines how snapshots are compressed. The default value is SQL. The valid values are as follows:
SQL = Snapshots are compressed when stored in the report server database. This is the current behavior.
None = Snapshots are not compressed.
All = Snapshots are compressed for all storage options, which include the report server database or the file system.
|
EnableClientPrinting
|
Determines whether the RSClientPrint ActiveX control is available for download from the report server. The valid values are true and false. The default value is true. For more information about additional settings that are required for this control, see Configuring Client-Side Printing for Reporting Services.
|
EnableIntegratedSecurity
|
Determines whether integrated security is supported for report data source connections. The default is True. The valid values are as follows:
True = Integrated security is enabled.
False = Integrated security is not enabled. Report data sources that are configured to use integrated security will not run.
For more information about why you would set this property, see Integrated Security and Elevated Permissions.
|
EnableRemoteErrors
|
Includes external error information (for example, error information about report data sources) with the error messages that are returned for users who request reports from remote computers. Valid values are true and false. The default value is false.
|
|
See Also
Item properties
GetProps - list properties and their values
SetProps - set item property
System properties
GetSystemProps - list properties and their values
SetSysProps - set item property
