Creating custom reports

Creating custom reports

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

    • Related Articles

    • Downloading and Creating system archives

      NetYCE system is backed up in two files named YCE archive Backup(NCCM) archive With these two files we can restore the system back to its previous state.  Or we can replicate the system. This article is about creating, downloading the archive. Steps ...
    • Enable debug and creating support file

      Debug mode is enabled when we need more logs to analyze any issue. In this article we shall enable debug for a Job. Debugging via GUI Enabling Debug (1) Admin -> System -> Debug Logs -> (2) Start debug -> (3) OK         Create a Job Create ...
    • Setting up LDAP authentication

      In this article we will be seeing how to setup LDAP authetnication in NetYCE.  We will be using below sample LDAP server details for the setup. LDAP Test server details LDAP Server Information:  Server:   Port: 389 Bind ...
    • Setting up High Availability

      In this article we would be setting up two instances of NetYCE that would act as Master-master relationship. Pre conditions It is assumed we already have cloned the primary server or set up a new one. If you have installed a new system (VM), make ...