reports

Creates, updates, deletes, gets or lists a reports resource.

Overview

Name	reports
Type	Resource
Id	google.migrationcenter.reports

Fields

Name	Datatype	Description
name	string	Output only. Name of resource.
description	string	Free-text description.
createTime	string	Output only. Creation timestamp.
displayName	string	User-friendly display name. Maximum length is 63 characters.
state	string	Report creation state.
summary	object	Describes the Summary view of a Report, which contains aggregated values for all the groups and preference sets included in this Report.
type	string	Report type.
updateTime	string	Output only. Last update timestamp.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	locationsId, projectsId, reportConfigsId, reportsId	Gets details of a single Report.
list	SELECT	locationsId, projectsId, reportConfigsId	Lists Reports in a given ReportConfig.
create	INSERT	locationsId, projectsId, reportConfigsId	Creates a report.
delete	DELETE	locationsId, projectsId, reportConfigsId, reportsId	Deletes a Report.

SELECT examples

Lists Reports in a given ReportConfig.

SELECT
name,
description,
createTime,
displayName,
state,
summary,
type,
updateTime
FROM google.migrationcenter.reports
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND reportConfigsId = '{{ reportConfigsId }}';

INSERT example

Use the following StackQL query and manifest file to create a new reports resource.

All Properties

/*+ create */
INSERT INTO google.migrationcenter.reports (
locationsId,
projectsId,
reportConfigsId,
displayName,
description,
type,
state
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ reportConfigsId }}',
'{{ displayName }}',
'{{ description }}',
'{{ type }}',
'{{ state }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: createTime
      value: string
    - name: updateTime
      value: string
    - name: displayName
      value: string
    - name: description
      value: string
    - name: type
      value: string
    - name: state
      value: string
    - name: summary
      value:
        - name: allAssetsStats
          value:
            - name: totalMemoryBytes
              value: string
            - name: totalStorageBytes
              value: string
            - name: totalCores
              value: string
            - name: totalAssets
              value: string
            - name: memoryUtilizationChart
              value:
                - name: used
                  value: string
                - name: free
                  value: string
            - name: operatingSystem
              value:
                - name: dataPoints
                  value:
                    - - name: label
                        value: string
                      - name: value
                        value: number
            - name: coreCountHistogram
              value:
                - name: buckets
                  value:
                    - - name: lowerBound
                        value: string
                      - name: upperBound
                        value: string
                      - name: count
                        value: string
        - name: groupFindings
          value:
            - - name: displayName
                value: string
              - name: description
                value: string
              - name: overlappingAssetCount
                value: string
              - name: preferenceSetFindings
                value:
                  - - name: displayName
                      value: string
                    - name: description
                      value: string
                    - name: machinePreferences
                      value:
                        - name: targetProduct
                          value: string
                        - name: regionPreferences
                          value:
                            - name: preferredRegions
                              value:
                                - string
                        - name: commitmentPlan
                          value: string
                        - name: sizingOptimizationStrategy
                          value: string
                        - name: computeEnginePreferences
                          value:
                            - name: persistentDiskType
                              value: string
                            - name: machinePreferences
                              value:
                                - name: allowedMachineSeries
                                  value:
                                    - - name: code
                                        value: string
                            - name: licenseType
                              value: string
                        - name: vmwareEnginePreferences
                          value:
                            - name: cpuOvercommitRatio
                              value: number
                            - name: memoryOvercommitRatio
                              value: number
                            - name: storageDeduplicationCompressionRatio
                              value: number
                            - name: commitmentPlan
                              value: string
                        - name: soleTenancyPreferences
                          value:
                            - name: cpuOvercommitRatio
                              value: number
                            - name: hostMaintenancePolicy
                              value: string
                            - name: commitmentPlan
                              value: string
                            - name: nodeTypes
                              value:
                                - - name: nodeName
                                    value: string
                    - name: monthlyCostTotal
                      value:
                        - name: currencyCode
                          value: string
                        - name: units
                          value: string
                        - name: nanos
                          value: integer
                    - name: computeEngineFinding
                      value:
                        - name: allocatedRegions
                          value:
                            - string
                        - name: allocatedAssetCount
                          value: string
                        - name: machineSeriesAllocations
                          value:
                            - - name: machineSeries
                                value:
                                  - name: code
                                    value: string
                              - name: allocatedAssetCount
                                value: string
                        - name: allocatedDiskTypes
                          value:
                            - string
                    - name: vmwareEngineFinding
                      value:
                        - name: allocatedRegions
                          value:
                            - string
                        - name: allocatedAssetCount
                          value: string
                        - name: nodeAllocations
                          value:
                            - - name: vmwareNode
                                value:
                                  - name: code
                                    value: string
                              - name: nodeCount
                                value: string
                              - name: allocatedAssetCount
                                value: string
                    - name: soleTenantFinding
                      value:
                        - name: allocatedRegions
                          value:
                            - string
                        - name: allocatedAssetCount
                          value: string
                        - name: nodeAllocations
                          value:
                            - - name: node
                                value:
                                  - name: nodeName
                                    value: string
                              - name: nodeCount
                                value: string
                              - name: allocatedAssetCount
                                value: string

DELETE example

Deletes the specified reports resource.

/*+ delete */
DELETE FROM google.migrationcenter.reports
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}'
AND reportConfigsId = '{{ reportConfigsId }}'
AND reportsId = '{{ reportsId }}';