LBI users report?

Legacy Contributor

We have a randomly assigned "e-id" given to employees at hire and that # is what they use for system access. This e-id is what I use when setting up employee device types/email addresses in LBI. We are starting to expand our use of the auto-generated reports using LBI, so my list of devices is growing rapidly. I would like to write a Crystal or Access report (ODBC) that has all my devices and the emails assigned to them for audit purposes. Does anyone know what table the information on LBI device types is stored in? Thank you!

delliott

Delivery device information is stored in the LawsonFS database, in the EFSDeliveryUsers, EFSDevicePrefs, EFSDevices, EFSDeviceTypes, EFSDocProps, and EFSDocuments tables. (They're not too complicated, the relations are easy to figure out.)

For instance, here's a query to retrieve all the delivery addresses, their device name, and their owner:

SELECT address, docname, owner_name
FROM efsdeliveryusers
JOIN efsdocuments on efsdocuments.ownerid = efsdeliveryusers.ownerid
JOIN efsdevices on efsdevices.docid = efsdocuments.docid
ORDER BY owner_name