.SYNOPSISGet the admin module for a named ASM system.DESCRIPTIONGet the admin module for a named ASM system.PARAMETER SystemNameThe name of the Service Manager system.EXAMPLEGet-ServiceManagerSystemAdminModule-SystemName production
Get-ServiceManagerSystemNames
.SYNOPSISGet a list of installed alemba systems.DESCRIPTIONGet all local alemba system names as an array of strings.EXAMPLE Get-ServiceManagerSystemNames
Get-ServiceManagerSystemPath
.SYNOPSISGet the install path for a named Service Manager System.DESCRIPTIONReturns the path to the system folder for a named system.PARAMETER SystemNameThe name of the Service Manager system.EXAMPLE Get-ServiceManagerSystemPath-SystemName production => C:\alemba\Service Manager\web\systems\production\
Get-ServiceManagerSystemProperty
SYNOPSISGet the current value of a specified system property for a named Service Manager systemSYNTAXGet-ServiceManagerSystemProperty [-SystemName] <Object> [-Name] <String> [<CommonParameters>]DESCRIPTIONReturns the string value of the specified system propertyREMARKSTo see the examples, type: "get-help Get-ServiceManagerSystemProperty -examples".For more information, type: "get-help Get-ServiceManagerSystemProperty -detailed".For technical information, type: "get-help Get-ServiceManagerSystemProperty -full".COMMON PARAMETERS (you can press "TAB" to cycle through them in Powershell):TimeoutTimeoutLiteDefaultDateFormatCurrencySignMMAURLLicenceKeyEnableVirusCheckEnableTracingConnectionString
Get-ServiceManagerVersion
.SYNOPSISGet the version of Alemba Service Manager .DESCRIPTIONReturns a Version value representing the currently installed version of Alemba Service Manager.EXAMPLE Get-ServiceManagerVersion=>Major Minor Build Revision-----------------------105112345
Invoke-QueryParser
.SYNOPSISParse Queries for the named system.DESCRIPTIONExecutes the parse queries process for the named Alemba Service Manager system You must restart web and windows services after executing this function
.PARAMETER SystemNameThe name of the Service Manager system.EXAMPLEInvoke-QueryParser-SystemName production
Invoke-SQL
.SYNOPSISExecute a sql query using the database for a Service Manager system.DESCRIPTIONExecute a sql query using the database for a Service Manager system Does not return any results.PARAMETER SystemThe name of the Service Manager system or a reference to the System Admin Module for the named system. For optimal performance, pass a reference to an existing instance of a System Admin Module when you plan to iteratively execute many sql queries
.PARAMETER SQL The SQL query text. e.g. select NAME from SU_CALL_PRIORITY where REF = @REF" .PARAMETER ParametersOptional hashtable of SQL Query parameters. e.g. @{ REF = 1, NAME = "Priority 1" }Types must conform to known SQL Server Data Types. These are usually [int32] and [string] and in these cases the types are inferred.EXAMPLEInvoke-SQL -System production -SQL "select Name from SU_CALL_PRIORITY where REF = @REF" -Parameters @{ REF = 1; }
Invoke SQLReader
.SYNOPSISExecute a sql query using the database for a Service Manager system.DESCRIPTIONExecute a sql query using the database for a Service Manager system Returns results as an array of hashtables. e.g. @(@{ REF =1; NAME ="P1"; }; @{ REF =2; NAME ="P2"}; ).PARAMETER SystemThe name of the Service Manager system or a reference to the System Admin Module for the named system. For optimal performance, pass a reference to an existing instance of a System Admin Module when you plan to iteratively execute many sql queries
.PARAMETER SQL The SQL query text. e.g. select NAME fromSU_CALL_PRIORITY where REF = @REF" .PARAMETER ParametersOptional hashtable of SQL Query parameters. e.g. @{ REF = 1, NAME = "P1" }Types must conform to known SQL Server Data Types. These are usually [int32] and [string] and in these cases the types are inferred.EXAMPLEInvoke-SQLReader -System production -SQL "select Name from SU_CALL_PRIORITY where REF = @REF" -Parameters @{ REF = 1; }
Invoke-SQLScript
.SYNOPSISExecute a sql queries from a file using the database for a Service Manager system.DESCRIPTIONExecute a sql queries from a file using the database for a Service Manager system Does not return any resultsUse GO; on a new line to separate scripts within the file.PARAMETER SystemThe name of the Service Manager system or a reference to the System Admin Module for the named system. For optimal performance, pass a reference to an existing instance of a System Admin Module when you plan to iteratively execute many sql queries
.PARAMETER FileNamePath to a file containing SQL commands.The path can be relative to the current working directory.EXAMPLEInvoke-SQLScript-System production -FileName ".\script.sql"
Set-ServiceManagerUserPassword
.SYNOPSISSet a new password for an existing ASM user.DESCRIPTIONSet a new password for an existing ASM userOnly applicable when using ASM Password authenticationThis is intended to be used to securely restore admin access to a system when no ot her user can access ASM.PARAMETER SystemNameThe name of the Service Manager system.PARAMETER UsernameThe username (USER_ID) of the ASM User Account.PARAMETER Password The new password.EXAMPLESet-ServiceManagerUserPassword-SystemName production -Username "admin.user"-Password ********
Set-ServiceManagerSystemProperty
.SYNOPSISSet system properties for a Service Manager system.DESCRIPTIONExecute a sql queries from a file using the database for a Service Manager system Does not return any resultsUse GO; on a new line to separate scripts within the file.PARAMETER SystemNameThe name of the Service Manager system.PARAMETER Name The name of the system property.PARAMETER ValueThe value of the system property.EXAMPLESet-ServiceManagerSystemProperty-SystemName production -Name TimeOut -Value 240.EXAMPLESet-ServiceManagerSystemProperty-SystemName production -Name CurrencySign -Value "£"
