ReportServer Forum

rajatkhedekar87

Member

Registered: 2024-11-05

Need to know reports which are not connecting to any data sources

HI Team,

I am using report server 4.7.1 and want to figure out number of reports which are not connected to any datasources  , i tried to connect to report server datasource and tried tables like rs_report , rs_database_datasource but i am missing their joining condition .

I am trying to find out example 'abc' report connects to 'xyz' datasource and 'lmn' report is not connecting to any datasource (its blank) no connection .

So i want to figure out how many reports in my server are without connecting datasource. Please help with the query from which i can create a dynamic list.

I tried using schema  : bitnami_reportserver and rs_report gives me the name , but i need the data source name as well to which it connects so if its blank that will be in the report which dont have the datatsource.

tried the below sql

// sql

select a.username , a.id, b.name_field

from rs_database_datasource as a
join
rs_report as b
on
a.id=b.id

eugenev

Member

Registered: 2024-10-16

Re: Need to know reports which are not connecting to any data sources

Hi,

Try something like this:
select rs_report.* from rs_report
left join rs_datasource_container ON rs_report.datasource_container_id = rs_datasource_container.entity_id
where rs_datasource_container.datasource_id is null

Last edited by eugenev (2024-12-13 11:18:24)

rajatkhedekar87

Member

Registered: 2024-11-05

Re: Need to know reports which are not connecting to any data sources

thanks Eugenev ,

Please can you guide me with the table relation ships or any documentation is available to understand which table does what ?

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Need to know reports which are not connecting to any data sources

Hi rajatkhedekar87,

To understand the relationships between tables in your RS database and visualize them as a graph, you can use DBeaver, a popular database management tool: https://dbeaver.io/.

Step 1: Open Your RS Database in DBeaver
Connect to the RS Database:
Launch DBeaver and connect to your database by selecting New Database Connection and providing the necessary credentials.
Navigate to your connected database from the Database Navigator panel on the left-hand side.

Step 2: Generate a Table Relationship Graph
Find Your Tables:

Expand the database schema in the Database Navigator to see the list of tables.
Select the specific tables you'd like to include in the graph (or you can select the entire schema).
Right-Click on the Tables or Schema:

Right-click on the schema or selected tables and choose ER Diagram (Entity-Relationship Diagram) from the context menu.
View the Diagram:

A new tab will open in DBeaver, showing the selected tables as nodes and the relationships (foreign keys) between them as lines.

To further explore relationships, you can run SQL queries to examine the metadata tables (like INFORMATION_SCHEMA or pg_catalog for PostgreSQL).

Regards,
Eduardo