Re: Current LDAP Limitations?

[Jason Miller]

Confirmed on ARS 7.5 p1.  I was able to query by createTimeStamp,
whenCreated, whenChanged and modifyTimeStamp.  I didn't vet the results too
thoroughly but the number of results returned looked about right.

Jason

On Wed, May 12, 2010 at 11:49 AM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:

> I am currently using ARS 7.1.0 Patch 007 (on Solaris).  I can see the
> Date/Time fields on my vendor form but still cannot query by them.
>
> Anybody on 7.5 want to add whenChanged or modifyTimeStamp to your LDAP
> vendor form and try to query by it?
>
> As for #2 I believe it is a setting in the AD for max rows returned.
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] On Behalf Of William Rentfrow
> Sent: Wednesday, May 12, 2010 12:06 PM
> To: arslist@ARSLIST.ORG
> Subject: Current LDAP Limitations?
>
> **
> Back around Remedy 5.6 was the last time I tried to pull large quantities
> of data from Active Directory using the Remedy LDAP/ARDBC > Active Directory
> integration.
>
> Setting it up was easy but we had two issues back then:
>
> 1.) We couldn't query by date fields - no results were returned
> 2.) Page sizing was an issue and it would only return X,XXX records -
> To get the 750,000 I needed we had to do batches.
>
> So - does anyone know if these issues are fixed?  If I remember right it
> wasn't actually a BMC problem but it was related to the MS connector.  I
> can't find any good info on this.
>
> William Rentfrow
> Principal Consultant, StrataCom Inc.
> wrentf...@stratacominc.com
> Corporate Website, www.stratacominc.com
> Blog, www.williamrentfrow.com
> 715-410-8156 C
>
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Current LDAP Limitations?

[Scott Hammons]

You also may need to check the uid your connecting with to query the AD 
directly (LDAP Searches).  Not only are there size limits in most LDAP's for 
searches, depending on where the search is being conducted (i.e., at the root 
level or specific container like cn=users,cn=, etc...) the account 
your connecting with may not have the necessary rights within the directory 
structure.

Hope this helps.

Scott

From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On 
Behalf Of Grooms, Frederick W [frederick.w.gro...@xo.com]
Sent: Wednesday, May 12, 2010 2:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Current LDAP Limitations?

I am currently using ARS 7.1.0 Patch 007 (on Solaris).  I can see the Date/Time 
fields on my vendor form but still cannot query by them.

Anybody on 7.5 want to add whenChanged or modifyTimeStamp to your LDAP vendor 
form and try to query by it?

As for #2 I believe it is a setting in the AD for max rows returned.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of William Rentfrow
Sent: Wednesday, May 12, 2010 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Current LDAP Limitations?

**
Back around Remedy 5.6 was the last time I tried to pull large quantities of 
data from Active Directory using the Remedy LDAP/ARDBC > Active Directory 
integration.

Setting it up was easy but we had two issues back then:

1.) We couldn't query by date fields - no results were returned
2.) Page sizing was an issue and it would only return X,XXX records - To get 
the 750,000 I needed we had to do batches.

So - does anyone know if these issues are fixed?  If I remember right it wasn't 
actually a BMC problem but it was related to the MS connector.  I can't find 
any good info on this.

William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com
Blog, www.williamrentfrow.com
715-410-8156 C


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Current LDAP Limitations?

[Grooms, Frederick W]

I am currently using ARS 7.1.0 Patch 007 (on Solaris).  I can see the Date/Time 
fields on my vendor form but still cannot query by them.

Anybody on 7.5 want to add whenChanged or modifyTimeStamp to your LDAP vendor 
form and try to query by it?

As for #2 I believe it is a setting in the AD for max rows returned.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of William Rentfrow
Sent: Wednesday, May 12, 2010 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Current LDAP Limitations?

** 
Back around Remedy 5.6 was the last time I tried to pull large quantities of 
data from Active Directory using the Remedy LDAP/ARDBC > Active Directory 
integration.
 
Setting it up was easy but we had two issues back then:
 
1.) We couldn't query by date fields - no results were returned
2.) Page sizing was an issue and it would only return X,XXX records - To get 
the 750,000 I needed we had to do batches.
 
So - does anyone know if these issues are fixed?  If I remember right it wasn't 
actually a BMC problem but it was related to the MS connector.  I can't find 
any good info on this.
 
William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com
Blog, www.williamrentfrow.com
715-410-8156 C
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Current LDAP Limitations?

[Andrey]

2010/5/12 William Rentfrow :
> **
> Back around Remedy 5.6 was the last time I tried to pull large quantities of
> data from Active Directory using the Remedy LDAP/ARDBC > Active Directory
> integration.
>
> Setting it up was easy but we had two issues back then:
>
> 1.) We couldn't query by date fields - no results were returned
> 2.) Page sizing was an issue and it would only return X,XXX records - To get
> the 750,000 I needed we had to do batches.

It sounds like a limitation of Active Directory about the number of
objects returned from a LDAP query,
and not use "batch" will not work.
You can try to increase this limit in Active Directory (MaxPageSize)

See "Windows 2000 and Windows Server 2003 LDAP administration limits"
- http://support.microsoft.com/kb/315071

> So - does anyone know if these issues are fixed?  If I remember right it
> wasn't actually a BMC problem but it was related to the MS connector.  I
> can't find any good info on this.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Current LDAP Limitations?

[William Rentfrow]

Back around Remedy 5.6 was the last time I tried to pull large
quantities of data from Active Directory using the Remedy LDAP/ARDBC >
Active Directory integration.
 
Setting it up was easy but we had two issues back then:
 
1.) We couldn't query by date fields - no results were returned
2.) Page sizing was an issue and it would only return X,XXX records - To
get the 750,000 I needed we had to do batches.
 
So - does anyone know if these issues are fixed?  If I remember right it
wasn't actually a BMC problem but it was related to the MS connector.  I
can't find any good info on this.
 
William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com  
Blog, www.williamrentfrow.com  
715-410-8156 C
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"