New-AMDatabaseCondition

NAME New-AMDatabaseCondition



SYNOPSIS

Creates a new AutoMate Enterprise database condition.





SYNTAX

New-AMDatabaseCondition [-Name] <String> [-DatabaseType {SQL | Oracle}] -Server <String> [-NotificationPort

<Int32>] -Database <String> -Table <String> [-UserName <String>] [-Insert] [-Delete] [-Update] [-Drop] [-Alter]

[-Wait] [-Timeout <Int32>] [-TimeoutUnit {Seconds | Minutes | Hours | Days | Milliseconds}] [-TriggerAfter

<Int32>] [-Notes <String>] [-Folder <Object>] [-Connection <Object>] [-WhatIf] [-Confirm] [<CommonParameters>]





DESCRIPTION

New-AMDatabaseCondition creates a new database condition.





PARAMETERS

-Name <String>

The name of the new object.



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-DatabaseType

The type of database to monitor: SQL (Microsoft) or Oracle.



Required? false

Position? named

Default value SQL

Accept pipeline input? false

Accept wildcard characters? false



-Server <String>

The name of the database server to be monitored.



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-NotificationPort <Int32>

Indicates the port number that the notification listener listens on for database notifications. If the port

number is set to -1 (default), a random port number is assigned to the listener when started.



Required? false

Position? named

Default value -1

Accept pipeline input? false

Accept wildcard characters? false



-Database <String>

The name of the database to be monitored.



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Table <String>

The database table which holds the data element(s) to be monitored. This value must include the schema name

and table name separated by a dot (.) entered in the following format (minus the brackets):

[Schema_Name].[Table_Name].



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-UserName <String>

The username used to authenticate with the database.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Insert [<SwitchParameter>]

If set, the condition evaluates to TRUE when an INSERT is performed on the specified database.



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Delete [<SwitchParameter>]

If set, the condition evaluates to TRUE when an DELETE is performed on the specified database.



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Update [<SwitchParameter>]

If set, the condition evaluates to TRUE when an UPDATE is performed on the specified database.



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Drop [<SwitchParameter>]

If set, the condition evaluates to TRUE when an DROP is performed on the specified database.



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Alter [<SwitchParameter>]

If set, the condition evaluates to TRUE when an ALTER is performed on the specified database.



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Wait [<SwitchParameter>]

Wait for the condition, or evaluate immediately.



Required? false

Position? named

Default value True

Accept pipeline input? false

Accept wildcard characters? false



-Timeout <Int32>

If wait is specified, the amount of time before the condition times out.



Required? false

Position? named

Default value 0

Accept pipeline input? false

Accept wildcard characters? false



-TimeoutUnit

The unit for Timeout (Seconds by default).



Required? false

Position? named

Default value Seconds

Accept pipeline input? false

Accept wildcard characters? false



-TriggerAfter <Int32>

The number of times the condition should occur before the trigger fires.



Required? false

Position? named

Default value 1

Accept pipeline input? false

Accept wildcard characters? false



-Notes <String>

The new notes to set on the object.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Folder <Object>

The folder to place the object in.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Connection <Object>

The server to create the object on.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Confirm [<SwitchParameter>]



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS





RELATED LINKS

https://github.com/AutomatePS/AutomatePS