SpiraTeam - login history

Tuesday, May 15, 2018 7:18:32 AM

Hello,

I need to create list of users with information when they were logged in for the last time. Could you please tell me where i can find this option?

Tomasz

 

3 Replies
Tuesday, May 15, 2018 2:01:11 PM
Avatar
re: tomasz.owsiany on Tuesday, May 15, 2018 7:18:32 AM

Hi Tomasz,

Please see this KB article:

Creating a Report of All Users in the System https://www.inflectra.com/Support/KnowledgeBase/KB103.aspx

If you do select value R from SpiraTestEntities.R_Users as R where R.IS_ACTIVE = True
It will return back all the available columns (it's the equivalent of SELECT *)

Regards,

Elise

Wednesday, May 16, 2018 8:49:08 AM
Avatar
re: inflectra.elise on Tuesday, May 15, 2018

I used this query and preview result is ok

but when i create new report to MS-EXCEL this problem appears:

Thursday, May 17, 2018 3:05:31 PM
Avatar
re: tomasz.owsiany on Wednesday, May 16, 2018

Hi Tomasz,

Usually that error means that the XSLT template is blank in your custom section. See the Template field below the Query field? Something needs to be in there. The easiest way to populate it is to click on "+Create Default Template" button.

Regards,

Elise

Statistics
  • Started: Tuesday, May 15, 2018 7:18:32 AM
  • Last Reply: Thursday, May 17, 2018 3:05:31 PM
  • Replies: 3
  • Views: 225