Skip to main content
Question

Automated Email for Monitoring

  • January 16, 2025
  • 1 reply
  • 28 views

lgiessler
Sidekick (Customer)
Forum|alt.badge.img+5

Hello everyone,

First of all, I apologise if there is already an entry on this and I have overlooked it. Maybe one of you has an idea how I could solve the following task:

I am looking for a way to run certain SQL queries on a daily basis and then send the results of these as a PDF by email, as part of my daily monitoring, so to speak.

I use the Smart Client for Windows in the following version:

Release: 6 Update 25
Build: 8597

My idea would have been to do this with the menu item ‘Monitor Schedules’ as a daily job, but I haven't quite figured out how to do this, or whether there might be a simpler solution to my problem.

Best regards
Lars

1 reply

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • 1142 replies
  • January 16, 2025

Hi ​@lgiessler 

At a high level, these are the steps to follow

  1. Create an RDLC report file using MS Visual Studios and create a report record in FSM using the report admin screen

     

  2. Use the ‘Notification Message' screen to create a notification message and configure that report in the notification record

     

  3. Create a ‘Scheduled Process’ to run daily (configurable) and execute perform_send_notification XML.

    <perform_send_notification>
      <parameters>
        <distr_list_id>DISTRIBUTION_LIST</distr_list_id>
        <message_name>NOTIFICATION_MESSAGE</message_name>
        <check_time_limit>N</check_time_limit>
      </parameters>
     </perform_send_notification>


That is all more or less.

 

Cheers!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings