Topic
  • 5 replies
  • Latest Post - ‏2013-01-30T14:21:54Z by maxmadman
swkim90049
swkim90049
301 Posts

Pinned topic Make database name appear on every screen or at least login?

‏2013-01-28T18:17:58Z |
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.
Updated on 2013-01-30T14:21:54Z at 2013-01-30T14:21:54Z by maxmadman
  • scottsd
    scottsd
    121 Posts

    Re: Make database name appear on every screen or at least login?

    ‏2013-01-28T18:28:12Z  
    This information is stored in this system property, visible in the System Properties application:

    mxe.db.url

    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.

    Thank,
    Scott
  • swkim90049
    swkim90049
    301 Posts

    Re: Make database name appear on every screen or at least login?

    ‏2013-01-28T19:04:53Z  
    • scottsd
    • ‏2013-01-28T18:28:12Z
    This information is stored in this system property, visible in the System Properties application:

    mxe.db.url

    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.

    Thank,
    Scott
    I just made a bulletin board entry and put that in the start center for maxadmin. hopefully, that will be good enough. ;)
  • maxmadman
    maxmadman
    67 Posts

    Re: Make database name appear on every screen or at least login?

    ‏2013-01-29T15:32:09Z  
    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.
  • swkim90049
    swkim90049
    301 Posts

    Re: Make database name appear on every screen or at least login?

    ‏2013-01-29T16:11:40Z  
    • maxmadman
    • ‏2013-01-29T15:32:09Z
    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.
    We are on 6.2.8... is this for 7.x and on?
  • maxmadman
    maxmadman
    67 Posts

    Re: Make database name appear on every screen or at least login?

    ‏2013-01-30T14:21:54Z  
    We are on 6.2.8... is this for 7.x and on?
    Should work for 6.x