topic Re: Active Directory in QlikView https://community.qlik.com/t5/QlikView/Active-Directory/m-p/1003130#M949819 <HTML><HEAD></HEAD><BODY><P>What is that werid number (an example would be nice) and what date does it represent?</P><P></P><P>Did you search the net for AD field information yet? MSDN?</P></BODY></HTML> Fri, 11 Dec 2015 23:34:36 GMT Peter_Cammaert 2015-12-11T23:34:36Z Active Directory https://community.qlik.com/t5/QlikView/Active-Directory/m-p/1003129#M949818 <HTML><HEAD></HEAD><BODY><P>Has anyone done an reports from MS Active Directory in QlikView?</P><P></P><P>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.&nbsp; Of course MS stored these values as some weird number instead of just using a date.....</P></BODY></HTML> Fri, 11 Dec 2015 22:20:49 GMT https://community.qlik.com/t5/QlikView/Active-Directory/m-p/1003129#M949818 2015-12-11T22:20:49Z Re: Active Directory https://community.qlik.com/t5/QlikView/Active-Directory/m-p/1003130#M949819 <HTML><HEAD></HEAD><BODY><P>What is that werid number (an example would be nice) and what date does it represent?</P><P></P><P>Did you search the net for AD field information yet? MSDN?</P></BODY></HTML> Fri, 11 Dec 2015 23:34:36 GMT https://community.qlik.com/t5/QlikView/Active-Directory/m-p/1003130#M949819 Peter_Cammaert 2015-12-11T23:34:36Z Re: Active Directory https://community.qlik.com/t5/QlikView/Active-Directory/m-p/1003131#M949820 <HTML><HEAD></HEAD><BODY><P>If you search this forum for lastlogintimestamp you'll find lot's of info like:</P><P><A href="https://community.qlik.com/thread/14663">convert to date the lastlogontimestamp from the active directory user properties</A></P><P></P><P>-Rob</P></BODY></HTML> Sat, 12 Dec 2015 00:02:20 GMT https://community.qlik.com/t5/QlikView/Active-Directory/m-p/1003131#M949820 rwunderlich 2015-12-12T00:02:20Z