Skip to main content
asktam1410
Level 3
Nov 21, 2019 9:52 PM UTC
Solved

NmsAddress Clean up

I would like to know on what scenario records will be deleted from the address table. I see that records are being deleted from this table but dont know on what reasons it deletes.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Venu_Reddy
Venu_ReddyAccepted solution
Level 6
Nov 22, 2019 6:23 AM UTC

Hi

In NmsAddress schema, usually the blacklisted,quarantine, valid, whitelisted data will be available.

The valid address will be automatically removed from this table using the option NPAI (NmsCleanup_LastCleanup) which is a part of clean up process.

This task lets you delete records which matches valid addresses from the NmsAddress table.

Check below link for the query how it will process

Database cleanup workflow

3 replies

Raj_Ganta-1
Level 5
Nov 22, 2019 5:58 AM UTC

Hi,

they might be purged based on purge settings. check here for further details

Purging events

Translate
Venu_Reddy
Venu_ReddyAccepted solution
Level 6
Nov 22, 2019 6:23 AM UTC

Hi

In NmsAddress schema, usually the blacklisted,quarantine, valid, whitelisted data will be available.

The valid address will be automatically removed from this table using the option NPAI (NmsCleanup_LastCleanup) which is a part of clean up process.

This task lets you delete records which matches valid addresses from the NmsAddress table.

Check below link for the query how it will process

Database cleanup workflow

Translate
asktam1410
Level 3
Nov 22, 2019 2:05 PM UTC

I Oversight this page. Thanks for your help

Translate