ComboStrap URL Management - Log redirections

1 - Data Store

You can find the meta data for the last version: in the Sqlite Database DOKUWIKI_HOME/data/meta/.sqlite3

With the SQLite plugin, the data can be queried directly through its admin page.

2 - Example

  • All redirections from the last 5 minutes:
SELECT
  SOURCE, target, TYPE, method
FROM
  redirections_log
WHERE
  datetime(TIMESTAMP) > datetime('now','-5 minutes')
ORDER BY
  datetime(TIMESTAMP) DESC;
  • Count of redirections by minutes
SELECT
  strftime('%H:%M', TIMESTAMP),
  COUNT(1)
FROM
  redirections_log
GROUP BY
  strftime('%H:%M', TIMESTAMP)