ComboStrap URL Management - Log redirections History

1 - About

This page shows you how you can query the redirection history table stored in the database

3 - 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)

Powered by ComboStrap