Quering Informatica Repository/Oracle

A little bit more into the woods of Informatica Repository,
things get grimmer:)

But don't be afraid ,You've set-up dblinks and You can query the repository,now what do You query to find failed sessions:
2 options :

INFORMATICA.REP_SESS_LOG

or
INFORMATICA.REP_SESS_LOGs,I prefer 1-st ,has full info:

Finally,after You're done with logging,You need a little bit coding to fetch the info and may be assemble it for a report but finally You can get something very nice with little effort(take a look at the chart bellow)