How to get Duration of Running Instances without using Query Builder

[former_member316829]

Hello Experts,

I have a requirement to find out and setup an alert, if the instances on the platform are running for more than 2 hours. Lets say an instances started running on 21st June at 12:00 am, so at 2:00 am , an alert via email or something should be created with the instance details.

Using query builder I was able to find out these details manually, but this has to be automated so that it is monitored continuously. Kindly suggest. Thank you.

[former_member618411]

Hi Deepak,

Did you find a solution already?

I haven’t really had an opportunity to implement, but, you could try an approach with Java SDK and/or REST Web Services SDK. Since you already have the query, from query builder, you can retrieve the run-duration data using same query with SDK. Then, verify in your code, if run duration is more than two hours and notify via email if it does. (e.g. using JavaMail API).

You can schedule this as an hourly task (e.g. on task scheduler if you are on Windows, or a third party scheduler used in your org). This will send out hourly email on list instances running for more than 2 hours. Admittedly, this is more of a status notifier than alert. To have it as an alert, you will have a schedule the task at shorter intervals (every 5 mins may be). In my opinion that could be an overkill, but I will have to leave it to you to determine a ‘best fit’ depending upon your server landscape.

I found this thread on 'Destination details in Schedules' that you can refer: https://answers.sap.com/questions/4499368/retrieve-webi-report-schedule-info-destination-fro.html

Regards,

Arindam

[daniele_tiles2]

Hi Deepak

if you have BO BI 4.2 you can try, if you have installed the driver to access the audit, to make a Webi report on the audit dB... and schedule it.

Hope this helps

Daniele Tiles

[former_member316829]

Hi Daniele

We have BI4.1 SP9, I have the audit universe, but I am not able to figure out the event which will give me the details about the Running instances. Which objects from Audit do I use to get the running instances. Thank you.