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

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.
François VDCIcT service DeskAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jose Gabriel Ortega CastroCEOCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
François VDCIcT service DeskAuthor Commented:
tks. you are right.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.