Looking for Db query to get report for all jobs whose status changed from Abort status to Ended ok

[Kiran Kumar Vasanthavada]

Hello All,

I am looking for db query, The aim is to get an audit of all intervention for last 3 months done by operators on the interface such as changing status of job that have aborted to ended_ok. Automic Automation v-21.0 and database - oracle.

Please suggest me with your valuable inputs.

Awaiting your reply,

Regards,

Kiran.

[Markus Embacher]

Hi,

I recommend not to allow "Change status manually" for operators, only for administrators in exceptional cases. This feature is not meant for changing a job from aborted to ended_ok. It comes with a warning

"Changing a status manually may negatively affect the whole processing. Please check all regular ways of modifying a task condition before doing so. Are you sure that the status needs to be changed manually?"

and should be used only in case all regular features, like "deactivate tasks" do not work.

However, Automic documents such a manual change in the LOG report of the task:

U00011141 Task status has been modified manually by user 'ME891367/BRCMLTD': From 'ENDED_VANISHED - disappeared' to 'ENDED_OK - ended normally'.

The following query gives you all RunIDs of tasks where the status was modified manually.

select rt_ah_idnr, RT_MsgInsert from rt where rt_msgnr=11141

Please note, that this only work for the last 3 months if you still have 3 months of data in your Automic database.

This query is just a basic solution, please feel free to enhance it to your requiremens.

Regards, Markus