To help us troubleshoot your issue, it is very handy for us to know certain information about your Passwordstate website, database, and the infrastructure that is is running on. To help speed up our support response times, we've developed a Powershell script that will collect some information about your environment.
To run this script:
Please download the "Passwordstate Support Information Script" script from our Checksums page here https://www.clickstudios.com.au/passwordstate-checksums.aspx.
Extract the zip file and save the ServerInfo.ps1 file on your Passwordstate web server
Open Powershell ISE "As Administrator" and open your ServerInfo.ps1 file
Run the script
When the script has finished it will create a ServerInfo.zip file in the same folder where you have run the script from. Please email that back to support@clickstudios.com.au for analysis.
Below is full disclosure of what the script is doing:
This script will not make any changes to your server, or Passwordstate environment
Information it collects from your web server is as follows:
Current Passwordstate version
All Installed Programs on your server
Name of your web server
Last time your web server was rebooted
Free disk space and free memory on your web server
A check to see if your web server is a part of a domain, or a workgroup
What language the web server is in, plus OS version and .NET version
Information about your Passwordstate App Pools in IIS - Names, Path and Identity Type
Installation path of your Passwordstate website
Passwordstate web bindings in IIS and Authentication options
NSLookups and tracerts of each URL for the Passwordstate website only
List of certificates names on the web server, expiry date and who they are issued by
Powershell version
IP address of webserver
Information about Passwordstate services - If they are running and who is the logon identity and when they were stopped, and started
Local Administrator Accounts if there are any
Passwordstate installation folder permissions
Event Log errors from the Application Event logs
Information from the web.config file - database server name, SQL instance, database name, setup stage and passivenode values. We also query the username and password out of the connection string, but do not store this anywhere. We only use this information temporarily to connect to your database and gather the information in the section below
The remaining non sensitive part of the web.config file is also collected. You'll find your web.config file inside the zip file, but you'll see all sensitive info in the ConnectionString and AppSettings Section is redacted.
.NET Framework versioning
Local Intranet Zone URLs
Information in Hosts file
Upgrade Log File data
Information it collects from your database is as follows:
How many password lists and passwords
Information about Active Directory Domains
Count of Password Lists and tree path
Count of auditing records
Count of total users in the system
Count of total Security Groups
Passwordstate Licensing information
Database Build Number, Base URL and Fips Mode, Ignored URLs and Backup Settings
Detailed table sizes in database
Email Notification information including Security Groups names and Usernames
User Account Policy information including Security Groups names and Usernames
**NOTE** if your web.config file connections string and AppSettings section is encrypted, we make a temporary copy of this web.config file, and decrypt it to get the connection information out of it, and then we delete this file from the file system. We do not store any of this data anywhere on the system, nor do we provide secret keys of connections information in the output file you supply back to click studios.
**NOTE** If you are not comfortable in sending some or all of this information, we will still do our best to help you resolve your issue. We may just have to ask a series of questions to get to the bottom of the problem.
Regards,
Click Studios