Adding user names to collection

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Adding user names to collection

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Adding user names to collection

Page: [1]

Message

<< Older Topic Newer Topic >>

Adding user names to collection - 11/18/2008 4:52:00 PM

asamiuddin

Posts: 6
Score: 0
Joined: 6/5/2006
Status: offline

I found this vbscript CollAddUsers vbs in the forum, It works great but I have a small issue:

I need to add the exact user name given in the input text file, Not the 'is like' username.
for an example: if the input file contains the user name "dts" and active directory has user name "mydts" the script adds "mydts" account in the collection.

Any suggestions?

Post #: 1

RE: Adding user names to collection - 11/18/2008 10:45:31 PM

skissinger

Posts: 2293
Score: 145
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

In the script, the line containing "SELECT ResourceID from sms_r_user Where Name LIKE ""%" +

Change it from name LIKE to name =

(PS: Do I want to ask why you are targeting users? Maybe not. You know that makes it difficult (close to impossible) to remotely troubleshoot SW Distribs using existing 3rd-party tools like Roger Zanders' Client Center. And you know that tracking licensing will be a fun job. 1 person could have the licensed copy of Visio, so they log in all over the department "so everyone can have it". Nope, I'm not going to ask. Just perhaps I'll suggest you think about targeting machine names, instead of users to make you life less hellish.)

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to asamiuddin)