Invoke-DevartFindInvalidObjects

Last modified: March 28, 2025

Synopsis

Detects invalid objects.

Description

Use the cmdlet to search for and detect invalid objects in multiple databases, and to analyze them and generate reports on the results.

Syntax

Invoke-DevartFindInvalidObjects -Connection <object> [-Database <string>] [-Alldatabases <SwitchParameter>] [-Log <string>] [-Report <string>] [<CommonParameters>]

Parameters

-Connection <object>

Specifies a connection to the server in which database you will search for invalid objects.

This can be:

• an instance of a DevartDatabaseConnectionInfo object produced by the New-DevartSqlDatabaseConnection cmdlet.

• a database connection string.

Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false

-Database <string>

Specifies a single database or multiple databases separated by commas.

The option overrides the values specified in the connection parameter.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

Alldatabases <SwitchParameter>

Finds invalid objects for all non-system databases specified in the connection parameter.

Required? false

Position? named

Default value false

Accept pipeline input? false

Accept wildcard characters? false

-Log <string>

Specifies a path to save a log file.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-Report <string>

Generates a report in the CSV file format. Specify a path to save the report file.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

<CommonParameters>

This cmdlet supports the following common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, InformationAction, InformationVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see About CommonParameters.

Outputs

System.Boolean (returns true on success and false otherwise)

Examples

Invoke-DevartFindInvalidObjects -Connection $connection -Database "AdventureWorks2019_Dev, AdventureWorks2019_Test"