User Report with attribs & email file?

Welcome Forums General PowerShell Q&A User Report with attribs & email file?

This topic contains 1 reply, has 2 voices, and was last updated by

4 years, 4 months ago.

  • Author
  • #13322

    Points: 0
    Rank: Member


    I'm working on yet another script and stuck on what to do with this. I need to query AD and use the quest module as it's a 2003 domain with no gateway available.

    I can query the domain to get the list of users and then select the properties that I want. But I know there's alot more to it. I have to query the domain, exclude specific Organizational Units and also accounts that match a string such as 'systemmailbox'.

    Then format it and put it into excel which is the 'top' option or a csv file, but it has to be 2 sheets. I need to sort the sheets into enabled users in 1 worksheet and then disabled users in a 2nd worksheet. I've searched around and haven't found anything yet. I'm trying to get started using some of the other scripts I've gotten help with, but not having any luck.

    Can anyone help? The query I have is just get-qaduser | select displayname, company, dn, enabled, primarysmtpaddress and now I'm stuck. I started a foreach loop and that's where I think this ends up, but I'm not sure.

  • #18811

    Points: 1,785
    Helping HandTeam Member
    Rank: Community Hero

    You're asking for a lot – it might help if you picked one place you were stuck and use that maybe as a starting point?

The topic ‘User Report with attribs & email file?’ is closed to new replies.