Page 1 of 1

hash query

Posted: Thu Jul 23, 2009 6:56 am
by raju4u
Could you please tell me the query..
one hash file is being used by how many jobs in a project.
thanks in advance
\

Posted: Thu Jul 23, 2009 7:06 am
by priyadarshikunal
Courtsy is to put an answer if you solved the problem. This will help searchers in future.

Posted: Mon Jul 27, 2009 4:04 am
by raju4u
can anybody help us in this regard

Posted: Mon Jul 27, 2009 4:25 am
by ArndW
Nobody answered since the post was marked as "resolved". This is not easy, since hashed files can be utilized by name or by path. If all references are by name or all uses of the hashed file are done by using the same metadata columns then one can search from within the tool. Otherwise a project export to a .dsx or .xml file and subsequent text search of the document might give the best results.

Posted: Mon Jul 27, 2009 6:20 am
by chulett
Another possibility is the 'List all files and tables' tool available on Chuck Smith's website. I adapted it to write to a database table so the results can be easily queried.

Posted: Mon Jul 27, 2009 10:47 am
by kduke