SeanHoppe.com > CLEO Tips > Cleo EDI Integrator List Active Messages Classes and the TPs That Use Them
List Active Messages Classes and the TPs That Use Them
12th April 2016
Every EXTOL customer has message classes that are no longer being used. A simple way to list active message classes is by querying EXLLMQL3.
select LMTPC1, LMMSCL,LMVRLM, COUNT(LMMSCL) as count from EXLLMQL3 group by LMMSCL, LMTPC1,LMVRLM
ORDER BY COUNT DESC
By: Sean Hoppe on