Sage 100

KnowledgeSync question. Is there a way to print out a listing of events showing the details, e.g. schedule, subscribers, etc.? We have a customer with over a hundred events (all Crystal reports being emailed to different users) and they would like to know who gets what and when. Would be very nice! May have to call Don Farber but thought I would ask here first.

It looks like it should be possible to report off of KS_Object.mdb, but you would have to play around with it a bit or see if Don will give you schema docs.

Yeah, I saw that one. Thanks @PhilMcIntosh .

@ThereseLogeais, I'm not our in-house KSync guru but I did some checking on the database structure. I think you could put together a query using KS_Object.package and KS_Object_out_email and get the basics of what you are looking for. It looks like the join would be on the Package_id column. There is also a Out_Report table in the database. We don't use KSync to generate and distribute Crystal reports but I suspect you may want to incorporate this table as well if you want to limit the packages you report on to just those that involve a Crystal report. I'm not answering you question exactly but I'm hoping I to point you in the right direction. Good luck and happy hunting.

Thanks @ShawnSlavin ! It's getting me closer....

The only thing I can't quite get is the scheduling info, like when does it run? There is a Schedule table but I don't see any obvious link to Package, Out_Email, Out_Report or any other logical table for that matter. What I do have is the Event Name, those who receive it, what the actual Crystal Report name is, and the parameter information. A good start, at least.

@ThereseLogeais take a look at the table called sqlalert. I think this might be the lynch pin table. Limit the records to [Active] = 1 then tie to the Schedule table by Schedule_Id and the email table by Email_Id. This might get you closer. I think Package is a list of steps to execute for a specific alert. I think I feed you a Red Herring. Oops. No more fish tonight!

Did Farber ever call?

I think I finally have it conquered!!! Spent some time with Tricia Cate from VineyardSoft the other day and even she didn't know how to do it. I had some help from @MarcCregan and I finally figured out how to get what I need. Yay!!! It's not final yet but it is a great way to end the week!! Definitely an HSD for me!!!

@ThereseLogeais - Do you mind sharing your solution? This information would be nice to have.