{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Customers can leverage CLI to run queries against Cloudaware CMDB. The article provides query examples for common use cases.","type":"text"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"minLevel":{"value":"1"},"maxLevel":{"value":"6"},"outline":{"value":"false"},"type":{"value":"list"},"printable":{"value":"false"}},"macroMetadata":{"macroId":{"value":"2675d7c5-9343-4a08-9b01-c909ee4e93d3"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"d63c53b7-9cdb-4e61-bda6-23ce1ffb8f47"}},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"Retrieve a list of EKS deployments using CLI ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"DevOps teams require complete visibility into Kubernetes infrastructure. Using Cloudaware CLI, DevOps engineers can query all EKS deployments across multiple EKS Clusters, AWS Regions and Accounts with a single query. ","type":"text"}]},{"type":"codeBlock","content":[{"text":"sf data query --query \"SELECT Name, CA10A1__cluster__r.Name, CA10A1__account__r.Name FROM CA10A1__CaAwsEksClusterDeployment__c\" --target-org ","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"Update an application catalog with Cost Center data ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Cloudaware maintains a complete application catalog with an entire cloud resource inventory for each application. FinOps teams often customize the application attributes using additional fields such as Cost Center, Product, or Product Line in order to filter and group spending not only by Business Application but also by Business Product or Product Line. Using CLI, FinOps engineers can quickly retrieve and update application attributes and even link applications to other entities in CMDB. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Here is a sample use case:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Get AWS EC2 Instances with Cost Center and Product data attached to a specific Cloudaware Application and save the result in a CSV file on your device:","type":"text"}]}]}]},{"type":"codeBlock","attrs":{"language":"none"},"content":[{"text":"sf data query --query \"SELECT CA10__applicationName__c, (SELECT Name, Id, Cost_Center__c, Product__c FROM CA10__AWS_EC2_Instances__r) FROM CA10__CaApplicationTier__c WHERE CA10__applicationName__c = ''\" --target-org --result-format csv > output.csv","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Modify the CSV file you have saved the query result in and perform a bulk update using the modified CSV:","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"sf data upsert bulk --sobject CA10__CaAwsInstance__c --file /UpdatedValues.csv --external-id Id","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"Get a list of current and past public IPs across multiple cloud providers","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Security incident response often begins with an investigation to track down public IP address ownership. Using CLI, SOC team members can quickly search for all public IP addresses currently allocated across three different cloud providers. ","type":"text"}]},{"type":"codeBlock","content":[{"text":"* AWS\nEC2 Elastic IPs:\nsf data query --query \"SELECT Name, CA10__instanceId2__c, CA10__account__r.Name, CA10__regionName__c FROM CA10__CaAwsElasticIp__c WHERE CA10__instanceId2__c != NULL AND CA10__type__c = 'Public IP'\" --target-org \nEC2 Public IPs:\nsf data query --query -q \"SELECT CA10__publicIpAddress__c, Name, CA10__instanceId__c, CA10__account__r.Name, CA10__stateName__c, CA10__regionName__c FROM CA10__CaAwsInstance__c WHERE CA10__publicIpAddress__c != NULL\" --target-org \n \n* Azure\nsf data query --query -q \"SELECT Name, CA10__associatedResourceId__c, CA10__associatedResourceType__c FROM CA10__CaAzurePublicIpAddress__c\" --target-org \n\n* Google\nsf data query --query -q \"SELECT CA10__address__c, Name, CA10__googleId__c, CA10__project__r.Name, CA10__regionName__c FROM CA10__CaGoogleGceStaticAddress__c\" --target-org ","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"Get a list of incidents related to a specific asset and take action","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Using Cloudaware CLI, engineers can retrieve incidents related to a specific asset and update incident details. Here are sample queries:","type":"text"}]},{"type":"paragraph","content":[{"text":" Get an incident related to an AWS Lambda Function and update the incident severity:","type":"text"}]},{"type":"codeBlock","content":[{"text":"sf data query --query \"SELECT Id, CA10__incidentId__c, CA10__severity__c FROM CA10__CaIncident__c WHERE CA10__awsLambdaFunctionArn__c = '' LIMIT 1\"","type":"text"}]},{"type":"paragraph","content":[{"text":" WHERE","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" - a placeholder of the name of the application that is queried","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Update the incident severity to ‘High’. ","type":"text"}]},{"type":"codeBlock","content":[{"text":"sf data update record --sobject CA10__CaIncident__c --record-id --values \"CA10__severity__c=High\"","type":"text"}]},{"type":"paragraph","content":[{"text":"WHERE","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" - a placeholder of the record ID for the incident returned from the previous query","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"Query all cloud services used by a specific application ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"When a cloud provider is having an outage, Cloudaware assists in establishing immediate business impact. Using CLI, engineers can quickly retrieve a list of computing resources that are unavailable to perform business service recovery in failover region.","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"1) Use Child Relationship Names in sub-queries","type":"text"}]},{"type":"paragraph","content":[{"text":"Find a necessary Child Relationship Name by executing the following command for a Parent object:","type":"text"}]},{"type":"codeBlock","content":[{"text":"sfdx force:schema:sobject:describe -s -u ","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"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:","type":"text"}]},{"type":"codeBlock","content":[{"text":"sf data query --query \"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 = ''\" --target-org ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"WHERE","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"CA10__AWS_EC2_Instances__r","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"CA10__AWS_S3_Buckets__r","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"CA10__AWS_EBS_Snapshots__r","type":"text","marks":[{"type":"code"}]},{"text":" - application attachable objects (see more ","type":"text"},{"text":"here","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/DOCS/pages/3181412356"}}]},{"text":")","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" - a placeholder of the name of the application that is queried","type":"text"}]}],"version":1}

Browser not supported