We can create custom reports and schedule them for periodic execution. These are basically created using the SQL queries from various NetYCE databases.
NetYCE databases
Below are the 5 distinct NetYCE databases that are available each for specific function.
YCE - Has the data related to YCE/IBN database
CMDB - Has the data related to CMDB nodes
LOGS - Maintains the LOGS data
NCCM - Maintains the Backups and Compliance data
NMS - Adding custom tables can be done using this database
The respective tables of each section can be viewed in the GUI from Admin -> Custom_data
We shall create, schedule and view/download reports..
Creating Report
We are creating reports of all the CMDB Nodes
(1) Reports -> Create Reports -> (2) CMDB Nodes ->(3) New
Enter the query under Query
Preview to verify the report content
Scheduling Report
(1) Time and day of the month/weekday
(2) Email to send
(3) Save and Schedule
View/Download Report
The report can be downloaded in the CSV format.
(1) Reports -> View Reports -> (2) Select the interested report -> (3) View Report -> (4) Download
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article