Best way to identify unused resources in the resource library

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

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

Hai Andrew

Can you mail me the Macro File To my mail id

mani_nambiram@yahoo.co.in

Thanks

Mani

http://www.acceleratedpm.com/xena-administrator

http://www.acceleratedpm.com/xena-primavera-configuration-utility

What a mess!

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

a_podolny@yahoo.com

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

Thanks,

Andrew

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

Dear Andrew,

Appreciate if you send your mentioned tool also to my email: m.hosseini@yahoo.com

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

Bests,