Original Message:
Sent: May 23, 2023 09:25 AM
From: Nitin Pande
Subject: In D-series how to extract all the application events and their timings into excel format?
You can look more in to listeventschedule CLI command. Read on it here.
Nitin Pande
------------------------------
Support
Broadcom
Toronto
Original Message:
Sent: May 23, 2023 08:51 AM
From: Nitin Pande
Subject: In D-series how to extract all the application events and their timings into excel format?
You will need to work with Forecast report, no query can be provided, it's internal code.
Nitin Pande
------------------------------
Support
Broadcom
Toronto
Original Message:
Sent: May 20, 2023 02:28 PM
From: Balunkeswar Sahu
Subject: In D-series how to extract all the application events and their timings into excel format?
Tell me the SQL query to extract the next schedule of all the applications and also share the list of tables involved..
Original Message:
Sent: May 19, 2023 08:59 AM
From: Nitin Pande
Subject: In D-series how to extract all the application events and their timings into excel format?
Like I mentioned, we only keep next schedule run in DB. That's how DE runs and is the most efficient architecture. Forecast report run out side of DE, so you can increase memory, but OS must be able to support it. In Desktop client->Admin Perspective->Topology->Shared Parameters->Internal->Advanced-> maximum memory available to a reporting process(in megabytes). Increase it to 1024. Also, you need to have at least 25 runs of the application for forecast report.
HTH,
Nitin Pande
------------------------------
Support
Broadcom
Toronto
Original Message:
Sent: May 18, 2023 06:22 PM
From: Balunkeswar Sahu
Subject: In D-series how to extract all the application events and their timings into excel format?
Hi,
Forecast reports are too slow and when I am not specifying any filter, it keeps on running and gets stuck eventually. I want to see all of Applications' future schedules for all the applications and for all the jobs within these applications. So, please tell me how to get all these data and from which tables. I want to get all the applications' future timings not past timings. If it's in XM: format also, please let me know how to get that XML file and how to load that XML file into some database for easy reading. Please reply soon.
I meant to ask here that, if I want to see what the applications and jobs scheduled for next 7 days or on some date like 30th of month. or I want to know list of applications and jobs along with their timings on future dates.
Please tell some other ways except FORECAST as FORECAST reports are damn slow and these are good for nothing.
Original Message:
Sent: May 16, 2023 05:15 PM
From: Nitin Pande
Subject: In D-series how to extract all the application events and their timings into excel format?
By future, did you mean next n (n being 10, 20 etc) number of generations?
If so, then we only store the next generation in DB. Each time event runs, it will update the next schedule. The information is in XML format, so you may want to run the Forecast report, see here
HTH,
Nitin Pande
------------------------------
Support
Broadcom
Toronto
Original Message:
Sent: May 16, 2023 05:09 PM
From: Balunkeswar Sahu
Subject: In D-series how to extract all the application events and their timings into excel format?
Thanks Nitin.
But I want to extract all the future scheduled timings for all the applications and for all the jobs and extract this information into XML or EXCEL format. I want to find all the forecast events. Can you please tell me which tables I can refer to get future forecast event details.
Original Message:
Sent: May 09, 2023 10:04 AM
From: Nitin Pande
Subject: In D-series how to extract all the application events and their timings into excel format?
Hi,
So as of now, the events are stored are in XML format. They may not be queried via any SQL statement. You can look in to this report and run application run report, if you just want to see when they ran.
HTH,
Nitin Pande
------------------------------
Support
Broadcom
Toronto
Original Message:
Sent: May 07, 2023 08:34 PM
From: Balunkeswar Sahu
Subject: In D-series how to extract all the application events and their timings into excel format?
In D-series how to extract all the application events and their timings into excel format?