Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Active Directory

Has anyone done an reports from MS Active Directory in QlikView?

I have made the connections but I am struggling with the pwdlastset field and converting that into a useful date, as well as the account created date.  Of course MS stored these values as some weird number instead of just using a date.....

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

What is that werid number (an example would be nice) and what date does it represent?

Did you search the net for AD field information yet? MSDN?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If you search this forum for lastlogintimestamp you'll find lot's of info like:

convert to date the lastlogontimestamp from the active directory user properties

-Rob