Database:

If running NLES 4.x:

1. From the NotifyLink Admin Page, go to User Administration -> Select the user -> Select Edit User Device -> Click on the "Clear all new messages" button. This will clear the user's HWP Table.


If running NLES 3.x:

From the Notifylink Admin page, go to User Administration -> Select the user from the list -> Click "User Statistics" -> The first line here will be a 5 digit Client Device SAKey -> Make a note of this number

If you are running the full version of SQL:

1. Open Enterprise Manager for SQL

3. Expand computer name

4. Expand Databases

5. Expand NLES_IMAP4_POP3 database

6. Click Tables

7. Right Click the HWP table and select Open Table -> Return all rows

8. Click the SQL button (top of screen, fourth from left, highlighted below: SQL and execute query buttons)

9. Enter the following query in the empty window (You may delete what is in window by default)

Delete From HWP Where DeviceAddress = XXXXX (Where XXXXX is the 5 digit SAKey for the user)

Click the Red Exclamation point to run the query


If you are running MSDE:

1. Open DBAMgr2k

2. Click Activity in the upper left corner

3. Select Query

4. Select NLES_IMAP4_POP3 in the drop down menu

5. Type the following query in the empty box

Delete From HWP Where DeviceAddress = XXXXX (Where XXXXX is the 5 digit SAKey for the user)

6. Click the red triangle to run the query