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.
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.