LDAP Query Syntax help

[chef]

I am trying to construct the correct syntax for an LDAP query. At present I have

ldap://clientaddress.com/o=client.com?uid?sub?(&(objectclass=clientperson)(clientmetalink=ITDESK)(modifytimestamp>=20120110000000Z))

which pulls all people records modified after 10th Jan 2012.

This works fine, however the modifytimestamp query is fixed.

I am trying to replace the fixed timestamp 20120110000000Z with a calculated variable of something like 'today - 3 days' using any inbuilt operators/variables LDAP has (that's the bit I can't find out).

e.g

ldap://clientaddress.com/o=client.com?uid?sub?(&(objectclass=clientperson)(clientmetalink=ITDESK)(modifytimestamp>=currentDate -3 days))

Does anyone have any ideas on the correct LDAP syntax for this? Is it even possible?

 

[pmeswani]

I am trying to construct the correct syntax for an LDAP query. At present I have

ldap://clientaddress.com/o=client.com?uid?sub?(&(objectclass=clientperson)(clientmetalink=ITDESK)(modifytimestamp>=20120110000000Z))

which pulls all people records modified after 10th Jan 2012.

This works fine, however the modifytimestamp query is fixed.

I am trying to replace the fixed timestamp 20120110000000Z with a calculated variable of something like 'today - 3 days' using any inbuilt operators/variables LDAP has (that's the bit I can't find out).

e.g

ldap://clientaddress.com/o=client.com?uid?sub?(&(objectclass=clientperson)(clientmetalink=ITDESK)(modifytimestamp>=currentDate -3 days))

Does anyone have any ideas on the correct LDAP syntax for this? Is it even possible?

Stupid suggestion coming up. Does (currentDate - 3 days) work? (I.e. put the maths inside brackets). Also, can you pass a temporary variable to the modifytimestamp query? i.e. modifytimestamp>=notCurrentDate?

 

[chef]

Stupid suggestion coming up. Does (currentDate - 3 days) work? (I.e. put the maths inside brackets). Also, can you pass a temporary variable to the modifytimestamp query? i.e. modifytimestamp>=notCurrentDate?

the 'currentDate - 3 days' is simply an english description of what I'm trying to calculate, I don't think LDAP is that clever is it?

and no, no chance to pass a temp variable, that was my first line of thought.

Thanks for the suggestion though.

 

[doodab]

Check your PMs

 

[TheFaQQer]

I am trying to construct the correct syntax for an LDAP query. At present I have

ldap://clientaddress.com/o=client.com?uid?sub?(&(objectclass=clientperson)(clientmetalink=ITDESK)(modifytimestamp>=20120110000000Z))

which pulls all people records modified after 10th Jan 2012.

This works fine, however the modifytimestamp query is fixed.

I am trying to replace the fixed timestamp 20120110000000Z with a calculated variable of something like 'today - 3 days' using any inbuilt operators/variables LDAP has (that's the bit I can't find out).

e.g

ldap://clientaddress.com/o=client.com?uid?sub?(&(objectclass=clientperson)(clientmetalink=ITDESK)(modifytimestamp>=currentDate -3 days))

Does anyone have any ideas on the correct LDAP syntax for this? Is it even possible?

It should be possible to do it - this example shows how to do it in VB, but it doesn't look too different from the format that you are passing in.

 

[eek]

is it in a script?

Could the script generate the appropriate date translate it into a timestamp and put that into the ldap query.

 

[chef]

is it in a script?

Could the script generate the appropriate date translate it into a timestamp and put that into the ldap query.

yes eek that's the solution, shortly pipped to the post by Doodab.

problem solved

ARDBC LDAP plugin vendor form lookup
if you add the modified timestamp as a field to the vendor form and use it in a remedy query that does e.g. a set fields from the form, the plugin should do the necessary maths before retrieving the data.

fantastic all, many thanks from preventing an ageing chef going even more senile