...
Compliance: Query MTTR (Mean Time To Resolution) across all incidents for a specific team
Other use cases:
1. Use Child Relationship Names in sub-queries;
Find a necessary Child Relationship Name by executing the following command for a Parent object:
sfdx force:schema:sobject:describe -s <Parent Object's API Name> -u <Org Alias from Authentication>
2. Use the "childRelationships" key in the result to find all Child Relationship Names ("relationshipName") across all listed child objects. Get the cloud inventory of a specific Application:
| Code Block |
|---|
sfdx force:data:soql:query -q "SELECT CA10__applicationName__c, (SELECT Name FROM CA10__AWS_EC2_Instances__r), (SELECT Name FROM CA10__AWS_S3_Buckets__r), (SELECT Name FROM CA10__AWS_EBS_Snapshots__r) FROM CA10__CaApplicationTier__c WHERE CA10__applicationName__c = '<specific application name>'" -u <Org Alias from Authentication> |