Monitor - Audit trail analyser
Posted in 1994
I have had quite some response to a recent posting I made regarding our audit trail monitoring software "MONITOR". This is the text from our "GLOSSY". Note: MONITOR is written in 4GL and UNIX SHELL SCRIPTS and so should port to ANY unix platform supported by INFORMIX !! If you would like any more details please contact me : Mike Aubury Lintel Software Consultancy Limited Soughton House 2 Nicholas Street Mews Chester Cheshire CH1 2NS ENGLAND Tel : 0244 316297 Fax : 0244 400171 EMAIL : mike@lintel.demon.co.uk We also have another product called "PHASE-2" which does the same thing for an ONLINE database by analysing the transaction logs. Monitor MONITOR provides an environment whereby changes to your databases can be recorded and analysed. As well as recording the data that has changed, MONITOR will record the date and time that the change occurred, the user who made the change and the operation that caused the change (Delete, Update or Insert). MONITOR provides standard reports that can be produced automatically or on request. In addition authorised users can write customised reports and screen based enquiry forms. Some key features of MONITOR are : o Automatically monitors database changes however made o Users do not require knowledge of the database structure o No changes are required to your applications o Changes can be archived for analysis at a later date +----------------------------------------------------------------------------+ | Page 1 Update Activity Report Date Printed 22 May 94 | | | | Activity : Update Table : Maillist | | -------------------------------------------------------------------------- | | | | Date Time User Customer Customer Status Balance | | Name Telephone | | | | 20/09/92 10:00 Mike Jones 071 008 1432 o/d (1500.00)| | Jones 071 008 1432 o/d (1200.00)| | 20/09/92 10:01 Mike Smith 051 654 9876 credit 500.06 | | Smith 051 654 9876 credit 700.00 | | 21/09/92 12:05 Sharon Adams 021 777 1234 o/d (600.00)| | Adams 021 777 1234 credit 600.00 | | | +----------------------------------------------------------------------------+ o Complete control over report and screen formats +----------------------------------------------------------------------------+ | Page 1 Database Activity by User Report Date Printed 22 May 94 | | | | Activity : All Total Usage = 40 records Table : Maillist | | -------------------------------------------------------------------------- | | | | User Usage 20% 40% 60% 80% Percent Entries | | Name >>>>>>>>>|>>>>>>>>>|>>>>>>>>>|>>>>>>>>>|>>>>>>>>>| % By User | | | | annew >>>>>>>>>|>> 25 10 | | barbl >>>>>>>> 17 7 | | johng >>>>> 10 4 | | martm >> 5 2 | | paulp >> 5 2 | | rachs >>>>>>> 15 6 | | seanm >>>>> 10 4 | | suer >>>>>> 12 5 | +----------------------------------------------------------------------------+ o User Activity Report -- Mike Aubury