Sample Queries

The queries shown below retrieve information from the logger tables:

Example 1. Query all logs:

select * from BDNA_A_LOGGER order by 1 desc

Example 2. Query logs for last inventory:

select * from BDNA_A_LOG_LAST_INV order by 1 desc