|
 |
asp_web_howto thread: NT Security
Message #1 by "O'Hara, Elliott M" <EMOHARA@k...> on Wed, 21 Feb 2001 13:18:11 -0500
|
|
I know this isn't really a ASP issue, but I know we have a buncha Database
gurus here....
Is there a way to import a whole list of NT Users to MS SQL 7???
It would save me a BUNCH of work....
Message #2 by "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> on Thu, 22 Feb 2001 14:20:20 -0000
|
|
Elliott,
Your question got me intrigued so i asked one of my NT admin pals how he
though it could be done
You can create a text file which lists all the users by opening a command
prompt and typing
net users > users.txt
or to get the whole domain
net users /domain > users.txt
Then once you have the text file you can either import into access, tidy up
the data and cut and paste into your linked SQL table, or you can write a
script that will parse the text file and put the data into the database.
Enjoy!
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Wednesday, February 21, 2001 6:18 PM
To: ASP Web HowTo
Subject: [asp_web_howto] NT Security
I know this isn't really a ASP issue, but I know we have a buncha Database
gurus here....
Is there a way to import a whole list of NT Users to MS SQL 7???
It would save me a BUNCH of work....
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com
Message #3 by "Drew, Ron" <RDrew@B...> on Thu, 22 Feb 2001 10:05:44 -0500
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C09CE0.EDD72080
Content-Type: text/plain;
charset="iso-8859-1"
Commands do work BUT>>>>>
net users > users.txt will only give you the profiles on the local PC you
are on (probably yourself and the local Administrator only)
net users /domain > users.txt will give you everyone on the domain. That's
the good news. The bad news is that it is ugly. 3 columns of Userids and
junk (header and footer) so you have alot of cut and paste. Userids only so
you can not check passwords but can use it to verify user is a valid domain
user if you load it to a table in sql or access. Just make sure you do it
frequently as there is no automatic sync.
Ron
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Thursday, February 22, 2001 9:20 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: NT Security
Elliott,
Your question got me intrigued so i asked one of my NT admin pals how he
though it could be done
You can create a text file which lists all the users by opening a command
prompt and typing
net users > users.txt
or to get the whole domain
net users /domain > users.txt
Then once you have the text file you can either import into access, tidy up
the data and cut and paste into your linked SQL table, or you can write a
script that will parse the text file and put the data into the database.
Enjoy!
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Wednesday, February 21, 2001 6:18 PM
To: ASP Web HowTo
Subject: [asp_web_howto] NT Security
I know this isn't really a ASP issue, but I know we have a buncha Database
gurus here....
Is there a way to import a whole list of NT Users to MS SQL 7???
It would save me a BUNCH of work....
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com
$subst('Email.Unsub')
Message #4 by "Eric Van Camp" <eric@a...> on Thu, 22 Feb 2001 16:47:40 -0000
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C09CEF.2B870680
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
hi there, i did not follow your discussion but be aware that i you want to
implement the nt security using the challenge response method, that only
internet explorer will work!
ceeya
-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: Thursday, February 22, 2001 3:06 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: NT Security
Commands do work BUT>>>>>
net users > users.txt will only give you the profiles on the local PC
you are on (probably yourself and the local Administrator only)
net users /domain > users.txt will give you everyone on the domain.
That's the good news. The bad news is that it is ugly. 3 columns of
Userids and junk (header and footer) so you have alot of cut and paste.
Userids only so you can not check passwords but can use it to verify user is
a valid domain user if you load it to a table in sql or access. Just make
sure you do it frequently as there is no automatic sync.
Ron
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
Sent: Thursday, February 22, 2001 9:20 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: NT Security
Elliott,
Your question got me intrigued so i asked one of my NT admin pals how he
though it could be done
You can create a text file which lists all the users by opening a
command
prompt and typing
net users > users.txt
or to get the whole domain
net users /domain > users.txt
Then once you have the text file you can either import into access, tidy
up
the data and cut and paste into your linked SQL table, or you can write
a
script that will parse the text file and put the data into the database.
Enjoy!
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Wednesday, February 21, 2001 6:18 PM
To: ASP Web HowTo
Subject: [asp_web_howto] NT Security
I know this isn't really a ASP issue, but I know we have a buncha
Database
gurus here....
Is there a way to import a whole list of NT Users to MS SQL 7???
It would save me a BUNCH of work....
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com
$subst('Email.Unsub')
$subst('Email.Unsub')
Message #5 by "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> on Thu, 22 Feb 2001 15:42:34 -0000
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C09CE6.138F359C
Content-Type: text/plain;
charset="iso-8859-1"
For that reason writing a script would be the best way forward. then the
net users /domain > users.txt command and the script could be scheduled to
run once a month, or whatever
-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: Thursday, February 22, 2001 3:06 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: NT Security
Commands do work BUT>>>>>
net users > users.txt will only give you the profiles on the local PC you
are on (probably yourself and the local Administrator only)
net users /domain > users.txt will give you everyone on the domain. That's
the good news. The bad news is that it is ugly. 3 columns of Userids and
junk (header and footer) so you have alot of cut and paste. Userids only so
you can not check passwords but can use it to verify user is a valid domain
user if you load it to a table in sql or access. Just make sure you do it
frequently as there is no automatic sync.
Ron
-----Original Message-----
From: Alex Shiell, ITS, EC, SE [ mailto:alex.shiell@s...
<mailto:alex.shiell@s...> ]
Sent: Thursday, February 22, 2001 9:20 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: NT Security
Elliott,
Your question got me intrigued so i asked one of my NT admin pals how he
though it could be done
You can create a text file which lists all the users by opening a command
prompt and typing
net users > users.txt
or to get the whole domain
net users /domain > users.txt
Then once you have the text file you can either import into access, tidy up
the data and cut and paste into your linked SQL table, or you can write a
script that will parse the text file and put the data into the database.
Enjoy!
-----Original Message-----
From: O'Hara, Elliott M [ mailto:EMOHARA@k...
<mailto:EMOHARA@k...> ]
Sent: Wednesday, February 21, 2001 6:18 PM
To: ASP Web HowTo
Subject: [asp_web_howto] NT Security
I know this isn't really a ASP issue, but I know we have a buncha Database
gurus here....
Is there a way to import a whole list of NT Users to MS SQL 7???
It would save me a BUNCH of work....
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com <http://www.scottish-enterprise.com>
---
$subst('Email.Unsub')
$subst('Email.Unsub')
________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com
This message is sent in confidence for the addressee only.
It may contain legally privileged information. The contents are not to
be disclosed to anyone other than the addressee. Unauthorised recipients
are requested to preserve this confidentiality and to advise the sender
immediately of any error in transmission.
|
|
|
View Cart
