Skip to Content
0

How to identify the Database connected to DM

Oct 25, 2017 at 09:32 AM

23

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Marc Kuipers
Oct 25, 2017 at 02:18 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded