- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-19-2022 02:31 AM
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2022 11:20 PM
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-19-2022 08:26 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2022 04:22 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2022 08:43 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2022 10:21 PM
Hi
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.