How to Obtain eHealth Web Users Through running a Sql query?

Products

• EHEALTH
• CA eHealth

Issue/Introduction

SUMMARY

Usually the eHealth web users can be found from ehealth OneClick. But those information can be also easily obtained through running a sql query.

INSTRUCTION

1. Start sqlplus

    In Windows:  sqlplus %NH_USER%/%NH_USER%@%NH_DB_CONNECT_STRING%

    In Solaris/Linux:  sqlplus $NH_USER/[email protected]$NH_DB_CONNECT_STRING

2. Enter the following query to list all ehealth web users

    select user_name from nh_user;

Here is an example of the output the query might display.

SQL> select USER_NAME from nh_user;

    USER_NAME

   --------------------

   admin

   ehealth

   test

   mike1

   jone1

The above output shows that there are five users who can run ehealth web reports.

 

Environment

Release:
Component: EHORA