By default the "Historic Jobs - by date" report is configured to show all jobs that ran in the last 7 days.
The default filter uses the following expressions:
Start Date (Date) >= TODAY-7DA
Start Date (Date <= TODAY
Which allows to list all run jobs in the last 7 days.
Users can extend the number of days covered by changing the default TODAY-7DA to TODAY-xxDA.
Example:
Start Date (Date) >= TODAY-30DA
Start Date (Date <= TODAY
Will show all jobs run in the last 30 days.
However if more flexibility is needed, and a report is needed to show all run jobs from one specific date to another, there are currently no canned reports that can satisfy these requirements.
Instead the default "Historic Jobs - by date" report will have to be modified as detailed below.
- Open NVGUI > Reports
- Right click the "Historic Jobs - by date" report and select "Edit/view job"
- In the "Report Job Editor" window that appears, double click the "Historic Jobs - by date" component in the lower "Selected components" frame
- In the "Report component editor (Class:Job History)" window that appears, locate the following 2 expressions in the "Advanced filter tree view":
Start Date >= interactive:inherit:'TODAY-7DA'
Start Date <= interactive:'TODAY'
These will need to be modified as follows by double clicking one at a time a
- Double click the "Start Date >= interactive:inherit:'TODAY-7DA'" expression
- In the "Edit filter expression" window that appears, change the expression as follows using the pull down menus under "Edit the Expression here":
Start Date (Date) = TODAY-7DA (can be left as is) > Click OK
- then double click the "Start Date <= interactive:'TODAY'" expression
- In the "Edit filter expression" window that appears, change the expression as follows using the pull down menus under "Edit the Expression here":
End Date (Date) = TODAY (can be left as is) > Click OK
- Back to the "Report component editor (Class:Job History) window, we need to save the changes, locate "Component Title" and change the default "Historic Jobs - By Date" component title
to make it unique and avoid overwriting the default one, e.g call it "Historic Jobs - start-end"
- On the top left hand corner, click the "Save and Add to job" icon to comit the changes
- Back to the "Reporting Job Editor" window, change the report "Job Title" to make it unique again, e.g. "Historic Jobs - from-to"
- On the top left hand corner click the "Save" icon and close the window
The new report is now visible under the Reports "Jobs" tab.
Double clicking it will provide a new "Set filters for report" window that allows more flexibility in reporting:
Start Date (Date) = YYYY/MM/DD
End Date (Date) = YYYY/MM/DD
