Command: GetDS
Get data source information
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
GetDS [[Datasource]|[Folder]] [/S]
GetDS [/?]
Parameters
[/?] displays help
[DataSource] List detailed information about the Datasource
[Folder] List datasources in a folder
If no Folder or Datasource is defined it will
list Datsources in current folder (can be used with /S
[/S] List datasources in a folder and subfolders
must be used with Folder not Datasource
[/D] Detail information about datasouces, only valid for Folder
Examples
To get detailed information about a data source:
getds <data source name>
\Data Sources>getds ds1
Name : ds1
Description :
Hidden : False
Enabled : True
Connection : Microsoft SQL Server
Connection String : Data Source=.\s8r2;Initial Catalog=fin_report
connect using : Credentials stored securely in the report server
Username : fred
Windows credentials : True
Impersonate the authenticated user : False
To get information about data sources in a folder . This also shows which data sources are hidden.
Folder: \Data Sources
Hidden | Name
-------|-----
| finance_ds
| ds1
| ds2
To show detailed information about the data sources in a folder use /D
To show data sources in sub folders use /s
eg getds <foldername> /s /d
Remarks
•You must choose either a data source or a folder. Both are mutually exclusive.
See Also
GetDS - List shared data sources.
GetDSNoRpt - List data sources not linked to a report
GetRptDS - List report data source (and shared dataset for SSRS 2008r2)
GetRptNoDS - List reports with missing data sources (and shared dataset for SSRS 2008r2)
