Skip to Content
avatar image
Former Member

How to identify the Database connected to DM

Hello,

We have many DM databases on our SQL server, could you please help me to identify wich database -from all DM databases- is connected with our DM application?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 25, 2017 at 02:18 PM

    Hi Mehdi
    Interesting question!
    The connection string itself is in the file

    C:\inetpub\wwwroot\SAP\SAP Disclosure Management\bin\cundus.enterpriseReporting.Services.dll.config
    ..however, this string is encrypted.
    See: https://archive.sap.com/documents/docs/DOC-69162


    I guess the 2 easiest ways are at SQL server level

    1. Run the activity monitor and see what DB is being accessed

    2. Check the table Maintenance.Session

    If you login to DM, there will be an entry created in this table
    With this SQL you can see the users that are logged in

    SELECT *
    FROM [DisclosureManagmentDB].[Maintenance].[Session]
    ORDER BY LoggedIn desc


    Thanks
    Marc

    Add comment
    10|10000 characters needed characters exceeded