Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

2 Pages<12
Untag as favorite
Cleaning COMPUTERS not in Active Directory
Options
Previous Topic Next Topic
Cobra7
#16 Posted : Saturday, June 27, 2009 12:49:56 AM

Rank: Premium user

Groups: Member, Premium Users
Posts: 147
Location: Omaha
It would be something like:

SELECT Name FROM 'LDAP://dc=Microsoft,dc=com' WHERE

or

SELECT Name FROM 'LDAP://dc=Cox,dc=net' WHERE

or

SELECT Name FROM 'LDAP://dc=PETA,dc=org' WHERE
Back to top
tp-tec_CE
#17 Posted : Monday, July 13, 2009 1:59:30 PM


Rank: Premium user

Groups: Member, Premium Users
Posts: 19
Location: Germany
Hello.

Is it possible to do something similar for Useraccounts?

We have a lot of old Useraccounts stored in the database.
(users that are no longer working for our company)
These accounts do not exist any more in our AD.

Thank you!

Greetings,
Mike
Back to top
| Edit by user
Lansweeper
#18 Posted : Monday, July 13, 2009 9:29:33 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,369
This will come standard in version 4.0 (for users and computers)
Back to top
jreimer
#19 Posted : Wednesday, December 02, 2009 8:18:09 PM
Rank: Freeware Member

Groups: Member
Posts: 34
Location: Ellenville, NY
I am getting the same error as above with the script error in line 43

objCommand.CommandText = "SELECT Name FROM 'LDAP://dc=services,dc=local' WHERE objectCategory='computer' AND Name='" & SQLName & "'"
set objRSAD = objCommand.Execute

My domian is Services.local

Do i have that setup correctly?
Back to top
AdmJLovejoy
#20 Posted : Thursday, April 22, 2010 3:04:27 AM


Rank: Premium user

Groups: Premium Users
Posts: 124
Location: USA
Use caution with this script if you have more than one domain, or have workgroup mode clients in Lansweeper. This script, as written, will remove all computers from Lansweeper except for those in the target domain, hard coded in the script.

Thanks,

Jim Lovejoy
__________________________________________________________________________________________________
James W. Lovejoy | IBM - Managed Services Delivery | Infrastructure Architect (Windows Server Platform)
Back to top
Users browsing this topic
Guest
2 Pages<12
Untag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba