reference:useful_database_queries
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| reference:useful_database_queries [2014/11/21 09:56] – [Useful Database Queries] paul | reference:useful_database_queries [2021/11/29 12:05] (current) – [Useful Database Queries] paul | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======Useful Database Queries====== | ======Useful Database Queries====== | ||
| + | Below are some database (SQL) queries which may be useful in some situations. You can run these from the ' | ||
| + | |||
| * [[Get all lists & members|Export all lists & members]] | * [[Get all lists & members|Export all lists & members]] | ||
| + | * [[Find forwards/ | ||
| + | * [[Find message]] | ||
| + | * [[Find biggest messages]] | ||
| + | * [[Delete list member from all lists]] | ||
| + | * [[Copy SMTP Rules]] | ||
| + | * [[Password lengths]] | ||
| ====LAN Forwarding==== | ====LAN Forwarding==== | ||
| * [[Export LAN forwarding rules]] | * [[Export LAN forwarding rules]] | ||
| - | * [[List ALL messages in LAN forwrding queue]] | + | |
| + | | ||
| + | * [[List messages in LAN forwrding queue waiting to go to a specific server|List messages in LAN forwarding queue waiting to go to a specific server]] | ||
| + | * [[Alter LAN forwarding queued messages going to one server to go to another]] | ||
| + | * [[Make LAN forwarding immediately attempt to dequeue all pending messages]] | ||
| + | ====Logs/ | ||
| + | * [[View password change history]] | ||
| + | * [[List failed message send summary]] | ||
| + | * [[Sent message summary]] | ||
| ====Problem Solving queries==== | ====Problem Solving queries==== | ||
| In rare cases these may be needed. We recommend only using these if suggested by VPOP3 technical support! | In rare cases these may be needed. We recommend only using these if suggested by VPOP3 technical support! | ||
| * [[Reset message folder counts]] | * [[Reset message folder counts]] | ||
reference/useful_database_queries.1416563799.txt.gz · Last modified: 2018/11/14 10:44 (external edit)
Page Tools
