Create a Report, All Database Instances DataView

[Alexis Salazar]

Hello People,

Please I need your help to create the report through data view, right now I am creating the following search, but the query does not show only BDD instances.

Thank you for your valuable contribution, I am starting in Service Now

Table	Order	Variable prefix	Where clause	Left join	Application
sam_sw_product_lifecycle	100	spl		false	Global
cmdb_sam_sw_discovery_model	200	sdm	sdm_norm_product=spl_norm_product && sdm_norm_version=spl_norm_version && sdm_norm_full_version=spl_norm_full_version && sdm_norm_edition=spl_norm_edition	false	Global
cmdb_sam_sw_install	300	ssi	ssi_primary_key=sdm_primary_key	false	Global
cmdb_ci_server	400	server	server_sys_id=ssi_installed_on	false	Global
cmdb_rel_ci	500	rdbserv	rdbserv_child=server_sys_id	false	Global
cmdb_ci_db_instance	600	dbase	dbase_sys_id=rdbserv_parent	false	Global

[palanikumar]

Hi,

This view will list all the records in the database instance table. What do you mean by BDD instances? Do you want the output to show only specific database types? then you can add filter in last join

Thank you,

Palani

[Alexis Salazar]

Hi Palani,

Thank You, for your answer.

Q. What do you mean by BDD instances?

A. I want is to show only the instances per database server.

For example: DB2 Instance, MongoDB Instance, MSFT SQL Instance, Oracle Instance.

Q. Do you want the output to show only specific database types?

A. No, I need all diferent instances Databases 

I forgot, I also need the obsolescence dates.
Is what you are doing correct? Is it the most efficient way?

Thank You