Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Active Directory USer, Compter & Server Security Queries

Hi, I'd like to use Power BI to query Active Directory & get the following information. Most of teh examples I see are all about users, however I would like server & computer info as well. Can anyon...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

Its only 700 users & about 1000 computers. I can access it & I have created a Power BI file that has accessed about 20 tables. I have split it & filtered it all so I have nice seperate columns. I now have to create the interrogations to get the data. I see there is a good blog on getting user info so I am going to try and learn from that. It just seemed logical to ask the Power BI experts who have worked with AD and could give e a hand. Once I am up to speed and can help back.

M

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Good that it works for you. Many of us deal with ADs that are quite a bit bigger, and Power BI quickly becomes the wrong tool for handling this. Most of the processing is done before the data is ingested in Power BI.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    i again,

    I want to try something simple and findout the password information. The ones that interest me are:

    • Paswword info
      • ms-DS-Password-Settings,
      • Bad-Password-Time,
      • Machine-Password-Change-Interval,
      • ms-DS-ManagedPassword, 
      • ms-DS-ManagedPasswordInterval,
      • ms-DS-ManagedPasswordId,
      • ms-DS-ManagedPasswordPreviousId, 
      • ms-DS-Maximum-Password-Age, 
      • ms-DS-Minimum-Password-Age, 
      • ms-DS-Minimum-Password-Length, 
      • ms-DS-Password-Complexity-Enabled, 
      • ms-DS-Password-History-Length
      • ms-DS-User-Dont-Exprie-Password
      • ms-DS-User-Password-Expired
      • ms-DS-User-Password-Not-Required
    • Login info:
      • Last-Logon
      • Last-Logoff

    In the online doc, it indicates that these should be in top or user, however I can't see them in the Table Records. Any idea where I can find them? Is there something I am not understanding?

    Thanks

    M