Check the number of order lines

You can run an SQL query to check how many order lines you have in your system. If you have custom order statuses, you might need to adjust the status clause of the query accordingly.

Pre-enablement of HCL Commerce RVU Order Line Metrics

To find out the number of lines you have before HCL 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);
Note: From HCL Commerce Version 9.1.12.0 and onwards, the RVU Order Line Metrics utility is called the License Metrics utility. For more details, see Check the number of order lines.
startDateTime and endDateTime represent the time range of interest.

Enablement of HCL Commerce RVU Order Line Metrics

To find out the number of lines you have after HCL 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.