Hi,
Can I make an internal reporting CMDB.
anyone know SQL query for CMDB report( not import/export).
Reporting for CMDB
Moderator: crythias
-
- Znuny expert
- Posts: 171
- Joined: 24 Apr 2013, 12:29
- Znuny Version: OTRS3.3
- Real Name: kalyanachakravarthy M P
- Company: TATA Technologies
- Location: Pune,India
- Contact:
Re: Reporting for CMDB
as you did not specify which kind of report, no
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny expert
- Posts: 171
- Joined: 24 Apr 2013, 12:29
- Znuny Version: OTRS3.3
- Real Name: kalyanachakravarthy M P
- Company: TATA Technologies
- Location: Pune,India
- Contact:
Re: Reporting for CMDB
hi jojo,jojo wrote:as you did not specify which kind of report, no
how to find all details cmdb. using sql query.
Re: Reporting for CMDB
the CIs are saved as a stripped XML inside the database.
For getting a list of all CIs with values you have to use the import/export module
For getting a list of all CIs with values you have to use the import/export module
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny expert
- Posts: 171
- Joined: 24 Apr 2013, 12:29
- Znuny Version: OTRS3.3
- Real Name: kalyanachakravarthy M P
- Company: TATA Technologies
- Location: Pune,India
- Contact:
Re: Reporting for CMDB
hi jojo,jojo wrote:the CIs are saved as a stripped XML inside the database.
For getting a list of all CIs with values you have to use the import/export module
import/export module working fine , but we are using cmdb Database ,any help regard sql query cmdb dabase