Solved

Date Range in Active Directory

Posted on 2011-02-24
5
246 Views
Last Modified: 2012-05-11
I was trying to find some example to retrieve user based on Date Range.

For Eg: if i give a date like 1/01/2011 to 31/01/2011 in my windows application.

I wanna retrieve the user info , created on these date ranges.

For Eg: User Bob Created on 15/01/2001,then i have to retrieve that user name.

but am not sure what's the "Search Filter" for that.

Any help appreciated
0
Comment
Question by:Sha1395
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:ramkihardy
ID: 34968667
HI,
    get the dates entered by the user and convert it to datetime....
like this
Get the Date from the two date fields and convert them to DateTime by using Convert.ToDateTime(DateFiledValue) write a query like this
string SQL=Select Username from UserMst where name='Bob' and Created on between 'Converted From Date Field Value ' AND 'Converted To Date Field Value'.....
This query will give the desired result............
If Any Help please Let me know...
Mark it as answer if it is helpful...
With Regards



0
 

Author Comment

by:Sha1395
ID: 34968730
Hi Ramki,

Am not querying SQL,i havey to Query Active Directory.
0
 
LVL 2

Accepted Solution

by:
ramkihardy earned 250 total points
ID: 34968806
Sorry shah...I didnt noticed it....i have also a another solution...use can query active directy from your sql server...see this example......http://support.microsoft.com/kb/319716.....and also this might be very helpfull.http://www.codeproject.com/KB/system/everythingInAD.aspx...
pls let me know if u want anyother....
0
 

Author Comment

by:Sha1395
ID: 34968877
Thanks Ramki,

I checked codeproject,none of them give an example or syntax for "date range" search filter.

I can't use Sql Server,bcoz my requirement is to write a Class Library file (DLL) on C#.

Appreciated for your help
0
 
LVL 53

Assisted Solution

by:Dhaest
Dhaest earned 250 total points
ID: 34978442
Perhaps you can retrieve all the users (without the date-range) and check this in an if-statement to see if the user is created within these dates?

if(user.properties["whenCreated"].value > StartDate && user.properties["whenCreated"].value < EndData)
{
user.properties["whenCreated"].value.ToString()
}
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now