SELECT TIMESTMP, USERID, TRACKING, EVENT_ID, DEVICE_ID, ENTRYSTRING AS DEVICE_TYPE, DOCUMENT_ID, DOCUMENT_TYPE, MESSAGE, DETAILS FROM ENPDELIVERYLOG, ENPBATREE WHERE TREEENTRYID = (SELECT REFERENCEID FROM ENPREFERENCES WHERE TREEENTRYID = DEVICE_ID) AND ENTRYCATEGORY = ( SELECT CATEGORYID FROM ENPCATEGORIES WHERE CATEGORYDESC = 'DeviceType')