2 Replies Latest reply on Mar 20, 2019 5:48 AM by Arif Alibay

    How to know BPPM Sybase DB details

    VENKATESWARA RAO KALI
      Share:|

      Hi Team,

       

      I want to know the BPPM Sybase details like username, password DB name and port. My previouse team installed BPPM servers, but i don't know the that Sybase DB credentials and default data. Please check and let me know the details.

        • 1. Re: How to know BPPM Sybase DB details
          Andy Scholebo

          username: dba

          password: pronet

          DB name:  storm_<hostname>  (e.g. storm_clm-aus-sty7rw)

          port: 2638

          • 2. Re: How to know BPPM Sybase DB details
            Arif Alibay

            in case your team has changed the default username, from cmd or shell prompt in TSIM , you can also run

             

            pw dbconfig list

            or

            sqli "select user_name()"

            DBuser

             

            This will return the username (DBuser here), please note that when database  is running on the server, you don't need  to enter  the user/password when querying the database directly using sqli command from the server.

             

            To check the other details such as Dbname,versions,    you can run :

            dbname:

            sqli "select db_name()"

             

            version:

            sqli "select @@version"

             

            List of Tables in the Schema :

            sqli "SELECT name FROM sysobjects WHERE type='U'"

             

            List of Views in the Schema :

            sqli "SELECT name FROM sysobjects WHERE type='V'"