DQAR app 2017-10-26T15:58:30+00:00

Data Quality Automation & Reporting app


This is the working name for the first public release of the Splunk app “EL Data Quality Automation & Reporting by UMBRiO” (DQAR). The working name is self-explanatory with respect to the functionality made available in the current release of DQAR. More functionality will be added to DQAR in the next 12 months through several releases.

High-level functionality overview

CMDB-to-ITSI (DQAR) provides both an easy way for Splunk to consume CMDB data and to meaningfully use that data in ITSI.

Who benefits from this app?

CMDB-to-ITSI (DQAR) is for Splunk ITSI customers that want to define Services based on their CMDB (in the meaning of ITIL configuration management database). It is also beneficiary to ITSI users wanting to leverage specific meaningful CI-data from the CMDB.

DQAR will speed up ITSI delivery. It will also strongly improve the quality of your ITSI deployment by making your service definitions relevant.

Applicable CMDB’s

Current release is applicable for HP Enterprise (now Micro Focus) uCMDB (recent versions) and ServiceNow (recent versions).

Key features of the app

Getting CMDB data into Splunk indices is pretty straightforward by using the Universal Forwarder or the ServiceNow TA. This first release of DQAR takes that data and transforms it into logical and human readable stateful Kvstore’s.

Also, if you are familiar with ITSI you will probably have experienced that a certain complexity gets in play related to Services, Depending Services and (related) Entities. Another complexity has to do with the required impact perspective with regard to the configuration management data. DQAR enables a user to configure that required perspective of CMDB data which then automatically gets extracted from the stateful Kvstore’s. Resulting in one stateful Kvstore that contains all the Services, Depending Services and (related) Entities ready for direct and easy digestion by ITSI!

Lastly the flexibility of ITSI allows you to define Services and depending Services manually. Though very useful you will want to know if these compare to the CMDB data. DQAR compares the ITSI Services with the CMDB perspective it is supposed to comply to and reports any deviations or irregularities.


Highlights of this app presented as a short manual

1. Ready to use Reports with new “dqarmaintainstore” search command for automatically adding, updating and deleting .kvstore’s based on an “action” field.

2. Multi-tenant configuration screen to define the groups of Kvstores that combined.

3. ITSI expects to see the so-called impact perspective. Each data group can have its own perspective definition in where those CI-classes and relationships are configured that should go to ITSI. For each of the CI-classes one can define whether this should result in an ITSI Service, Entity or Both.

4. After running the CMDB-to-ITSI engine the output is a directly by ITSI consumable Kvstore containing all Services, depending Services, (related)entities and Info and Alias fields for the entities.

5. Thirdly the flexibility of ITSI allows you to define Services and depending Services manually. This is great but you want to know this compared to what is within the CMDB. DQAR compares the ITSI Services with the CMDB perspective that it should have and report about found deviations.

6. As the CMDB-to-ITSI engine can be scheduled to keep ITSI in sync with the CMDB perspective wanted you can follow the activity by looking at the dashboard. This dashboard shows you how many updates or deletions were found and which ITSI Services needs action because they are found within CMDB.

Current version: 1.01

About the current version:

  • Minor problems have been fixed.
  • props.conf stanzas and corresponding transforms.conf for getting HPE uCMDB data into Splunk.
  • A new search command “dqarmaintainstore” which based on the input will Add/Update/Delete content from the given Kvstore.
  • Methodology and “saved searches” to integrate ServiceNow and HPE uCMDB CMDB into stateful Kvstore’s.
  • Web-based configuration for defining the wanted CMDB perspective.
  • The CMDB-to-ITSI engine that takes that perspective together with the CMDB inputs and transforms that into information that is ready for consumption by ITSI.
  • Comparison and reporting about ITSI Services that are not available within the wanted CMDB perspective.


Please fill out the contactform below, or send us an email and we'll get back to you.

E     dqar@umbrio.com