Getting user information

[mirws]

Hi everyone... I'm new here... and I'm a pure newbie in maximo
I have a question, How can we to get logged user information in maximo???, I need this for my report. My User ask me to add an user logged information in the report.

Thanks..

[DennisSchumann]

Hi Mirws,

I'm not sure if this is what you want but you can enable user login tracking. It's the property LOGINTRACKING defined in the table MAXVARS. But remember, it slows down your maschine because each login will be tracked in the table LOGINTRACKING....

Regards....

[Ethen]

I dont know how to do it in report but in maximo we can get the current user info using
MboRemote.getUserInfo();

from this object various information like username, default site etc can be retrieved.

hope it helps

[stef_g]

not sure what reporting system you are using but this works for me in SQL with Maximo 6.2

select 

maxsession.userid as NAME,
maxuser.type as USER_TYPE,
maxsession.clienthost as USER_PC#,
CONVERT(VARCHAR, maxsession.logindatetime, 13)as LOGIN_TIME,
CONVERT(VARCHAR, maxsession.lastactivity, 13)as LAST_ACTIVITY


from maxsession

left join maxuser on maxsession.userid = maxuser.userid

where active = '1'

order by maxuser.type,lastactivity desc

[Ethen]

doenst max session controls only currently logged on users.. if I am not wrong it doesnt keep data of users who have logged off.

[stef_g]

it does, but i thought that is what they were after

here is the SQL query which will show all login activity

select

attemptdate,
maxsessionuid,
name,
maxuser.type,
attemptresult7,
clienthost

from logintracking

left join maxuser on logintracking.userid = maxuser.userid

where attemptresult7 <> 'success' and name <> 'maxadmin'

order by maxsessionuid desc, attemptdate desc

[Ethen]

from users appliaction, in selection action -> security controls. enable login tracking first.

[anks123]

logintracking is the name of table from  where you can extract all the required details for your report.
i have created a similar report .

[Ethen]

if you are using actuate report, override Function GetText ( ) of text control using the following code:

Function GetText ( ) As String
GetText = GetServerUserName ( )
End Function 

[pmormile]

I am not an expert at this system but - I have found this information useful:

In Maximo menu do the following:

Go to --> Security  --> Users

Go to the select action Menu and choose manage sessions.

From here you can see who is currently logged in and if you go to the login tracking tab you
can see the login history. You can also hit the download button and it will download all
of this information into an excel spreadsheet for you.

Not sure if that is what you are looking for but... hope it helps.

[Yesterday]

• PM Estimated Due Date whe... by canislupus [Yesterday at 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [Yesterday at 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [Yesterday at 12:26:23 pm]
• add user access by Sarbjeet.Jassal [Yesterday at 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [Yesterday at 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]