CMDB Reports and Exports
Extract and analyze your IT data
KaliaOps enables CMDB data export in CSV and PDF formats with automatic sensitive field protection (FieldGuard). The data quality module provides 20+ predefined rules to detect duplicates, incompleteness and obsolescence. The health dashboard shows a global score and critical entities to address.
Exporting CMDB data
KaliaOps allows exporting your CMDB data for analysis or archiving.
Exportable entities
- CMDB: Assets, applications, contracts, VLANs
- Organization: Organizations, teams, employees, sites
- Relations: Vendors, clients
Export procedure
- Go to the desired module (Assets, Applications, etc.)
- Apply filters to select data (optional)
- Click "Export"
- Choose the format (CSV or PDF)
- Download the generated file
Asynchronous export
For large volumes:
- Export is processed in the background
- Notification when ready
- File available in "My exports"
Available formats
CSV format
Ideal for:
- Analysis in Excel or Google Sheets
- Import into BI tools (Power BI, Tableau)
- Data processing scripts
Features:
- UTF-8 encoding
- Semicolon separator (Excel-compatible)
- ISO 8601 dates
PDF format
Ideal for:
- Governance reports
- Official documentation
- Audit archives
Features:
- Formatted tables
- Header with date and filters
- Pagination
Sensitive field filtering
FieldGuard automatically protects sensitive data during export.
Protected fields
| Entity | Fields | Required permission |
|---|---|---|
| Contracts | Annual, monthly, total costs | contracts.field.cost |
| Vendors | Bank account, SIRET, VAT | vendors.field.bank |
| Users | Password, 2FA secret | Never exported |
How it works
During export:
- FieldGuard checks user permissions
- Non-permitted fields are masked (
***) or excluded - No impact on the user interface
Use cases
- Export for external consultants (no financial data)
- Sharing with users without admin rights
- Compliance with confidentiality rules
CMDB health rules
CMDB health rules monitor data quality.
Rule categories
| Category | Goal |
|---|---|
| Accuracy | Detect duplicates and errors |
| Completeness | Identify missing information |
| Consistency | Verify relationship coherence |
| Timeliness | Detect obsolete data |
| Compliance | Check against internal policies |
Predefined rule examples
- duplicate-serial-numbers: Assets with same serial number
- duplicate-ip-addresses: Duplicate IP addresses
- datacenter-asset-without-rack: Datacenter assets without rack position
- application-without-organization: Orphan applications
- warranty-expiring-soon: Warranties expiring in 30 days
- contract-expired: Expired contracts
- stale-assets: Assets not updated in 90 days
Health dashboard
The health dashboard provides a global CMDB quality view.
Access
Menu CMDB → Health
Displayed indicators
- Global score: Overall CMDB quality percentage
- Violations by severity: Critical, Warning, Info count
- Violations by category: Distribution by rule type
- Trend: Evolution over 30 days
Violation list
For each violation:
- Affected entity (name and link)
- Triggered rule
- Severity
- Detection date
Filters
Filter violations by:
- Severity (Critical, Warning, Info)
- Category (Accuracy, Completeness, etc.)
- Entity type
- Status (Open, Acknowledged)
Managing violations
Severity levels
| Level | Description | Recommended action |
|---|---|---|
| Critical | Data quality issue impacting operations | Resolve within 24 hours |
| Warning | Non-blocking anomaly | Resolve within 1 week |
| Info | Suggestion for improvement | Scheduled improvement |
Resolving a violation
- Click on the violation to view details
- Access the affected entity
- Correct the data (add missing info, remove duplicate)
- The violation disappears at next scan
Acknowledging a violation
If a violation is not fixable or accepted:
- Click "Acknowledge"
- Add a justification
- The violation is marked as acknowledged
Acknowledged violations no longer impact the global score.
History
KaliaOps records health snapshots:
- Daily score evolution
- Resolved/new violations
- Trends by category
- Asynchronous export for large volumes
- Automatic sensitive data protection (costs, banking information)
- 20+ predefined quality rules (duplicates, completeness, obsolescence)
- Health dashboard with global score and critical entities
- Violations classified by severity (info, warning, critical)