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

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?
Jose Gabriel Ortega CConnect With a Mentor CEO J0rt3g4 Consulting ServicesCommented:
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.
François VDCIcT service DeskAuthor Commented:
tks. you are right.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.