what's the best way to report changes to AD users : Importing data into AD

Daoust ICT
Daoust ICT used Ask the Experts™
on
Dear,
I will have to PowerShell a data import from HR software to AD.
The purpose is to track ADD/Update/Delete as usual AND also the changes (names/adress.....)

Following your own experience, what would you suggest as best format to be used to track things. Any hint? tips & tricks are welcome.
I'm thinking of CSV, html, XML, at the very end (but no time for the moment a SQL DB)... OR maybe does AD already have such functionality and therefore almost Nothing to be foreseen ?
Maybe I'm missing a evident solution?

Thanks to all.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Rated Freelancer on MS Technologies
Awarded 2018
Distinguished Expert 2018
Commented:
Hi there I don't think there's a "best way" or "format" to do that.
I think that you need to get it in the format that you needed to with the goal of processing historical values, it can be saved in XML files, or HTML files for reports, that really depends on how you want the things going.

The best way is to store it in a DB (MySQL or MS SQL), but you can save it in any XML, JSON, or CSV while you get the DB server to feed it with data.
I would go with JSON or XML., and to do foreseen you need to load all the XML or JSON into PowerShell and then execute queries to the objects loaded in memory. :) That's what I can think of right now.

The key point is the data, how you store it or use it depends on you.
Daoust ICTIcT service Desk

Author

Commented:
tks. you are right.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial