Based on the existing PowerShell cmdlets that Enterprise Reporter has available, are there any that can be used to manage any credentials (such as a password change) stored in the Credential Manager?
To manage Enterprise Reporter system credentials, there are three cmdlets available:
• Get-ERSystemCredential
• Add-ERSystemCredential
• Set-ERSystemCredential
NAME: Get-ERSystemCredential
SYNOPSIS
This cmdlet retrieves system credentials from the central store for accounts and passwords.
SYNTAX
Get-ERSystemCredential [-Description <String>] [-AccountName] <String> [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]
Get-ERSystemCredential -CredentialId <Guid> [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]
DESCRIPTION
Credentials are used in different places in Enterprise Reporter. For example, nodes and report schedules both use credentials. This cmdlet retrieves system credentials from the central store for accounts and passwords by unique identifier, an account name and description.
NAME: Add-ERSystemCredential
SYNOPSIS
This cmdlet adds specified system credential to the central store for accounts and passwords used throughout the system.
SYNTAX
Add-ERSystemCredential [-Credential] <PSCredential> [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]
DESCRIPTION
Credentials are used in different places in Enterprise Reporter. For example, nodes and report schedules both use credentials. This cmdlet adds specified system credential to the central store for accounts and passwords used throughout the system. This makes it easy to keep passwords up to date, and allows you to enter the credential details once, and access them repeatedly.
NAME: Set-ERSystemCredential
SYNOPSIS
This cmdlet updates an existing credential in the central store for accounts and passwords used throughout the system.
SYNTAX
Set-ERSystemCredential [-Credential] <PSCredential> [[-Timeout] <Int32>] [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]
DESCRIPTION
Credentials are used in different places in Enterprise Reporter. For example, nodes and report schedules both use credentials. This cmdlet updates an existing system credential in the central store for accounts and passwords used throughout the system. This makes it easy to keep passwords up to date, and allows you to enter the credential details once, and access them repeatedly. This cmdlet will update NT Service accounts and restart NT Services if it has been used in a Node deployment or ER Server service.
Note: All help for these and any other PowerShell cmdlets is available using PS >> Get-Help <cmdlet name>
Example:
The PowerShell cmdlet function Set-ERSystemCredential updates the system account password in the Enterprise Reporter credentials database and performs all required NTService changes (including node and server service restarts):
# Connect to ER Server specifying ER Server FullyQualified name.
# This method should be called once before calling any other ER PowerShell cmdlet.
>> Connect-ERConfigurationServer hal-test-srv.AMER.hal.ca.qsft
# Convert plain text password to SecureString.
>> $secpasswd = ConvertTo-SecureString 'pA$$w0d' -AsPlainText -Force
#Create standard PSCredentials object.
>> $credentials = New-Object System.Management.Automation.PSCredential ('AMER\Administrator', $secpasswd)
# Call this method to update credentials in our system.
# This might generate an exception if something went wrong
>> Set-ERSystemCredential $credentials
# When updating ER Server credentials, the server will be restarted. This function completes before ER Server gets restarted. Before calling any additional configuration cmdlet, reconnect to the server using the following command:
>> Connect-ERConfigurationServer hal-test-srv.AMER.hal.ca.qsft
