Solved

Computer and User infomation from Active Directory into SQL Server

Posted on 2013-05-21
1
155 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 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

15 Experts available now in Live!

Get 1:1 Help Now