Solved

Computer and User infomation from Active Directory into SQL Server

Posted on 2013-05-21
1
159 Views
Last Modified: 2013-09-18
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
0
Comment
Question by:angel7170
1 Comment
 
LVL 20

Accepted Solution

by:
agonza07 earned 500 total points
ID: 39184520
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now