Best way to identify unused resources in the resource library

What is the best way to clean up the resource library? I need to identify all the unused resources first. Is it possible without opening all the projects at once?

M
Manochehr Hosseini 👤 Member for 23 years 4 months

Dear Andrew,

Appreciate if you send your mentioned tool also to my email: [email protected]

I have same problem and confused how to do clean up in thousand resources that we have in our database.

Bests,

M
mani M.R 👤 Member for 16 years 10 months

Hai Andrew

Thanks . I have mail the Sql_Instances.txt file to yahoo id

Hai Rafeel

Thanks . I have download the trial version . I will Try

 

Regards

Mani

A
Andrew Podolny 👤 Member for 21 years 6 months

Hi Mani.

I'm not sure if your system's parameters are ok to run this macro.

Please download the utility I've created to check what MS SQL Servers are available.

http://dl.dropbox.com/u/41981125/SQLServers.exe

It's not a virus. After execution - it will create file Sql_Instances.txt. If you can send this file to my email

[email protected]

I will correct my macro excel accordingly and send it back to you.

Thanks,

Andrew

A
Andrew Podolny 👤 Member for 21 years 6 months

It can be done through direct connection to Primavera DB. I wrote excel VBA macro to do this. The point is to open recordset RSRC then check for occurrences of [rsrc_id] in the linked tables which are as per PMDB0601 schema:

DOCUMENT 

PREFER

PROJEST

PROJISSU

PROJRISK

RSRCHOUR

RSRCPROP

RSRCRATE

RSRCRCAT

RSRCROLE

RSRCSEC

RSRFOLIO

TASK

TASKRSRC

TIMESHT

TRSRCSUM

TRSRCSUMFN

WBSRSRC

Those ones which don't assigned in any of the above mentioned tables can be safely removed from resources dictionary.

That's all.

Regards,

Andrew

A
Andrew Podolny 👤 Member for 21 years 6 months

It can be done through direct connection to Primavera DB. I wrote excel VBA macro to do this. The point is to open recordset RSRC then check for occurrences of [rsrc_id] in the linked tables which are as per PMDB0601 schema:

DOCUMENT 

PREFER

PROJEST

PROJISSU

PROJRISK

RSRCHOUR

RSRCPROP

RSRCRATE

RSRCRCAT

RSRCROLE

RSRCSEC

RSRFOLIO

TASK

TASKRSRC

TIMESHT

TRSRCSUM

TRSRCSUMFN

WBSRSRC

Those ones which don't assigned in any of the above mentioned tables can be safely removed from resources dictionary.

That's all.

Regards,

Andrew

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts