Gday All,

 

We have been running SDP for 4 or so years and during this time there has been various domain migrations. We now have one production domain, we used to have 4 or 5.

 

The net effect of this is that we have a lot of old records in 'requesters', which I want to delete. Out of approx. 9000 requestors, 2500 are current and valid, the rest are old rubbish records from previous domains.

 

In the requesters sections I see that I can filter by domain, so it is not that hard for me to identify what I want to delete and what I want to keep - at 250 a page I estimate doing this manually will take a short while to delete 5000 users but probably only an hour or so.

 

The issue I'm having is understanding what the impact to the data integrity of system reports and history when requesters are deleted. I gather the system is smart enough to just have an 'isdeleted' column in the database so all previous requesters information is recorded and report integrity will remain fine ?

 

I do not believe there is any open incidents or requests that are linked to any of these old requester records in the system.

 

Thanks for any help or clarification provided,

Mat.