cancel
Showing results for 
Search instead for 
Did you mean: 
viv_prabha
Occasional Member - Level 1

Cognos report to check last password change date

Hi,

 

I have created a report with below data items to get last password change date

 

[Expense].[Employee Information].[Country]

[Expense].[Employee Information].[Employee ID]

[Expense].[Employee Information].[Employee Name]

[Expense].[Employee Information].[Active]

[Expense].[Report Header Information].[Employee E-mail Address]

[Expense].[Employee Information].[Password Change Date/Time]

 

Data item "Password Change Date/Time" is not providing the correct details. Either provide blank or incorrect date. Could you please suggest how to fix this issue to get correct details.

Note- All these data items are under one query. 

 

Regards

Vivek

 

1 Solution
Solution
KevinD
Community Manager
Community Manager

@viv_prabha so, I take it you tested this out by changing your own password and then running the report? Is that correct? Or how do you know the date is incorrect? 


Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.

View solution in original post

3 REPLIES 3
Solution
KevinD
Community Manager
Community Manager

@viv_prabha so, I take it you tested this out by changing your own password and then running the report? Is that correct? Or how do you know the date is incorrect? 


Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
viv_prabha
Occasional Member - Level 1

Hi Kevin,

 

I have tested with some other users and found that change date field is blank. Even in some other users it is showing incorrect date (start with 1990 year) which is not relevant. 

viv_prabha
Occasional Member - Level 1

 

Looking for solution. If you have any?