Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

LBI Report Users II

Sort:
You are not authorized to post a reply.
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
12/5/2011 5:04 PM
    Hey all:

    I think I need to start a new post, to get back to the original question asked by Jan. Where to find the Report Users?

    I've been able to find the Report Users that are configured on the main Report screen, but when you go to set up a schedule, these (can be) a different set of report users. My PM really needs the set of report users associated with the schedule to do an efficient job of cleaning up our reports.

    Which tables can I (an possibly Jan) look to find this information?

    Many thanks,
    -Greg
    David Levine
    Basic Member
    Posts: 6
    Basic Member
    2/16/2012 9:09 PM
      Hello Greg,

      By "Report Users", can I assume you mean users subscribed to receive scheduled reports? If so, I believe subscribed reports are found in rsuserprd.ers_distributionoptions. Joining to rsuserprd.ers_reportaccess on reportid, to retrieve "accessvalue" seems to do the trick.

      HTH
      David
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
      2/24/2012 2:10 PM
        Thanks, David. I think this will work for me! Appreciate it!
        ric9d
        Veteran Member
        Posts: 76
        Veteran Member
        7/19/2012 1:20 PM
          Does anybody know which table contains the data for scheduled jobs? For example I have a sched_job_1 that runs every 15th of the month at 3:00AM, Which table contains 15th, 3:00AM,etc?
          Matthew Nye
          Veteran Member
          Posts: 514
          Veteran Member
          7/19/2012 1:29 PM
            https://www.lawsonguru.co...ft/6991/Default.aspx
            If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
            ric9d
            Veteran Member
            Posts: 76
            Veteran Member
            7/19/2012 4:55 PM
              THANKS! Awesome......
              ric9d
              Veteran Member
              Posts: 76
              Veteran Member
              7/19/2012 7:55 PM
                Does anybody know how to convert that long number to date time?
                Fieldname: NEXT_FIRE_TIME; Sample value: 1564826460000
                Matthew Nye
                Veteran Member
                Posts: 514
                Veteran Member
                7/19/2012 7:59 PM
                  i tried a few times with minimal luck. post back when you figure it out though. i think its related to UNIX time or something.
                  If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
                  John Henley
                  Senior Member
                  Posts: 3348
                  Senior Member
                  7/19/2012 8:00 PM
                    https://www.lawsonguru.co...scheduler-datetimes/
                    Thanks for using the LawsonGuru.com forums!
                    John
                    ric9d
                    Veteran Member
                    Posts: 76
                    Veteran Member
                    7/30/2012 5:30 PM
                      That worked. Thanks everybody
                      You are not authorized to post a reply.