Table 7-1 SQL query examples with descriptions. Query Entry Example What It Does select * from ARCHIVE.JACESIM_SERVICES_AUDITLOGSERVICE where source not like 'position' Lists all fields (*) for all audit log records, except those related to repositioning objects. select username,tstamp,auditaction from ARCHIVE.JACESIM_SERVICES_AUDITLOGSERVICE where username='admin' Lists only the fields specified (in that particular order, for all audit log records for user “admin.” select * from ARCHIVE.JACESIM_SERVICES_AUDITLOGSERVICE where tstamp>'2002-07-12 Lists all fields (*) for all audit log records that have timestamps after midnight, July 12, select * from archive.demoR2_sim_logicscreens_energymgmt_oaolog where value='true' For station demoR2. Lists all fields (*) for records of the BinaryLog object OAOLog created by a transition to On (true).
