2010-03-16 06:12 AM
I've done some SQL queries in the past on the DFM DB and have reviewed the schema, but I am not sure how to query File SRM data? I don't see specific tables in the schema to tie this information together.
I have a customer who wants to take the File SRM reports a step further and be able to view file type totals per path, size, etc.. The SRM reports provide the basic info on file types, but then don't let you click on the type to explore further. Another example would be to query file paths in a group and generate a report on file types within that path, or search a date range for least accessed/modified files.
2010-03-16 07:25 AM
DB views are not provided for SRM data.If you are the customer or have a customer looking for the same, pls raise a RFE to include the same in DB view,by your PS or NGS.