Extracting information with the Reporting tool

Discussion created by Antoine_Sauteron_1266 on May 18, 2017
Latest reply on Aug 1, 2017 by Antoine_Sauteron_1266
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.


Set the objects, hosts, etc. which should be included in the report :

Set the output file parameters :


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


Example of an xml file:


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:


C - Revision Report

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

Best regards,