Forum Discussion

ajf's avatar
ajf
New Member
4 years ago

Get Data from AD - lastlogondate

Hi,

I am pretty new with PowerBI.

 

I wanna get data from AD for the last logon of both Computer and user objects and then filter lastlogon date older then 90 days.

 

I managed to connect to the AD Database, however I am missing the attributes for lastlogondate. How can I retrieve such attributes so I can load this data?

 

Thanks!

Need Help

4 Replies

  • Watsky's avatar
    Watsky
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hey ajf ,

     

    In user you should see lastLogon that exists inside the user record. 

    I checked but I'm not seeing that the same exists in computer for the AD connector though.

     

  • ajf's avatar
    ajf
    New Member
    4 years ago

    Hi,

    thanks for your reply... yeah, managed to find that but no luck with the computer one. Weird since attribute exist in AD.

  • ajf's avatar
    ajf
    New Member
    4 years ago

    I can confirm that you need to use the user.lastlogontimestamp too for the Computer object. Did not understand the logic behind it though, but it works. If anyone can share the logic, it would be great 😃