Common SQL Requests

Review Users and when they logon

select * from IBE$LOG_TABLES IBT
where IBT.TABLE_NAME = ‘USERS’ and IBT.OPERATION = ‘U’ and DATE_TIME between ‘1/1/2014′ and ’12/31/2014’ and not exists (select 1 from IBE$LOG_FIELDS IBF where IBF.LOG_TABLES_ID = IBT.ID)

Review Users when they add Customers

select * from IBE$LOG_TABLES IBT
where IBT.TABLE_NAME = ‘CUSTOMER’ and IBT.OPERATION = ‘I’ and DATE_TIME between ‘1/1/2010′ and ’12/31/2014’

Review Users when they edit Customers

select * from IBE$LOG_TABLES IBT
where IBT.TABLE_NAME = ‘CUSTOMER’ and IBT.OPERATION = ‘U’ and DATE_TIME between ‘1/1/2010′ and ’12/31/2014’