How work items are stored in Repository

I want to know the ER diagram Or Data Base structure with respect to work items.

Please let me where I can find which tables have what information on work items.

I want to use this information for creating new reports.

And also I want to know what snapshots has what information

If you have DBA access any tool( ex: Toad) can create ER Diagram.

If you don't have DBA access, then you can use BIRT to get an idea about the tables / warehouse

Can you please help me how to do it from BIRT Or point to some documentation how to accomplish this.

Thanks much for the reply.

I want to know the ER diagram Or Data Base structure with respect to work items.

Please let me where I can find which tables have what information on work items.

I want to use this information for creating new reports.

And also I want to know what snapshots has what information

If you have DBA access any tool( ex: Toad) can create ER Diagram.

If you don't have DBA access, then you can use BIRT to get an idea about the tables / warehouse

Can you please help me how to do it from BIRT Or point to some documentation how to accomplish this.

Thanks much for the reply.

I want to know the ER diagram Or Data Base structure with respect to work items.

Please let me where I can find which tables have what information on work items.

I want to use this information for creating new reports.

And also I want to know what snapshots has what information

If you have DBA access any tool( ex: Toad) can create ER Diagram.

If you don't have DBA access, then you can use BIRT to get an idea about the tables / warehouse

you can download BIRT via eclipse

But if you are looking for ER diagram this is not the right approach. If you are looking for queries/reports on workitems then this could be one approach

Hi

I downloaded the BIRT and installed it. I want to know how the tables are stored and what table has what data.

And I created a report but the report is not showing up.

Thanks,
_Shashank

Can you please help me how to do it from BIRT Or point to some documentation how to accomplish this.

Thanks much for the reply.

I want to know the ER diagram Or Data Base structure with respect to work items.

Please let me where I can find which tables have what information on work items.

I want to use this information for creating new reports.

And also I want to know what snapshots has what information

If you have DBA access any tool( ex: Toad) can create ER Diagram.

If you don't have DBA access, then you can use BIRT to get an idea about the tables / warehouse

you can download BIRT via eclipse

But if you are looking for ER diagram this is not the right approach. If you are looking for queries/reports on workitems then this could be one approach