<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am trying to get all the Computer information from Active Directory and save them in SQL Server database. <br />
<br />
The information to pull from AD are as below<br />
computerName<br />
Organization Unit<br />
Manufacturer<br />
Model<br />
Serial Number<br />
RAM<br />
Processor<br />
Speed<br />
Last user who logged in<br />
Last Login time<br />
Last Logout Time<br />
<br />
Please help me accomplish this task.<br />
<br />
Thank you
</div>
</div>


Hello,

I am trying to get all the Computer information from Active Directory and save them in SQL Server database. 

The information to pull from AD are as below
computerName
Organization Unit
Manufacturer
Model
Serial Number
RAM
Processor
Speed
Last user who logged in
Last Login time
Last Logout Time

Please help me accomplish this task.

Thank you

Computer and User infomation from Active Directory into SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.