LDAP query

Posted on 2007-12-03
Medium Priority
Last Modified: 2008-05-30
I am trying to run a query using Active Directory and I need the following information:

A breakdown of each server by name with logon user id (last logged on user)
# of computers (desktops and laptops) with computer name and log on user id (last logged on user)
# of printer queues with queue name and server name where the print queue is in.

I was able to pull the following information from AD using these queries:

-For servers:(&(objectCategory=computer)(!operatingSystem=Windows XP Professional)(!operatingSystem=Windows XP Tablet Edition)(!operatingSystem=Windows 2000 Professional))

-For workstations:(&(objectCategory=computer)(!operatingSystem=Windows 2003 Server)(!operatingSystem=Windows 2000 Server)(!description=Virtual Server Account))

-For printers:(&(objectCategory=printQueue)(serverName=*))
Question by:DAMAdmin
1 Comment
LVL 30

Accepted Solution

LauraEHunterMVP earned 2000 total points
ID: 20398783
Last logged on username isn't stored in AD, you'll need to use WMI to poll each workstation individually.

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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.

Join & Write a Comment

Native ability to set a user account password via AD GPO was removed because the passwords can be easily decrypted by any authenticated user in the domain. Microsoft recommends LAPS as a replacement and I have written an article that does something …
In this article, we will discuss how you can secure Active Directory using free tools, and how you can choose a safe and secure Active Directory security auditing tool.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

624 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