ComboStrap URL Management - Log redirections History

About

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

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)