Forum Discussion

ANDREY_FYODOROV's avatar
13 years ago

DA. Analytics. Can we enumerate Duplicates BEFORE Export?

Hi all. We have a very large case in Discovery Acclerator, analytics for the case was enabled and has completed. We also have SQL reporting services installed, and the DA report templates have be...
  • TonySterling's avatar
    13 years ago

    Do you plan to export all items in the case?  And are you going to choose Similiar and Duplicate or Duplicate only?

    If doing Duplicate only this should give you a good idea:

    Runs against your DA Customer database:

    SELECT CaseName, COUNT(Distinct KVSSaveSetID)
    FROM view_DiscoveredItems
    GROUP BY CaseName