Creating CMDB Reports

There are two ways you can create new CMDB reports:

• Create a new report from scratch.
• Clone and modify an existing system or user-defined report by selecting a report and clicking Clone.

Follow the procedures below to create or modify a CMDB Report.

• Creating a CMDB report
• Cloning and Modifying a CMDB report
• Exporting a CMDB Report
• Importing and Exporting CMDB Report Definitions

Creating a CMDB report

1. Go to CMDB and select CMDB report folder from the left tree where the report has to be placed.
2. Click New. 
3. In the New CMDB Report dialog box, enter the information below.
   
   

   Settings	Guidelines
   Report Name	Name of the CMDB report.
   Description	Any information related to the new report.
   Target	Select the target type.
   Conditions	Set the filter conditions by selecting (Attributes, Operator and Value) together with Next Operators. Parenthesis can be added by clicking + to give higher precedence to any evaluation conditions.
   Display Columns	The columns in the report result. The order can be changed by selecting a column and clicking the Up or Down icons. You can specify the Order as ASC or DESC.

4. Click Save.

You can also import a report under CMDB by clicking Import to browse and choose.

Cloning and Modifying a CMDB report

You can modify user-defined reports by selecting the report and clicking Edit. However, you cannot directly edit a system-defined report. Instead, you have to clone it, then save it as a new report and modify.

1. Go to CMDB > CMDB Reports.
2. Select the system-defined you want to modify, and click Clone.
3. Enter a name for the new report, and click Save.
   The cloned report will be added to the folder of the original report. 
4. Select the new report, and then click Edit.
5. Modify the report, and click Save. 

Exporting a CMDB Report

1. Go to CMDB > CMDB Reports.
2. Select the CMDB Report folder from where the report has to be exported.
   
   
3. Click Export to download and save the report.

Importing and Exporting CMDB Report Definitions

Instead of using the user interface to define a report, you can import report definitions, or you can export a definition, modify it, and import it back into your FortiSIEM virtual appliance. Report definitions follow an XML schema.

Importing a CMDB Report Definition

1. Go to CMDB > CMDB Reports.
2. Select the CMDB Report folder where the report has to be imported.
   
3. Click Import and see the report showing up in the correct folder.

Exporting a Report Definition

1. Go to CMDB > CMDB Reports.
2. Select the CMDB report that has to be imported.
   
3. Click Export and see the report showing up in the correct folder.
4. Paste the report definition into a text editor, modify it, and then follow the instructions for importing it back into your virtual appliance.

XML Schema for Report Definitions

The XML schema for the report definition is:

<cmdbReports>
<cmdbReport>
<name></name>
<naturalid></naturalid>
<description></description>
<selectClause></selectClause>
<orderByClause></orderByClause>
<whereClause></whereClause>
</cmdbReport>
</cmdbReports>

This is an example for the Active Rules report:

<cmdbReports>
<cmdbReport>
<name>Active Rules</name>
<naturalId>PH_CMDB_Report_Overall_8</naturalId>
<target>com.ph.phoenix.model.query.Rule</target>
<description>This report captures active rules on a per organization
basis</description>
<selectClause>ph_drq_rule.ph_incident_category,ph_drq_rule.name,ph_sys_d
omain.name</selectClause>
<orderByClause>ph_drq_rule.ph_incident_category ASC</orderByClause>
<whereClause>ph_drq_rule.active = true</whereClause>
</cmdbReport>
</cmdbReports>