• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Delivery Device Audit

 2 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
5/24/2013 1:24 PM
Thanks! Just what I was looking for.