Option B - Collect statistics from SC 3.6 as a source

Objective

To gather Graph and Cassandra related statistics from the running instance of SC 3.6.

Prerequisites

1. A running instance of SC 3.6.

2. End users should not access the Syndeia Cloud 3.6 instance during the upgrade process. Only administrators should have access at this time. It is recommended that administrators notify end users about the ongoing maintenance and upgrade of the Syndeia Cloud instance.

3. cassanalyze (v 0.2) command-line utility downloaded (this is part of the Syndeia downloads).

Steps

1. Navigate to the home page of SC 3.6 where you see the Syndeia Dashboard. Scroll down to the Digital thread object count by Syndeia domain types section. You’ll see a pie chart similar to the following.

   Open

   

2. Note down the individual counts for Artifacts, Containers, Relations, Repositories, and Digital Thread Projects ex:

   Repositories: 30 Containers: 42 Digital Thread Projects: 5 Artifacts: 586 Relations: 302

3. Now note down the counts for each entity type by navigating to the Graph Queries tab and using the Query Builder drop-down to select each of the “…Types” entities

   Open

   

   Switch to the Table view modeand Record the number next to “VERTICES”. This number corresponds to the number of types.

   Open

   

   Repeat this process for ContainerType, RelationType, and RepositoryType

   Repositories: 30 Containers: 42 Digital Thread Projects: 5 Artifacts: 586 Relations: 302 Repository Types: 23 Container Types: 30 Artifact Types: 48 Relation Types: 55

4. Now, we will gather statistics from Cassandra using the cassanalyze utility which comes as a part of the SC downloads (the guide can be found here). To use this run Steps (1), (2) & (3) to gather the summary data from the Steps to run the utility / tool section of the guide. The output should be similar to as shown below. Please also note these metrics down.

   "------------- summary (begin) -------------" {:repo-summary {:repositories {:total 30, :external 29, :internal 1}, :repositories_by_uri 30}, :cont-summary {:containers {:total 42, :external 37, :internal 5}, :containers_by_external_id 37, :containers_by_external_key 37, :containers_by_repository_key 42}, :art-summary {:artifacts {:total 586, :external 586, :internal 0, :latest 576}, :artifacts_by_external_id 586, :artifacts_by_external_key 586, :artifacts_by_key 586, :artifacts_by_container_key 576, :artifacts_by_type_key 576}, :rel-summary {:relations {:total 302, :external 0, :internal 302, :latest 292}, :relations_by_external_id 0, :relations_by_external_key 0, :relations_by_key 302, :relations_by_source_key 302, :relations_by_target_key 302, :relations_by_container_key 292}, :repo-types-summary {:repository_types {:total 23, :external 22, :internal 1}}, :cont-types-summary {:container_types {:total 30, :external 29, :internal 1}, :container_types_by_external_id 29, :container_types_by_external_key 29, :container_types_by_repository_key 30}, :art-types-summary {:artifact_types {:total 48, :external 48, :internal 0}, :artifact_types_by_external_id 48, :artifact_types_by_external_key 48, :artifact_types_by_repository_key 48}, :rel-types-summary {:relation_types {:total 55, :external 0, :internal 55}, :relation_types_by_external_id 0, :relation_types_by_external_key 0, :relation_types_by_repository_key 55}} "------------- summary (end) -------------"

    

5. Graph server health check - Run the following query in the Graph Query view on the Syndeia web dashboard with the super.user.

   g.E().has( 'sLabel', 'Relation' ).has( 'container' ).group().by( 'sKey' ).by( '_isLatest' ).unfold().findAll { i -> ! i.value.contains( 'TRUE' ) }

    

   1. If the server is healthy, this query should produce “no results” (see figure below). If you see a list of relations as the response, please contact our support team by raising a request on our helpdesk for assistance before proceeding with the migration process.

   Open

   

Verification

You should have been able to gather the statistics from both Graph and Cassandra of SC 3.6.