You also could have run the 'Item Detail Report' from DA to obtain the information you were looking for:Item Detail reportFields in the Item Detail report:DAIDThe identifying number that Discovery Accelerator has assigned to the item.SSIDThe identifi...
This one I just added the Status of the case: SELECT tc.[Name] AS 'CaseID',tc.CaseID AS 'CaseNumber',tc.statusid ' CaseStatusID',ts.name 'CaseStatus',tp.PrincipalName AS 'Owner'FROM tblIntSearches tisJOIN tblCase tc ON tc.CaseID = tis.CaseIDJOIN tblP...
Hello Jimmy,Could you clarify what you mean about "catches all the unwanted noise in CA to a seperate databse". Compliance Accelerator does not have the capability to move data between customer databases.