How to do a report based on the CI relationships with an AWS account?

[JPing]

Hello, 

We have recently deployed the Service Graph Connector for AWS. We have noticed that the CI tables that the AWS object are loaded to do not have a ref field to the AWS account or AWS region on them (which makes sense as those tables are not AWS specific). Our AWS admins would like to be able to view all the CI's given an account. There is CI relationship tables that tracks AWS accounts --> AWS datacenters (regions)  --> CIs. So I can click through related lists AWS account records but from the CMDB heath dashboard how do I create it so that an AWS admin can go there and just select an account and all the related CI would just show? Different AWS admins only care about certain accounts or account grouping. 

I tried looking into CMDB group - but I don't see how to leverage CI relationships.

Thanks in advance. 

[Dr Atul G- LNG]

Hi @JPing 

CI relationship gets stored un the CI relationship table, I think you need to create the report in the same and dot walk.

[JPing]

I was able to use the CMDB query builder (which leverages the CI Relationship Tables) to connect the CIs to an AWS account through the AWS Datacenter. So the results of the query is a nice table where each row is a CI and I can see which AWS account and Datacenter it is related to. I can then filter this query result on the AWS account to only see which CI that are related to that AWS account. So this is exactly what I'm looking for... but I would like this to show in the CDMB health dashboards so that the AWS admin can see the health of their CIs. 

Any suggestions on how relationships are used to build CMDB CI groups? If the "CMDB Group Contains Encoded Query" allowed me to writes a script to return all CI given some aws account number that would work, i don't see that feature. 

I am very curious if this has never come up. Do AWS admin (or the manager of AWS resources)  not use SN to view the heath of their CIs on a Account by Account level?

[Dr Atul G- LNG]

Hi @JPing 

Sorry to say, but not able to clear your doubt on this, with my limited knowledge. You can post your question : https://www.servicenow.com/community/cmdb-forum/bd-p/configuration-management-db-forum