|
Home > Archive > Site Server General > January 2005 > Site Server Migration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Site Server Migration
|
|
| ShootMePlease 2005-01-25, 5:50 pm |
| I would like to retire my site server 3.0 server and move to a new product.
Does anyone know of a good way to export all of my users and passwords out
of the SQL table?
I have already figured out how to get the usernames by using the following
query, but I can't figure out how to get the passwords:
SELECT i_ObjectClass, vc_EntryName
FROM dbo.Object_Lookup
WHERE (i_ObjectClass = 13)
Any thoughts?
| |
| ShootMePlease 2005-01-25, 5:50 pm |
| I have also figured out that this query seems to retrieve the data I need
but is still not in a very usable format:
SELECT TOP 100 PERCENT vc_Val, i_Dsid, i_Aid
FROM dbo.Object_Attributes
WHERE (i_Aid = 29) OR (i_Aid = 124) or (i_Aid = 26) or (i_Aid = 502) or
(i_Aid = 41)
ORDER BY i_Dsid, i_Aid
Note:
i_Aid = 29 = firstame
i_Aid = 124 = lastname
i_Aid = 26 = company
i_Aid = 502 = username
i_Aid = 41 = password
"ShootMePlease" <nospam@nospam.org> wrote in message
news:%23E5za8uAFHA.3708@TK2MSFTNGP14.phx.gbl...
>I would like to retire my site server 3.0 server and move to a new product.
>Does anyone know of a good way to export all of my users and passwords out
>of the SQL table?
>
> I have already figured out how to get the usernames by using the following
> query, but I can't figure out how to get the passwords:
>
> SELECT i_ObjectClass, vc_EntryName
> FROM dbo.Object_Lookup
> WHERE (i_ObjectClass = 13)
>
> Any thoughts?
>
|
|
|
|
|