Hi Travis,
The events are in XML format. They cannot be simply queried by SQL. In cases of upgrades and migrations, you can use Forecast reports.
Create a simple forecast report that will show you events scheduled for next few hours. See screenshot for an example:
------------------------------
[Designation]
[City]
------------------------------
Original Message:
Sent: 07-19-2019 06:15 PM
From: TRAVIS ANDERSON
Subject: Schedules from Event for all Applications in CAWADE
Hi Andy,
I have created a PowerShell script as well to extract the schedule statements plus suspend and hold count. My idea so far was to have it available for application users to have during their outages. They could look at the report to see what apps may be impacted during their outage.
Question I have is if there is a way to create a report to pull from the database itself? As you know, once you create your schedule list it is essentially out of date because event schedules could change. I was hoping to find a way to pull from the db so that anyone can run it and maybe even narrow down to their specific application groups by entering something like XYZ to get all events starting with XYZ
If it isn't possible to pull from the db then this Powershell script will assist some. I guess I could setup a job to email the app group and modify the script to only output their events. Going down that path I could see myself setting up a bunch of different jobs, one for each app group that would need the report
Original Message:
Sent: 06-12-2019 05:08 PM
From: Andy Reimer
Subject: Schedules from Event for all Applications in CAWADE
Not sure how comfortable you are with Powershell, but what we do seems to work pretty well for this sort of thing. We have a daily job that exports all the DE artifacts (Applications, Events, Alerts, Resources etc) using the Export Import utility. While these do not have a .xml file extension, they are in fact xml files which Powershell is very adept at reading. A script like this will export a list of your event schedules to a file called Schedule_List.txt
Get-ChildItem -Path D:\CAWExport\event| ForEach-Object {[xml]$xml = Get-Content $_.FullName$line = $xml.eventenum.eventsch.schedule.scheduleelement | Out-File D:\CAWExport\Schedule_List.txt -Append}
You would need to modify this because the code doesn't take into account the fact that one event may have multiple schedule elements. It also just outputs the schedules without listing the Event it came from. The text file will also have some blank lines because when it tries to process a file trigger event, that xml will not have the eventsch node.
If you go down this road I can assist a bit more, but this should get you started.
Original Message:
Sent: 05-23-2019 02:41 PM
From: kumar Guthikonda
Subject: Schedules from Event for all Applications in CAWADE
Is it possible to retrieve all Schedules for the Date-Time\Manual Events across all Applications in CA WADE?
Thanks
KG