PraireFyre Scheduled reports trouble viewing ALL reports and owners

[merlin215]

Hey Folks

Does anyone know how to find the list of scheduled reports that are set up ? I can see the reports but I cannot find the user associated to that report . I want to view the scheduled reports and who they are being sent to but I cannot find any place to view existing reports and scheduled users . I would think there would be a way to go in and view ALL of the scheduled reports with owners and email addresses etc .

Thx

Rich

 

[boycey9]

I had to do this once before and took the following notes, it worked and I got the info I needed but im sure since then I worked out an easier way but didnt note it down, you need to use SQL Management studio to access the database and do the following

Open Table dbo.tblReport_Schedules

locate report and note fKUser field

open Table dbo.tblconfig_ATtributes_user_Employee

Compare fKuser to the field Pkey

if they match this is the account the scheduled report is run from

 

[merlin215]

Egads! Thx Boycey9 .

I would think that PrairieFyre would make a simple user look up window to view scheduled reports and edit button to make changes to them !

I'll give it a shot and see what I come up with ,

Thanks again as I appreciate the help !!!