QC 9.2 project size

[ciber_andy2003]

Hello all!

Maybe it is a stupid question, but how can i see the size of a project in QC 9.2?

I have to say that I don't have access to the database, all I can access is the admin console.
Is there a query that I can run here to see the size of the project?
All my projects are stored on a database.

[john scarpino]

Two ways 1. Via the Database (which seems you do not have access to do) or 2. Disable the project. Export it to a server then view its properties size.

I hope this helps.
John Scarpino

[Vladimir Skrbek]

Which version of HPQC do you use?
In new version HPQC 10 there is not possible to get all data in db. So if you tak the size from db then you also has to count the files on repozitory.

[john scarpino]

Vladimir,

You need database access and basically view the size of the projects schema itself. Not within a SQL Viewer type application but at the path level of the server itself.

I hope this helps.
John

[Vladimir Skrbek]

John, I do not understand ...

[jwunico]

I need to know this too.
My projects are also in the database.
I have access to the database but don't know Oracle commands.

[Vladimir Skrbek]

For the schema size I use this sql queries:
1) for all schemas (users):
select owner,sum(BYTES) "Total bytes" from dba_segments group by owner;

2) or for particular schema:
select sum(BYTES) "Total bytes" from dba_segments where owner='QUALITYCENTER_DEMO_DB';


But as I said in QC 10 or QC 9.2 there was closed possibility to use db as a repository. So this will give you only the size of db data but you have to add the size of file repository on the application server for the particular QC project.

[jwunico]

Great thanks, that's just what I want!

[ADUGAR]

I have the access to project database QC 9.2. It would be great if you can provide us the query to find out the project size.

[Damodar-Reddy]

What is the Database version?

If SQL.

You can do the below + your repository Size.

1.Get the Schema Name of tha project.
2. Go to the DataBase Server and open SQL Server Managment Studio.
3. Open the Database folder and look for the relevant Schema name.
4. right click on the database and click on properties.

If Oracle:

Get in Touch with your DBA for the schema size and add your Repository Size to get the full size of the project.