• Replies 9 replies
  • Subscribers 338 subscribers
  • Views 111 views
  • Users 0 members are here
Related

Reassigning a scheduled report

Jeanne DeVore
$organization

A user needs to be able to change the schedule of a report which was originally scheduled by another user. Since users can only see reports they themselves scheduled (unless they’re in the admin group), this doesn’t appear to be possible. So the question becomes is there a way to reassign a scheduled report to someone else, or is our only option to delete the schedule and recreate it?

 

I can always change it as System Admin, but I’d love for this sort of thing to be self-service.

 

Thanks!

 

Jeanne

 

 

Jeanne DeVore | Technology Manager
Chicago Shakespeare Theater

312. 667.4943 direct line  | 312.403.0314 mobile | www.chicagoshakes.com | facebook | twitter
800 East Grand Avenue on Navy Pier | Chicago, Illinois 60611

 

 

 

Parents
  • $organization

    Brilliant, Fernando, that worked a treat! Thanks so much.

     

    Jeanne

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Fernando Margueirat
    Sent: Thursday, October 22, 2015 2:03 PM
    To: Jeanne DeVore
    Subject: RE: [Tessitura Technical Forum] Reassigning a scheduled report

     

    Jeanne

     

    I’m not sure if this works, but you can try it in test.

    ·         Find the id for the report request linked to the schedule (SELECT request_id FROM gooesoft_report_schedule WHERE name = ‘the name of your schedule’)

    ·         Change the user id for the report request (UPDATE gooesoft_request SET user_id = ‘new user’ WHERE id = the id you find in the step above)

     

    Fernando Margueirat
    Senior Business Analyst
    The National Ballet of Canada
    470 Queens Quay West
    Toronto, Ontario
    M5V 3K4
    P: 416 345 9686 x453
    F: 416 345 8323

    http://national.ballet.ca

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeanne DeVore
    Sent: Thursday, October 22, 2015 1:55 PM
    To: Fernando Margueirat <FMargueirat@national.ballet.ca>
    Subject: [Tessitura Technical Forum] Reassigning a scheduled report

     

    A user needs to be able to change the schedule of a report which was originally scheduled by another user. Since users can only see reports they themselves scheduled (unless they’re in the admin group), this doesn’t appear to be possible. So the question becomes is there a way to reassign a scheduled report to someone else, or is our only option to delete the schedule and recreate it?

     

    I can always change it as System Admin, but I’d love for this sort of thing to be self-service.

     

    Thanks!

     

    Jeanne

     

     

    Jeanne DeVore | Technology Manager
    Chicago Shakespeare Theater

    312. 667.4943 direct line  | 312.403.0314 mobile | www.chicagoshakes.com | facebook | twitter
    800 East Grand Avenue on Navy Pier | Chicago, Illinois 60611

     

     

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization in reply to Jeanne DeVore

    One idea that was used at a previous organization I was at was to have a login that was specifically for scheduled reports. That way it lives forever and anyone could access that login to setup scheduled reports or adjust scheduled reports as needed. No need to worry about reassigning them or remembering who in fact had the scheduled report if someone left the organization.

    Chris

  • $organization in reply to Christopher Cuhel

    Unknown said:

    One idea that was used at a previous organization I was at was to have a login that was specifically for scheduled reports. That way it lives forever and anyone could access that login to setup scheduled reports or adjust scheduled reports as needed. [...]

    We do the same here for any long-scheduled report, particularly daily ones: they are sent to a distribution list in Exchange, that can be easily updated (relative to report server gyrations) as staff comes and goes or distribution needs change.

     

  • $organization in reply to Christopher Cuhel

    Hey all,

    We are having this debate internally now.  Some folks want a single login to have all scheduled reports created on that is shared while others don't.  My main concern is accountability and an audit of who is making changes.  If everyone (even if part of a select group) you really have no way of knowing why a change would have been made.  Plus having to log out and back in to manage these reports seems like an extra step.  How do you guys handle that? 

    Also, isn't it against PCI to have a shared login/passwords?

    Thanks

    Mike

     

     

  • $organization in reply to Michael Knight

    Hi Michael,

    If you're on RAMP you can't share logins/passwords per the "RAMP PCI Compliant Terms of Use." Besides that, it's just generally a bad business practice for the reasons you noted.

    We email reports through the scheduler so that everyone who needs a copy, gets one.

    Good luck!

Reply Children