Had a recent issue with a customer using Traveler 220.127.116.11 on Domino 18.104.22.168 where one user had three devices listed all with the same device ID (so essentially the same device). All devices were inactive and we wanted to clear them up. So, I issued the usual console commands:
1. Tell Traveler Delete * <username>
2. Tell Traveler Security Delete * <username>
but Traveler kept saying that no devices were found for the user. Issuing Tell Traveler User <username> confirmed that there were indeed no devices associated with the user. However, in the back-end SQL database i.e. https://lotustraveler.nsf the devices were still showing !
So that means that devices still have records within the SQL database itself and so I approached an SQL DBA (after reading an IBM technote suggesting this) and there were hundreds of tables in the Traveler SQL database so that line of investigation ended right there.
IBM came to the rescue though with a couple of very handy commands which my good friend Google search could not find which is why I’m sharing this with you:
“To manually remove the orphaned users and devices from the SQL db, you
may execute the following command:
tell traveler sql delete * from USERS where username=’fully qualified name’
Note: The name has to be within single quote.
tell traveler sql delete * from DEVICE where username=’fully qualified name’
Note: The name has to be within single quote.“
So as an example:
tell traveler sql delete * from USERS where username=’CN=Jo Bloggs/OU=Sales/O=Acme’
tell traveler sql delete * from DEVICE where username=’CN=Jo Bloggs/OU=Sales/O=Acme’
And there you have it…