How can we fetch data from Active Directory Service in different time frames and store in

Would you mind to give more detail description of your requirement?

It is not enough information for troubleshoot.

Roger

• Edited by System Center guyMicrosoft community contributor 23 hours 1 minutes ago

Hi Tatheer,

I'm not sure if this is what you mean, but you can use Windows (Server) Backup to backup the System State.
This backup includes Active Directory.

For details: https://msdn.microsoft.com/en-us/library/bb727048.aspx

Regards,

Matthijs

• Proposed as answer by M. ter Horst 22 hours 58 minutes ago

Would you mind to give more detail description of your requirement?

It is not enough information for troubleshoot.

Roger

• Edited by System Center guyMicrosoft community contributor Tuesday, July 07, 2015 8:09 AM

Would you mind to give more detail description of your requirement?

It is not enough information for troubleshoot.

Roger

• Edited by System Center guyMicrosoft community contributor Tuesday, July 07, 2015 8:09 AM

Hi Tatheer,

I'm not sure if this is what you mean, but you can use Windows (Server) Backup to backup the System State.
This backup includes Active Directory.

For details: https://msdn.microsoft.com/en-us/library/bb727048.aspx

Regards,

Matthijs

• Proposed as answer by M. ter Horst Tuesday, July 07, 2015 8:11 AM

Hi Tatheer,

I'm not sure if this is what you mean, but you can use Windows (Server) Backup to backup the System State.
This backup includes Active Directory.

For details: https://msdn.microsoft.com/en-us/library/bb727048.aspx

Regards,

Matthijs

• Proposed as answer by M. ter Horst Tuesday, July 07, 2015 8:11 AM

Hi Sir,

If you are going to backup your AD please follow Matthijs's suggestion .

If you just want to query AD information and store it in SQL for analysis , please refer to following article regarding to query AD information with T-SQL :

http://blog.skufel.net/2012/01/how-to-use-sql-server-to-query-active-directory/

http://www.databasejournal.com/features/mssql/article.php/3849891/Query-Active-Directory-Data-from-SQL-Server-using-T-SQL.htm

Best Regards,

El