Use Microsoft SQL Server Management Studio to find ePO - On-prem server information

Prev Next

From the Microsoft SQL Server Management Studio, determine your existing ePO - On-prem server information.

  1. Use a Remote Desktop Connection to log on to the Microsoft SQL database server with host name or IP address.

  2. Open the Microsoft SQL Server Management Studio and connect to the SQL Server.

  3. From the Object Explorer list, click <Database Server Name>Databases<Database name>Tables.

  4. Scroll down to find the EPOServerInfo table, right-click the table name, and select Edit top 200 Rows from the list.

  5. Find and save the information in these database records.

    • ePOVersion — For example <three-digit ePolicy Orchestrator version>.

    • DNSName — For example epo-2k8.servercom.

    • ComputerName — For example EPO-2K8.

    • LastKnownTCPIP — For example 172.10.10.10.

    • RmdSecureHttpPort — For example 8443.

    Make sure that you have this information in case you ever have to restore your ePO - On-prem software.