devices

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

Overview

Name	devices
Type	Resource
Id	google.prod_tt_sasportal.devices

Fields

Name	Datatype	Description
name	string	Output only. The resource path name.
activeConfig	object	Information about the device configuration.
currentChannels	array	Output only. Current channels with scores.
deviceMetadata	object	Device data overridable by both SAS Portal and registration requests.
displayName	string	Device display name.
fccId	string	The FCC identifier of the device. Refer to https://www.fcc.gov/oet/ea/fccid for FccID format. Accept underscores and periods because some test-SAS customers use them.
grantRangeAllowlists	array	Only ranges that are within the allowlists are available for new grants.
grants	array	Output only. Grants held by the device.
preloadedConfig	object	Information about the device configuration.
serialNumber	string	A serial number assigned to the device by the device manufacturer.
state	string	Output only. Device state.

Methods

Name	Accessible by	Required Params	Description
customers_deployments_devices_list	SELECT	customersId, deploymentsId	Lists devices under a node or customer.
customers_devices_get	SELECT	customersId, devicesId	Gets details about a device.
customers_devices_list	SELECT	customersId	Lists devices under a node or customer.
customers_nodes_devices_list	SELECT	customersId, nodesId	Lists devices under a node or customer.
deployments_devices_get	SELECT	deploymentsId, devicesId	Gets details about a device.
nodes_deployments_devices_list	SELECT	deploymentsId, nodesId	Lists devices under a node or customer.
nodes_devices_get	SELECT	devicesId, nodesId	Gets details about a device.
nodes_devices_list	SELECT	nodesId	Lists devices under a node or customer.
nodes_nodes_devices_list	SELECT	nodesId, nodesId1	Lists devices under a node or customer.
customers_deployments_devices_create	INSERT	customersId, deploymentsId	Creates a device under a node or customer.
customers_devices_create	INSERT	customersId	Creates a device under a node or customer.
customers_nodes_devices_create	INSERT	customersId, nodesId	Creates a device under a node or customer.
nodes_deployments_devices_create	INSERT	deploymentsId, nodesId	Creates a device under a node or customer.
nodes_devices_create	INSERT	nodesId	Creates a device under a node or customer.
nodes_nodes_devices_create	INSERT	nodesId, nodesId1	Creates a device under a node or customer.
customers_devices_delete	DELETE	customersId, devicesId	Deletes a device.
deployments_devices_delete	DELETE	deploymentsId, devicesId	Deletes a device.
nodes_devices_delete	DELETE	devicesId, nodesId	Deletes a device.
customers_devices_patch	UPDATE	customersId, devicesId	Updates a device.
deployments_devices_patch	UPDATE	deploymentsId, devicesId	Updates a device.
nodes_devices_patch	UPDATE	devicesId, nodesId	Updates a device.
customers_devices_move	EXEC	customersId, devicesId	Moves a device under another node or customer.
customers_devices_sign_device	EXEC	customersId, devicesId	Signs a device.
deployments_devices_move	EXEC	deploymentsId, devicesId	Moves a device under another node or customer.
deployments_devices_sign_device	EXEC	deploymentsId, devicesId	Signs a device.
nodes_devices_move	EXEC	devicesId, nodesId	Moves a device under another node or customer.
nodes_devices_sign_device	EXEC	devicesId, nodesId	Signs a device.

SELECT examples

Lists devices under a node or customer.

SELECT
name,
activeConfig,
currentChannels,
deviceMetadata,
displayName,
fccId,
grantRangeAllowlists,
grants,
preloadedConfig,
serialNumber,
state
FROM google.prod_tt_sasportal.devices
WHERE nodesId = '{{ nodesId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.prod_tt_sasportal.devices (
nodesId,
activeConfig,
displayName,
deviceMetadata,
name,
serialNumber,
fccId,
grantRangeAllowlists,
state,
grants,
preloadedConfig
)
SELECT 
'{{ nodesId }}',
'{{ activeConfig }}',
'{{ displayName }}',
'{{ deviceMetadata }}',
'{{ name }}',
'{{ serialNumber }}',
'{{ fccId }}',
'{{ grantRangeAllowlists }}',
'{{ state }}',
'{{ grants }}',
'{{ preloadedConfig }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: activeConfig
      value:
        - name: model
          value:
            - name: firmwareVersion
              value: string
            - name: softwareVersion
              value: string
            - name: name
              value: string
            - name: vendor
              value: string
            - name: hardwareVersion
              value: string
        - name: userId
          value: string
        - name: measurementCapabilities
          value:
            - string
        - name: airInterface
          value:
            - name: supportedSpec
              value: string
            - name: radioTechnology
              value: string
        - name: isSigned
          value: boolean
        - name: state
          value: string
        - name: category
          value: string
        - name: callSign
          value: string
        - name: updateTime
          value: string
        - name: installationParams
          value:
            - name: heightType
              value: string
            - name: longitude
              value: number
            - name: antennaAzimuth
              value: integer
            - name: horizontalAccuracy
              value: number
            - name: indoorDeployment
              value: boolean
            - name: eirpCapability
              value: integer
            - name: antennaGain
              value: number
            - name: antennaModel
              value: string
            - name: height
              value: number
            - name: cpeCbsdIndication
              value: boolean
            - name: antennaBeamwidth
              value: integer
            - name: verticalAccuracy
              value: number
            - name: antennaDowntilt
              value: integer
            - name: latitude
              value: number
    - name: displayName
      value: string
    - name: currentChannels
      value:
        - - name: frequencyRange
            value:
              - name: lowFrequencyMhz
                value: number
              - name: highFrequencyMhz
                value: number
          - name: score
            value: number
    - name: deviceMetadata
      value:
        - name: interferenceCoordinationGroup
          value: string
        - name: nrqzValidation
          value:
            - name: latitude
              value: number
            - name: state
              value: string
            - name: cpiId
              value: string
            - name: caseId
              value: string
            - name: longitude
              value: number
        - name: commonChannelGroup
          value: string
        - name: nrqzValidated
          value: boolean
        - name: antennaModel
          value: string
    - name: name
      value: string
    - name: serialNumber
      value: string
    - name: fccId
      value: string
    - name: grantRangeAllowlists
      value:
        - - name: lowFrequencyMhz
            value: number
          - name: highFrequencyMhz
            value: number
    - name: state
      value: string
    - name: grants
      value:
        - - name: channelType
            value: string
          - name: maxEirp
            value: number
          - name: expireTime
            value: string
          - name: lastHeartbeatTransmitExpireTime
            value: string
          - name: state
            value: string
          - name: grantId
            value: string
          - name: moveList
            value:
              - - name: dpaId
                  value: string
          - name: suspensionReason
            value:
              - string

UPDATE example

Updates a devices resource.

/*+ update */
UPDATE google.prod_tt_sasportal.devices
SET 
activeConfig = '{{ activeConfig }}',
displayName = '{{ displayName }}',
deviceMetadata = '{{ deviceMetadata }}',
name = '{{ name }}',
serialNumber = '{{ serialNumber }}',
fccId = '{{ fccId }}',
grantRangeAllowlists = '{{ grantRangeAllowlists }}',
state = '{{ state }}',
grants = '{{ grants }}',
preloadedConfig = '{{ preloadedConfig }}'
WHERE 
devicesId = '{{ devicesId }}'
AND nodesId = '{{ nodesId }}';

DELETE example

Deletes the specified devices resource.

/*+ delete */
DELETE FROM google.prod_tt_sasportal.devices
WHERE devicesId = '{{ devicesId }}'
AND nodesId = '{{ nodesId }}';