Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Delivery Device Audit

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
5/24/2013 12:58 PM
    I'm trying to write a delivery device audit report. Does anyone know which table and fields I would need?
    I've found the email address listed in a couple of tables and would like the login name, the delivery device name, and the address.

    Is the EFSDOCUMENTS.DOCNAME the appropriate field to use for the delivery device name?
    How do I tie that back to the login id?
    JeanneS
    Veteran Member
    Posts: 49
    Veteran Member
    5/24/2013 1:21 PM
      Greg,

      Here is the SQL from my Crystal Report which returns the RS device name, user name (under the owner) and email address:

      SELECT "EFSDOCUMENTS"."DOCID", "EFSDOCUMENTS"."DOCNAME", "EFSDEVICES"."ADDRESS", "EFSDELIVERYUSERS"."OWNER_NAME", "EFSDELIVERYUSERS"."OWNERID"
      FROM ("FSUSER"."EFSDOCUMENTS" "EFSDOCUMENTS" INNER JOIN "FSUSER"."EFSDEVICES" "EFSDEVICES" ON "EFSDOCUMENTS"."DOCID"="EFSDEVICES"."DOCID") INNER JOIN "FSUSER"."EFSDELIVERYUSERS" "EFSDELIVERYUSERS" ON "EFSDOCUMENTS"."OWNERID"="EFSDELIVERYUSERS"."OWNERID"
      ORDER BY "EFSDELIVERYUSERS"."OWNERID"

      Jeanne
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
      5/24/2013 1:24 PM
        Thanks! Just what I was looking for.