Check the number of order lines

We can run a SQL query to check how many order lines you have in your system.

Pre-enablement of WebSphere Commerce RVU Order Line Metrics

To find out the number of lines you have before WebSphere Commerce RVU Order Line Metrics is enabled, run this SQL query:

select count(orderitems_id) from orderitems where orders_id in (select orders_id from orders
where status not in ('P', 'N', 'Q', 'T', 'W', 'Y', 'Z', 'NEW', 'RDY', 'CAN') and timeplaced is not null 
and timeplaced > startDateTime and timeplaced < endDateTime);

startDateTime and endDateTime represent the time range of interest.

Enablement of WebSphere Commerce RVU Order Line Metrics

To find out the number of lines you have after WebSphere Commerce RVU Order Line Metrics is enabled, run this SQL query:

select sum(linecount) from ordaudit where 
timeplaced > startTime and timeplaced < endDateTime;

startDateTime and endDateTime represent the time range of interest.

Related tasks
Running the WebSphere Commerce RVU Order Line Metrics logger utility