Extracting information with the Reporting tool

[Legacy User]

In our reporting tool , we need to get the exact details for a day in future or past , What job ran that day , what was their frequency etc. 
But currently we don't have these fields there in reporting tool. Could you please help us to show how to get the reports. 
We need to get the details as we have a maintenance this weekend on UC4 system and details required so that we can align with business accordingly.

A - Create a query file

1 - Use the graphical interface of  the reporting tool (ucyrepg.jar) to choose the information you want to see in the report.

https://us.v-cdn.net/5019921/uploads/editor/53/dvp14s11by46.png" width="548">

Set the objects, hosts, etc. which should be included in the report :
https://us.v-cdn.net/5019921/uploads/editor/ri/aecffnyfixja.png" width="545">

Set the output file parameters :

https://us.v-cdn.net/5019921/uploads/editor/d4/chualifkctcg.png" width="515">


The query .xml file will be generated in Utility/bin/queries directory.

https://us.v-cdn.net/5019921/uploads/editor/no/7xp38vfr6prx.png" width="697">

Example of an xml file:

https://us.v-cdn.net/5019921/uploads/editor/gj/rr2rxd914vj3.png" width="473">

B - Generate the report

Run UCYBDBRT with the xml file as an input parameter. You can define the name of the output file as well.

example :

C:\Automic\V12\Utility\bin>ucybdbrt -XC:\Automic\Utility\bin\queries\stats.s.xml -OC:\Automic\Utility\bin\queries\output.csv

The output will look like this:

https://us.v-cdn.net/5019921/uploads/editor/5n/onzd9ri5jzh1.png" width="1027">

C - Revision Report

You may also be interested in the Revision Report to collect statistical information of objects.


Best regards,
Antoine

[Legacy User]

As this question came in a recent support ticket, here's how to produce a Forecast report with the DB reporting tool:


Pre-requisite: the AutoForecast must have been configured and executed at least once in the AE system.

Set the key 'AUTO_FORECAST_PREFIX' in UC_CLIENT_SETTINGS.


Open an  window:
 https://us.v-cdn.net/5019921/uploads/editor/x6/u64nx806q721.png" width="1021">

Select the object types, Agent types and period for which the forecast should be executed, then press 'Recalculate' (this will create the UC_AUTO_FORECAST variable if it did not already exist), then 'Execute Query'.

You will then get a list of planned tasks for the defined period:

https://us.v-cdn.net/5019921/uploads/editor/u8/sa7ia99lih25.png" width="722">


Once the autoforecast has succesfully run you may create a 'Forecast' query using the Reporting Tool:

https://us.v-cdn.net/5019921/uploads/editor/wz/omzzig64eacl.png" width="320">

Steps to generate the report are then similar to those described in the first message above.

Best regards,
Antoine

[SrikanthGubba604621]

I got a requirement for automate the report for the aborted jobs history for particular users from previous day to current day  (from the current time to until 24 hours past ), I could not able to find all the required fields which I need in available fields .  

Please help on this aborted jobs history report.

Thanks,
Sri

[marc broussard]

hello
these kind of request can help I think

it is ok for the JOBS
you got all the information, just choose !



select *
from AH
where AH_Otype = 'JOBS'
and ah_client = '<your client>'
and AH_Status between 1800 and 1899
and AH_Timestamp4 > DATEADD(HH, -24, GETUTCDATE())