How to Report the Key Value (Tag Values) for Cloud Servers?

Will O
Kilo Sage

We tag cloud servers in our environment, and I am trying to create a ServiceNow report to show those cloud servers with their specific Key Values.  For example, the server may be tagged with the "application ID" and it would be extremely helpful to show that tag value along with the Server name (and other Server CI data) in a report for teams. 

 

The actual "Key Values" appear to be related to the Virtual Machine Instance and not the Server CI. 

I have tried to create a report starting on the cmdb_key_values table, which returns the Key Values but there is no way to relate back to the actual Server CI. 

 

I have also tried to create a report starting on cmdb_rel_ci (using the Virtualized by::Virtualizes relationship Type), which returns the Server (Parent) and related Virtual Machine Instance (Child), but there is no way to relate to the Key Values table and out put the Key Value fields. 

 

Here are a couple of articles I have read through, but do not appear to contain the information I am needing. 

 

Tables I have tried using in my report: 

  • cmdb_key_values
  • cmdb_rel_ci
  • cmdb_ci_vm_instance
  • cmdb_ci_win_server

 

I feel like I'm missing something very obvious, but I cannot figure this out for the life of me. 

Thank you for reading and for the help!

1 ACCEPTED SOLUTION

Will O
Kilo Sage

For anyone stumbling across this post with a similar need, I have a quick update. 

 

ServiceNow Support's suggestion was to create a database view containing the tables required for the report.

Database views (servicenow.com)

 

I also created something in CMDB Query Builder to show the information.

Build a CMDB query using the CMDB Query Builder (servicenow.com)

CMDB Query Builder - Support and Troubleshooting (servicenow.com)

View solution in original post

2 REPLIES 2

Will O
Kilo Sage

For anyone stumbling across this post with a similar need, I have a quick update. 

 

ServiceNow Support's suggestion was to create a database view containing the tables required for the report.

Database views (servicenow.com)

 

I also created something in CMDB Query Builder to show the information.

Build a CMDB query using the CMDB Query Builder (servicenow.com)

CMDB Query Builder - Support and Troubleshooting (servicenow.com)

MohammadsadP
Tera Contributor

Hey Will,

 

Can you please elaborate how did you create a database view for this scenario?

 

I am also stuck for the same.

 

Thanks