Question
How do we separate deleted accounts from the rest of the accounts exported from Export Vault Data?
Answer
Export Vault Data (EVD) can export a list of accounts (Objects). Within each account is a "deleted by", which is the end user that deleted the object and a "deletion date" which is the time and date the account was deleted.
EVD can organize its output into either a flat file (CSV format) or into an MSSQL database. The deletion parameters are the following, depending on the output format:
* CSV File: "DeletedBy" and "DeletionDate"
* MSSQL: dbo.CAFiles.CAFDeletedBy and dbo.CAFiles.CAFDeletionDate (datetime)
For further information, consult the Export Vault Data document or online help:
https://cyberarkdocu.azurewebsites.net/Product-Doc/OnlineHelp/PAS/Latest/en/Content/Landing%20Pages/...
Issue
Q: We have exported data, could see deleted accounts list also populated but unable to segregate deleted accounts from not deleted, Can you provide some pointers around. Do we have some property by which can differentiate deleted user list?
Environment
Component: Export Vault Data Functional Area: Performance