SQL/LF : EXLLMQL3

Users can start with the SQL statements below, if they want to create custom usage reports: .
select LMTPC1, COUNT(LMTPC1) as count from EXLLMQL3 group by LMTPC1 ORDER BY COUNT DESC

select LMTPC1, LMMSID, LMMSCL,LMVRLM, COUNT(LMMSCL) as count from EXLLMQL3 group by LMMSCL, LMTPC1,LMVRLM,LMMSID ORDER BY COUNT DESC