Maximo Open Forum

Hi,

I have a requirement to find list of users who logged into maximo ( like previous day) or last week and share that report. I tried using escalation but with that suppose if 10 records are there then i am getting 10 different mails in my mailbox. I tried via automation script too but there seems to be some issue and I do not have access to logs so i cant see the errors too.

I also thought if i could schedule the report from.maximo only but i do not see attempdate column from login tracking table there.

Can anyone help me or suggest how do I achieve it?

I can share the query if required.

Thanks

#EverythingMaximo

------------------------------
Trisha S
Tcs
------------------------------

For current users, you can drop a where clause into the users application:

userid in (select userid from maxsession) or (status in (select value from synonymdomain where maxvalue = 'BLOCKED' and domainid = 'MAXUSERSTATUS' and defaults = 1)) order by DEFSITE, USERID

This will identify who is logged in or blocked at the time the query runs. 

For history, you want to query the 'LOGINTRACKING' object, which includes the attempted date, attempted result, name, and user, so your main piece of criteria would be ' "LOGINTRACKING.ATTEMPTRESULT = 'LOGIN' " plus your date range and whatever else you want to display. Login Tracking will need to be enabled:

Build your report from there. If you make it in BIRT, you can pre-load your date range with substitution variables (like ATTEMPTDATE > GETDATE()-7 or ATTEMPTDATE > SYSDATE-7, etc.) and then just schedule the report weekly and distribute to whomever you like

------------------------------
Christopher Winston
Projetech Inc.
IBM Champion 2024
------------------------------

Hi @Trisha S!

In users application, you need to execute this where claus: 

userid in (select distinct userid 
from maximo.logintracking 
where attemptdate >= current date - 7 days)

It will list the users who connected in the last week.

Then, you need to "Create report" in More Option menu

Create the report and then schedule it to be sent whenever you decide. The report will list the users who logged in (in this case, the last 7 days).

You will receive a single email with an attachment, as you need.

Regards!

------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------