CurrentStartofDay Function (Version 3.2 onwards)

 

CurrentStartofDay function returns the start of day time stamp depending on the attribute type. for e.g. if the attribute is of type Generalized Time it will return the timestamp in Generalized Time format, if the attribute is of type Nano 100 seconds it will return the timestamp in Nano 100 format etc.

 

Syntax:

CurrentStartofDay

CurrentStartofDay - (n) days

CurrentStartofDay - (n) months

CurrentStartofDay - (n) years

CurrentStartofDay - (n) hours

CurrentStartofDay - (n) minutes

CurrentStartofDay - (n) seconds

where n is the number, for e.g CurrentStartofDay-30 days

 

CurrentStartofDay supports both select and update statements.

 

Examples:

Select Statement Examples using CurrentStartofDay

 

Query

Search For

 SELECT FROM OU=Chicago,OU=US,DC=LDAPSoft where badPasswordTime >= CurrentStartofDay - 8 days
subtreescope

To find out all the entries entered a bad password from the start of current day to the start of current day - 8 days

SELECT FROM OU=Chicago,OU=US,DC=LDAPSoft where createTimeStamp >= CurrentStartofDay - 8 days
subtreescope

To find out all the entries created from the start of current day to the start of current day - 8 days

SELECT FROM OU=Chicago,OU=US,DC=LDAPSoft where objectCategory='Person' and objectClass='User' and lockoutTime<= CurrentStartofDay - 8 days and lockoutTime!=0 subtreescope

To find out all user entries with lockout time less then equal to the start of current day to the start of current day - 8 days

 

 

Update Statement Examples using CurrentStartofDay

Query

Results

 UPDATE cn=testuser4,ou=testusers,o=stooges set description= CurrentStartofDay -7 days
subtreescope

Update description atribute of cn=testuser4,ou=testusers,o=stooges with CurrentStartofDay -7 days, the attribute must be of type timestamp or you will get an error.

 

UPDATE ou=testusers,o=stooges set description= CurrentStartofDay -7 days
subtreescope

Update description attribute all entries in container ou=testusers,o=stooges with CurrentStartofDay -7 days, the attribute must be of type timestamp or you will get an error.

 

Related Links:

Current Timestamp Function

Current End of Day Function

Random Numbers Function

Random Alphabets Function

 


Ldapsoft Home page AD Admin Tool Home Page