Skip to main content

host_security_reports

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

Overview

Namehost_security_reports
TypeResource
Idgoogle.apigee.host_security_reports

Fields

NameDatatypeDescription
createdstringCreation time of the query.
displayNamestringDisplay Name specified by the user.
envgroupHostnamestringHostname is available only when query is executed at host level.
errorstringError is set when query fails.
executionTimestringExecutionTime is available only after the query is completed.
queryParamsobjectMetadata for the security report.
reportDefinitionIdstringReport Definition ID.
resultobjectContains informations about the security report results.
resultFileSizestringResultFileSize is available only after the query is completed.
resultRowsstringResultRows is available only after the query is completed.
selfstringSelf link of the query. Example: /organizations/myorg/environments/myenv/securityReports/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd or following format if query is running at host level: /organizations/myorg/hostSecurityReports/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd
statestringQuery state could be "enqueued", "running", "completed", "expired" and "failed".
updatedstringOutput only. Last updated timestamp for the query.

Methods

NameAccessible byRequired ParamsDescription
organizations_host_security_reports_getSELECThostSecurityReportsId, organizationsIdGet status of a query submitted at host level. If the query is still in progress, the state is set to "running" After the query has completed successfully, state is set to "completed"
organizations_host_security_reports_listSELECTorganizationsIdReturn a list of Security Reports at host level.
organizations_host_security_reports_createINSERTorganizationsIdSubmit a query at host level to be processed in the background. If the submission of the query succeeds, the API returns a 201 status and an ID that refer to the query. In addition to the HTTP status 201, the state of "enqueued" means that the request succeeded.

SELECT examples

Return a list of Security Reports at host level.

SELECT
created,
displayName,
envgroupHostname,
error,
executionTime,
queryParams,
reportDefinitionId,
result,
resultFileSize,
resultRows,
self,
state,
updated
FROM google.apigee.host_security_reports
WHERE organizationsId = '{{ organizationsId }}';

INSERT example

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

/*+ create */
INSERT INTO google.apigee.host_security_reports (
organizationsId,
envgroupHostname,
displayName,
groupByTimeUnit,
limit,
timeRange,
reportDefinitionId,
filter,
csvDelimiter,
metrics,
dimensions,
mimeType
)
SELECT
'{{ organizationsId }}',
'{{ envgroupHostname }}',
'{{ displayName }}',
'{{ groupByTimeUnit }}',
'{{ limit }}',
'{{ timeRange }}',
'{{ reportDefinitionId }}',
'{{ filter }}',
'{{ csvDelimiter }}',
'{{ metrics }}',
'{{ dimensions }}',
'{{ mimeType }}'
;