Welcome to the Jazz Community Forum
How to get the deleted RTC stream status (flag) in the BIRT report

Accepted answer

Arun, do you need that so the deleted streams no longer show up in the reports?
Comments

Yes, I would like to know the status of the streams Active\Passive (deleted streams) in BIRT report.

Currently RTC does not mark the streams as soft deleted when they are really deleted. I would say this is a bug and I just created a work item for it:Mark streams as softdeleted in the data warehouse when they are deleted. (333555)