Querying Specific Timestamped data DFM DP Transfer Report
2013-03-01 05:44 AM
I would like to know if there is a way to directly extract only specific timestamped data form DFM DP TRANSFER REPORTS.
What I am doing so far, is viewing the full report while sorting only the specific date ie :
dfm report view -F csv dp-transfer-backup-daily | findstr "2013-02-27" > dp-transfer-backup-daily.2013-02-27.out
Is there a smarter way to do it ?
Many Thanks !
1 REPLY 1
Re: Querying Specific Timestamped data DFM DP Transfer Report
2013-04-02 09:43 PM
Unfortunately this is not possible using the native reporting in DFM. But we do provide database views for these reports. So using simple SQL query you should be able to get this data.
The view schema is documented under the following. Go to the link below and look for the following table named datatransferHistoryDayView
Help->General Help->DatabaseSchema->Database schema for DataFabric Manager server historic data
To access the view you will have to do the follwoing.
- dfm database user create -u <user-name> [ -p <password> ]
- dfm database access enable -u <user-name-or-id>
- dfm database query run [ -F <output-format> ] <select-query>