Active IQ Unified Manager Discussions

KPI of WFA success rate

rogerhinson
3,415 Views

Hi,

I've been given the task of creating a dashboard that includes the success rate of jobs submitted to WFA and a breakout of failures by job type.  It appears there isn't a pre-made command to achieve this and the wfa user doesn't have enough access to the WFA database to pull out this information.

Can I get the root password to the WFA database to pull this out of the right tables?  Or is there another method to get this information?

I saw somebody post that they backed up the database and then restored to a SQL database they had root privileges for, but that doesn't really sound like a repeatable process on a weekly basis.

Thanks,

Roger

3 REPLIES 3

adaikkap
3,415 Views

Hi Roger,

            Unfortunately, there isn't a way. This is being worked for an upcoming release. Untill then pls reach out to your account team to get a workaround.

As we may not able to share the root password for the WFA DB, though its unique for each instance of WFA server.

Regards

adai

ranjeetr
3,415 Views

Currently there is no REST API which list out all the jobs which can be processed further.

RadovanTuran
3,093 Views

Just started with WFA and may be there is more elegant solution.

But my first idea is to insert sucess code of earch run WF to dedicated table in playground DB.

Public