Is there a way in Maximo to show the database name we are connected to? Maybe using a query like select * from v$database;
We have multiple databases (one for test mirror of production) and another database for upgrade testing.
It would help us make less mistakes if we explicitly know which database we are working on.
Pinned topic Make database name appear on every screen or at least login?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-30T14:21:54Z at 2013-01-30T14:21:54Z by maxmadman
scottsd 2000003CK1121 Posts
Re: Make database name appear on every screen or at least login?2013-01-28T18:28:12ZThis is the accepted answer. This is the accepted answer.This information is stored in this system property, visible in the System Properties application:
Unfortunately, you can't get this into the start center or application header I don't think without tweaking some jsps (an unsupported hack). But your administrators maybe can be educated to check that system property before making major changes.
Re: Make database name appear on every screen or at least login?2013-01-28T19:04:53ZThis is the accepted answer. This is the accepted answer.
- scottsd 2000003CK1
maxmadman 2700007WDK76 Posts
Re: Make database name appear on every screen or at least login?2013-01-29T15:32:09ZThis is the accepted answer. This is the accepted answer.Check out the MAXMESSAGES table, specifically the welcomemaximomessage.
Select * from maxmessages where msgkey = 'welcomemaximomessage' update the value column to reflect the database name e.g. 'Welcome to Maximo Test'
You will then see that message on the login screen.