Create a Custom Report of All Database Instances Through a DataView
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2023 03:56 PM - edited 09-25-2023 04:27 PM
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 |
0 REPLIES 0