Active directory and RServices

Is it possible to access Active Directory and read user data who run the report.
Thx.Shouldn't need to. There is a global User!userid that you can use in your
report.
Use the expression builder and you will see it listed (plus other
potentially useful globals)
Bruce L-C
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:1DCB51E5-8D07-407C-A40A-B9A8347FE7FE@.microsoft.com...
> Is it possible to access Active Directory and read user data who run the
report.
> Thx.|||Yes i use userid, but i need to know user name and other useful information from AD. Maybe you use extrenal class to read needed data from AD.
Aleš
"Bruce Loehle-Conger" wrote:
> Shouldn't need to. There is a global User!userid that you can use in your
> report.
> Use the expression builder and you will see it listed (plus other
> potentially useful globals)
> Bruce L-C
> <AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
> news:1DCB51E5-8D07-407C-A40A-B9A8347FE7FE@.microsoft.com...
> > Is it possible to access Active Directory and read user data who run the
> report.
> >
> > Thx.
>
>|||You can create a dataset using OLE-DB provider for Microsoft Directory
Services (built into RS 2000) and query the AD as follows:
select name, mail from 'LDAP://DC=US,DC=corp,DC=xyz,DC=com' where
objectCategory='user' and department = 'Data Warehousing'
Refer to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/sql_dialect.asp
for details on LDAP SQL dialect.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:63F05F64-2295-4EB6-B73A-9ACA97C68221@.microsoft.com...
> Yes i use userid, but i need to know user name and other useful
information from AD. Maybe you use extrenal class to read needed data from
AD.
> Aleš
> "Bruce Loehle-Conger" wrote:
> > Shouldn't need to. There is a global User!userid that you can use in
your
> > report.
> >
> > Use the expression builder and you will see it listed (plus other
> > potentially useful globals)
> >
> > Bruce L-C
> >
> > <AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
> > news:1DCB51E5-8D07-407C-A40A-B9A8347FE7FE@.microsoft.com...
> > > Is it possible to access Active Directory and read user data who run
the
> > report.
> > >
> > > Thx.
> >
> >
> >