< Back

Invoke-PSCUCMSqlQuery

Sun Jan 19, 2020 6:38 pm

NAME Invoke-PSCUCMSqlQuery



SYNOPSIS

Invoke a SQL Query against CUCM Server.





SYNTAX

Invoke-PSCUCMSqlQuery [-SqlQuery] <String> [-EnableException] [-OutputXml] [<CommonParameters>]





DESCRIPTION

Invoke a SQL Query against CUCM Server.





PARAMETERS

-SqlQuery <String>

SQL Query to invoke.



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-EnableException [<SwitchParameter>]

Replaces user friendly yellow warnings with bloody red exceptions of doom!

Use this if you want the function to throw terminating errors you want to catch.



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-OutputXml [<SwitchParameter>]

Output just XML



Required? false

Position? named

Default value False

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



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



PS C:\\>Invoke-PSCUCMSqlQuery -SqlQuery "Select * from phones"



Will execute the query against the CUCM server. This is probably a bad query... Do *not* try this at home.











RELATED LINKS