Redgate Monitor 14

Creates a new temporary object that holds information about a Google Cloud SQL Server instance.

Syntax

New-RedgateMonitorGoogleCloudSqlServer [-Endpoint] <string> [-BaseMonitor] <BaseMonitor> [[-Group] <Group>] [-UserName] <string> [-Password] <string> [-ServiceAccountKeyJson] <string> [[-Port] <int>] [[-NetworkProtocol] <string>] [[-PacketSize] <int>] [[-ConnectionTimeout] <int>] [[-ExecutionTimeout] <int>] [[-EncryptConnection] <bool>] [[-TrustServerCertificate] <bool>] [<CommonParameters>]

Description

The New-RedgateMonitorGoogleCloudSqlServer cmdlet creates a new temporary object that holds information about a Google Cloud SQL Server instance. The returned object needs to be passed to Add-RedgateMonitorMonitoredObject, as it does not add anything to Redgate Monitor on its own.

Parameters

`-Endpoint <String>`

The endpoint address of the Google Cloud SQL Server instance to be monitored.

Aliases	None
Required?	true
Position?	1
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-BaseMonitor <BaseMonitor>`

The base monitor to add the monitored object to.

Aliases	None
Required?	true
Position?	2
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-Group <Group>`

Group object - use Get-Group or related methods to find the group.

Aliases	None
Required?	false
Position?	3
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-UserName <String>`

SQL Server username to connect with.

Aliases	None
Required?	true
Position?	4
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-Password <String>`

SQL Server password to connect with.

Aliases	None
Required?	true
Position?	5
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-ServiceAccountKeyJson <String>`

The Google Cloud service account key in JSON format. Use Get-Content -Raw to read from a file.

Aliases	None
Required?	true
Position?	6
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-Port <Int32>`

The SQL Server port number.

Aliases	None
Required?	false
Position?	7
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-NetworkProtocol <String>`

The network protocol to use to connect to the SQL Server instance.

Aliases	None
Required?	false
Position?	8
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-PacketSize <Int32>`

The network packet size to use to connect to the SQL Server instance.

Aliases	None
Required?	false
Position?	9
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-ConnectionTimeout <Int32>`

The connection timeout in seconds.

Aliases	None
Required?	false
Position?	10
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-ExecutionTimeout <Int32>`

The execution timeout in seconds.

Aliases	None
Required?	false
Position?	11
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-EncryptConnection <Boolean>`

Whether to encrypt the connection.

Aliases	None
Required?	false
Position?	12
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`-TrustServerCertificate <Boolean>`

Whether to trust the server certificate.

Aliases	None
Required?	false
Position?	13
Default Value	None
Accept Pipeline Input	False
Accept Wildcard Characters	false

`<CommonParameters>`

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, -OutVariable, and -ProgressAction. For more information, see http://technet.microsoft.com/en-us/library/hh847884.aspx.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

None.
You cannot pipe input to this cmdlet.

Examples

-------------------------- EXAMPLE 1 --------------------------

$instance = New-RedgateMonitorGoogleCloudSqlServer -Endpoint "10.128.0.2" -BaseMonitor $BaseMonitor -UserName "sql_username" -Password "sql_pass" -ServiceAccountKeyJson (Get-Content -Raw 'service-account-key.json')
$instance | Add-RedgateMonitorMonitoredObject