support

Hello Anders, Yes, we can provide an upgrade quote for you, which is discounted by the current license set you have. Can you please contact our sales department via the following page, and they will be able to assist you - https://www.clickstudios.com.au/support.aspx Regards Click Studios

Hello Everyone, Today we have released build 9512. For full details, please refer to our changelog here https://www.clickstudios.com.au/passwordstate-changelog.aspx Regards Click Studios

Problem: When you upgrade from a build prior to Version 9493, your Passwordstate database will support Unicode characters, which can make your database grow by a large amount. To ensure you have a seamless upgrade experience we'd recommend the following database management options: Steps to Consider Before you Upgrade: **Note** If you are using SQL Express, this has a 10 GB data limit. Your database should really no no bigger than 2GB if using SQL Express, otherwise you may have to consider Moving your database to a SQL Standard instance. Option #1: Set your Recovery model for your database to "Simple". This will still allow full backups to be taken, but will significantly reduce the size of your database. **Note** you should not set your database to Simple mode if you have any form of SQL Replication running. Action: Connect to your database server using SQL Management Studio Tools, right click your Passwordstate database, and select Properties. Now change the recovery model to Simple: Option #2: Check you have plenty of disk space on your database server prior to upgrading, as your database may grow to be 300% – 400% in size. Action: Connect to your database server using SQL Management Studio Tools, right click your Passwordstate database, and select Properties. Select the Files Menu and determine which disk drive the database is stored on, and also determine the current size of your database. Check that there is ample space on this drive and free up space if required. Option #3: Shrink the database and log files to reduce the overall size of the database. Action: Connect to your database server using SQL Management Studio Tools, create a New Query and paste in the following code. Now click the Execute button: DBCC SHRINKDATABASE (Passwordstate) Option #4: Confirm your Autogrowth setting is not limited. If your database has a limit on how much it can grow, this may impact your upgrade. Action: Connect to your database server using SQL Management Studio Tools, right click your Passwordstate database, and select Properties. Select the Files Menu, and check the database is set to Autogrowth. If it is not, click the Edit button and select Autogrowth and Unlimited as per below screenshot: Option #5: A lot of customers see a build up of Passwordstate auditing data over the years, and this can consume quite a lot of space in the database. Action: If you generate a lot of auditing records with your usage of Passwordstate, then most likely the majority of the records will be in the AuditingArchive table. To check the number of rows you can run the following queries in SQL Server Management Studio: USE Passwordstate SELECT COUNT(*) FROM AuditingArchive With our testing, 1 or 2 million records do not pose an issue with the upgrade. If you have significantly more records than this, please consider backing up and then deleting the records in the AuditingArchive table. Backing up the data first is only required for your own compliance reasons - The decision is yours to backup the data before deleting it. To backup your AuditingArchive table, right click the Passwordstate database and select Export Data... To delete all rows in the AuditingArchive table, run the following command in SQL Management Studio Tools: USE Passwordstate TRUNCATE TABLE AuditingArchive Steps to Consider After you Upgrade: The only step required after upgrading would be to Shrink the database again. Follow Option #3 above to perform this step. Regards, Click Studios Support

Okay, thanks.

If you are attempting to scan the QR code into the Passwordstate App, but you receive the error where it connect connect, try to following troubleshooting items: Step 1: On your phone, open a browser, and try browsing to your AppServer URL. You will need to see a "200 | Status OK" message. If you don't your AppServer URL is not available from phone connection. This could be firewall, or DNS blocking this access. Step 2: Check that you have the AppServer computer name set correctly under Administration -> Authorized Web Servers. This must be in netbios format, and not FQDN. If you do not see your server on this page, add it in and try scanning the QR code again. Ensure you set the Role to be an "AppServer" and the functional riles has Mobiel Step 3: Check the C:\inetpub\PasswordstateAppServer\web.config file "AppSettings" section. You should not see a line that says the following: <add key="SetupStage" value="Setup Complete" /> Instead, it should look similar to the screenshot below. If you see that SetupStage line of code, please remove it and save your web.config file, and try again. Step 4: Update the AppServer module by following Section 6 in this guide, and try scanning the QR code again: https://www.clickstudios.com.au/downloads/version9/Upgrade_Instructions.pdf Step 5: You should also update the Mobile App on your mobile device to the latest version, from either the Play store, or the Apple store. Step 6: Re-query the AppServer SSL public Key by following this forum post, and try pairing again: https://forums.clickstudios.com.au/topic/15380-query-app-server-ssl-public-key-mobile-apps-ios-and-android-connection-issue/ Regards, Support

Hi Wolf, Unfortunately we do not have a feature to trigger a script to run after a password is copied - we can only perform this when a password is reset, as part of our Privileged Account Management features. Regards Click Studios

Hi TJ, You browser connects direct to the Gateway URL. So the flow of traffic is from your desktop browser, to whereever you have the gateway installed. The gateway then connects to the hosts. And yes, our Remote Site Locations module is an annual subscription. I hope this clarifies. Regards Click Studios

Hi TJ, The only way this is currently possible is with our Remote Site Locations module, where a separate Gateway can be installed/used with each remote site. We do plan on expanding this functionality in the future, but currently not possible unfortunately. Regards Click Studios

User would like the ability to scan a top level OU in Active Directory, and then exclude a couple of OU's beneath that.

User would like the ability to have wildcard matches on Local Account Discovery jobs. This would make it easier to exclude certain accounts from being picked up

Sure - I'll move you request now.

Hello TJ, Unfortunately you will need to go into each Security Group and remove the users that are no longer needed as part of those groups. Or you can use our API and script the removal as well. Regards Click Studios

Hans, thank you so much for sharing - we very much appreciate it Regards Click Studios

Hello, Sorry you've run into this issue, and we've just fixed this bug in the build 9500 release yesterday. If you can upgrade, then this will resolve it for you. Regards Click Studios

Hello Everyone, Today we have released build 9500. For full details, please refer to our changelog here https://www.clickstudios.com.au/passwordstate-changelog.aspx Regards Click Studios

Hello Everyone, Today we have released build 9493. For full details, please refer to our changelog here https://www.clickstudios.com.au/passwordstate-changelog.aspx Regards Click Studios

We've had a request from a customer to be able to search for permissions set on Privileged Account Credentials via both the API's. Regards Click Studios

To help Click Studios with supporting an issue you may have, sometimes we ask you to run "SQL Queries" to retrieve some data from your database. Below is an example how you can do this. Step 1: Identify where your Passwordstate database is hosted. You can do this by clicking on Administration Home: Step 2: Open Microsoft SQL Server Management Studio on any machine where you have this installed. If you don't have it installed, you can down load for free from Microsoft: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Step 3: Enter your database name, and select an account that has permissions to connect to your SQL database server. If you do not have an account that you know of, you can use the SQL account that Passwordstate uses. You can find the username and password for this account by following this forum post: https://forums.clickstudios.com.au/topic/1655-how-to-find-my-database-server/#:~:text=If you need to get,is c%3A\inetpub\passwordstate. **Note**, in my screenshot below I am using the SQL account that is being used by Passwordstate, so therefore I selected "SQL Server Authentication". If you were connecting with a domain account instead, choose the Windows Authentication option. Step 4: Now you can create a new query, and paste in the SQL code Click Studios Supplied to you, and execute that query. You'll see results as per the screenshot below, where you can then copy the data and paste it into an Excel spreadsheet. This makes it easy for click studios support to read: Now if you send this data to Click Studios, this will help us determine what the issue is. Regards, Support

It would be great to split „copy or email permalink“ into 2 options. Copy permalink will be much better to have directly in drop down on password item to copy permalink on „one click“ instead of opening new window, copying it and than closing window.

Hello Evan, Thanks for your request. As SQL Server Express is free, which can also be used in the cloud, we have no plans on supporting other database types at this time. Regards Click Studios

Hi Jacob, The way we've designed permalinks is to take you directly to the record you need, when you click on the hyperlink i.e. Folder, Password List or Password record. Would it help if you were using a password record permalink, instead of a Password List permalink? If you are clicking on Password List permalinks, you can still search/filter within that list, once you are taken to the Password List. We have no way of automatically filtering when doing this though. Regards Click Studios

Hello TJ, This is how we've designed the Remote Session Credentials, so you can log into systems using the same domain account. If needed, you can click on the Manual Launch button, and search for your other accounts here. Or if you would prefer them in the dropdown, we could move this request into our Feature Requests section of the forums for you. Regards Click Studios

ISSUE: You may find that you are getting an alert from Passwordstate stating that you have excessive auditing records. By default, Passwordstate should move auditing records from the primary "Auditing" table into the "AuditingArchive" table in SQL. If your system is failing to do this, please consider the following: Check 1: First check that the Passwordstate Service is running on your web server. The Windows Service is the tool that moves the data across to the archiving table and the service needs to be running. Check 2: Check your Archiving settings under System Settings and confirm you do not have the maximum number of rows set to 0. 0 means the Service will never move data to the Auditing table. 500,000 is the default value, and is suitable for most environments. Also, check the Schedule on this same page, and ensure your Passwordstate web server is Powered up at the time of this schedule: Check 3: Look in your Application Event logs on your Passwordstate webserver and look for any errors related to the Passwordstate Windows Service. If you find any but are unsure what they mean, please send these to Click Studios Support for analysis: https://www.clickstudios.com.au/support.aspx If you find errors that mention "Violation of PRIMARY KEY constraint 'PK_AuditingArchive'. .AuditingArchive'. The duplicate key value is xxxx" like the screenshot below, we'll need to truncate the Archiving table (instructions below) Take a full backup of your database before doing this, and keep that database just in case you need to access the old auditing data at some stage in the future. Ie, you could restore that database to a test server if needed. You could possibly export the data and put it into an excel spreadsheet, but if your “AuditingArchive” table has more than a million rows, Excel won’t be able to cope with this. If you want to find out how many rows you have in the AuditingArchive table before deleting everything, please run this script in SQL Management Studio tools, when connected to your Passwordstate database server: USE Passwordstate SELECT COUNT(*) FROM AuditingArchive To delete everything from this table, please run this command: USE Passwordstate TRUNCATE TABLE AuditingArchive Now restart your Passwordstate Windows Service on your web server and wait one day. This should then move excessive entries from the “Auditing” table into the “AuditingArchive” table. Regards, Support

Thanks Nick. You can actually specify your own logo now, but not the other items you've mentioned. Regards Click Studios

Hi Sharon, You are welcome to log a support call with us if you have an active annual support license: https://www.clickstudios.com.au/support.aspx Alternatively, try backing up Passwordstate manually, and the perform an upgrade to the latest build, and try running through the backup documentation again. It could possibly be a bug in the build you are running: https://forums.clickstudios.com.au/topic/13911-manual-backup-using-sql-management-studio-tools/ Regards, Support