View list of Virtual Machines discovered under a cloud account

[Jacob26]

On the discovery dashboard, I can see that I'm discovering 700 VMs under one of our AWS accounts, but I cannot see a list of the VMs that were discovered. We discover several accounts and I'd like to see the list of VMs discovered by a specific schedule, or that are related to this specific account. I cannot find a way to do this, even with the Cloud Operations Workspace.

Any help is greatly appreciated!

[Rahul Priyadars]

when u say virtual machines - Are you referring o Hosts which is discovered using IP Based Discovery?

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0864549

Regards

RP

[Jacob26]

Hi Rahul, thanks for your reply. I'm referencing the cmdb_ci_vm_instance table populated by cloud discovery. I am discovering all VM instances under a specific cloud account, and I'd like to see that list of VMs that are related to that cloud account. We discover multiple accounts and sub accounts so it would be valuable to see in the CMDB which VMs are under which accounts. Or at least if I can tell which discovery schedule is populating them, that would be helpful as well.

[Rahul Priyadars]

Are you looking for this ..Seems it may help you

https://www.servicenow.com/community/itom-forum/map-service-account-to-a-resource-discovered-from-cl...

https://www.servicenow.com/community/itom-forum/how-to-link-azure-subscriptions-to-a-ci-that-was-dis...

Regards

RP

[Jacob26 · Accepted solution]

Thank you for you reply. I have reviewed these threads, and I also came to the conclusion that Cloud Operations workspace would be what I needed. But I could not find any documentation or discussion posts that tell me what table stores relationship between the CIs and the AWS accounts.

I could see in the workspace that this is available under the dashboards section. You have to click one of the bars in the report titled "Configuration Items by Cloud Service Accounts". But this will show more than VMs, so you will need to filter on only VM Instance CIs, but there doesn't seem to be an option to filter.

So I searched for any tables with a label of "Cloud Analytics" since that was the title at the top of this list view and sure enough I ended up finding the table. It's called "sn_disco_cd_analytics" for anyone else who this might help. I was able to access the list view for this table and filter on only VM Instance CIs for my AWS account, worked like a charm 🙂

Wishing there was some better technical documentation of this plugin, but we are getting by for now. Thank you again for taking the time to reply.