Get-AxAosServerFromDB

NAME Get-AxAosServerFromDB



SYNOPSIS

Get AOS server details from the SQL Server database





SYNTAX

Get-AxAosServerFromDB [[-DatabaseServer] <String>] [[-DatabaseName] <String>] [[-SqlUser] <String>] [[-SqlPwd]

<String>] [<CommonParameters>]





DESCRIPTION

Traverse the SysServerConfig table from the AX 2012 database and get all registered AOS Servers





PARAMETERS

-DatabaseServer <String>

Server name of the database server



Default value is: "localhost"



Required? false

Position? 2

Default value $Script:ActiveAosDatabaseserver

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-DatabaseName <String>

Name of the database



Default value is: "MicrosoftDynamicsAx"



Required? false

Position? 3

Default value $Script:ActiveAosDatabase

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-SqlUser <String>

User name of the SQL Server credential that you want to use when working against the database



Required? false

Position? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



-SqlPwd <String>

Password of the SQL Server credential that you want to use when working against the database



Required? false

Position? 5

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



NOTES





Author: M??????tz Jensen (@Splaxi)



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



PS C:\\>Get-AxAosServerFromDB



This will query the "MicrosoftDynamicsAx" hosted on the localhost server.

It will extract all AOS Servers from the SysServerConfig table.











RELATED LINKS