KB0051 - Viewing database contents

KB0051 - Viewing database contents

Purpose

The purpose of this document is to provide steps for viewing the PowerShell Universal database. 

Process

PowerShell Universal v3 and v4 - LiteDB 

To view the LiteDB database for PowerShell Universal, you can use LiteDB Studio. PowerShell Universal must not be running when accessing the database. The database is stored in %ProgramData%\UniversalAutomation\database.db by default.

PowerShell Universal - SQL

To view a SQL database used by PowerShell Universal, you can use any standard SQL client such as SQL Management Studio or DataGrip. 

PowerShell Universal - SQLite

You can use tools, such as DataGrip, to access the PowerShell Universal SQLite database. The database is stored in %ProgramData%\UniversalAutomation\database.db by default.

PowerShell Universal v2 - LiteDB

To view the LiteDB database for PowerShell Universal, you can use LiteDB Explorer.  PowerShell Universal must not be running when accessing the database. The database is stored in %ProgramData%\UniversalAutomation\database.db by default.

    • Related Articles

    • KB0080 - Failed to Locate Secret in Database or Vault

      Scope Users running PowerShell Universal 5.0.16 attempting to run a script as another user based on a new secret PSCredential variable. Problem When attempting to run the script as the user stored in the PSCredential secret, the application reports ...

    • KB - 1008 Tax/VAT Exempt at checkout

      Scope In this article you will learn how to make a tax-free purchase at checkout. Problem How do you remove the Tax/VAT on an order? Impact Orders will then need to be refunded for tax if processed without the tax deducted. Resolution Follow the ...

    • KB0064 - Migrating A PowerShell Universal License Between Servers

      Purpose The purpose of this article is to provide information about moving a PowerShell Universal license from one server to another. Process In order to move a license from one server to another, you will need to first have your licensed server up ...

    • KB0057 - Scheduled Jobs are Not Shown in the Script \ Jobs Tab

      Affected Versions - PowerShell Universal 4.2.0 - 4.2.4 Problem When viewing a script's jobs within the script's page, scheduled scripts will not be shown. Root Cause A change was introduced to allow for filtering out scheduled jobs. The script's page ...

    • KB0078 - Service fails to start during PowerShell Universal v5 Upgrade when using SQLite and MSI

      Scope Users that are upgrading from PowerShell Universal v4 to PowerShell Universal v5 using the MSI and SQLite persistence database. Problem The service may not start in a timely manner and cause the MSI process to fail. Root Cause PowerShell ...