Report on cloud inventory

Madhu5
Tera Contributor

Hi All,

I have a requirement where a report should be generated combining all the three tables, service account, logical datacenter, VM, Tags

I dont find any common fields between these tables to create database views. Could someone help me with this requirement.

1 ACCEPTED SOLUTION

Best to give more information in your questions so there's no need to have multiple replies.

if tags is the only thing missing, there's views shipped with the same app that link tags to the VM (and other resource types).

below i filtered only for VMs in the database views table listing, but you get the general idea.

find_real_file.png

Yes you can surely build and share your custom reports using PA reports.

with the sn_disco_cd.user role the user can view the data too.

if you wish to build custom pages in cloud operations workspace you have to use ui builder - that would take some understanding of the page layout. this is not supported or  documented.

View solution in original post

7 REPLIES 7

SiD2
ServiceNow Employee
ServiceNow Employee

Hi Madhu,

Try exploring CMDB Query Builder which works based on the CI relationships. All above CIs will surely have some relations created and can be generated in a report.

 

Please mark Helpful / Accept Solution so that it helps others with similar questions.

Please mark Helpful / Accept Solution so that it helps others with similar questions.

Madhu5
Tera Contributor

Hi @SiD,

Reports should be accessible to the end users, can we use query builder in such case? They want few fields in all the four tables in a list view. Also the relationship between these tables is a scripted one and not through any fields.

Can u help me if a query has to be built, then how should I start.

Ram Devanathan1
ServiceNow Employee
ServiceNow Employee

there's a much simpler approach than what's suggested here.

install the cloud operations workspace store app or Performance Analytics content pack for Cloud Resources. these are free apps if you are a discovery/cpg customer. with this, you will get new tables with references to the same CIs, that link the fields. see screenshot below.

Ram

find_real_file.png

Hi @Ram Devanathan 

I already have this workspace installed. Can we add tags(key value) table also along with this. And does this provide export capability?

Could you please share me the steps to create my own report as I dont find an option in the cloud operations workspace.

can we share this report with some itil users? or how this works.