Command: GetDSNoRpt

 

Show datasources with no reports linked to the datasource

 

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

 

List datasources not linked to a report in a folder or sub folders

 

GetDSNoRpt  [Folder] [/S]

GetDSNoRpt  [/?]  displays help

 

 

 

Parameters

 

 

[Folder]        If no folder is specified current folder is used

[/S]                Only valid with folder, will recurse sub folders too

 

Examples

 

 This will scan the current folder for any data sources with no reports.

 

 GETDSNORpt

 

 

 

 This will scan the current folder and sub folders for any data sources with no reports.

 

 GETDSNORpt /s

 

 

 

 This will scan the root folder and sub folders for any data sources with no report linked.

 

 GETDSNORpt \ /s

 

 

 

 The  output will show the full path for the datasource.

 

 

 GETDSNORpt \ /s

 

 Datasources with no reports

 

 \Data Sources\DataSource1

 

 

Remarks

•

 

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)