Forum: HP Project & Portfolio Management: Report including Users Last Login Date

Search Forums

Forums

RSS

Share |

Forum Index » HP Project & Portfolio Management » Report including Users Last Login Date

Moderators: Parikshat Bajaj, Christopher Grant, Derek Hornby, Christel Mes, Julanne Rutten

Topic Score:

11/30/2010 at 2:06:31 AM GMT
dcornete Posts: 0	Report Permalink
Subject: Report including Users Last Login Date Hi, we have ~1,000 Users in our PPM 8.0 system. I need to find or create a report which will allow me to export the Users name/ID and the date of their last login. Any suggestions? Thanks!

11/30/2010 at 2:21:58 AM GMT

rmikel

Posts: 0

Report

Permalink

Subject: Login Summary portlet query

SELECT TO_CHAR(to_date(CREATION_DATE,dd/mm/yy\'),\'YY-MM-DD\') LOGIN_DATE, count(TO_CHAR(to_date(CREATION_DATE,'dd/mm/yy\'),\'YY-MM-DD\')) LOGIN_COUNT, SUCCESS_FLAG SUCCESS_FLAG FROM KNTA_LOGON_ATTEMPTS WHERE TO_CHAR(to_date(CREATION_DATE,'dd/mm/yy\'),\'YY-MM-DD\') >= TO_CHAR(to_date(CURRENT_DATE-15,'dd/mm/yy\'),\'YY-MM-DD\') GROUP BY TO_CHAR(to_date(CREATION_DATE,'dd/mm/yy\'),\'YY-MM-DD\'), SUCCESS_FLAG ORDER BY Login_Date'

11/30/2010 at 2:59:29 AM GMT

dcornete

Posts: 0

Report

Permalink

ok, so you are way too smart for me! :shock: Im pretty new at this. I was hoping there was an Out-of-the-Box report somebody could direct me to where all I had to do was find it and run it. Or, if I could create a customized dashboard that contained this field and I could simply export to Excel. If it's not that easy, I'll take your suggestion to our IT support guy and see if he knows what to do with it... I assume its custom code? Thanks for your quick reply!'

3/29/2011 at 1:53:28 AM GMT
RWoodmansee Posts: 0	Report Permalink
This sounds like a report that an admistrator would need. If so, you could run this from the workbench in the Sever Tools -> SQL Runner. The SQL Runner allows you to export the results into a Text file.

Edit This Favorite