Hi,
In earlier versions you could even have two users with the same login name
but different passwords. I think to recall that this "feature" was removed
in one of the recent versions.
I typically put unique indexes on these fields too in the User and Group
forms.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Michael,
>
> I have wondered that aloud too.. Its always been that way..
>
> Even the Login Name does not have a unique index on it in the user form...
> At least they put a simple index on it.. If I remember right, version 6.x
> didn't even have that simple index on it.. causing applications like
> customer support crawl on user form searches if you had close to a million
> customers..
>
> I asked support about it once and didn't get a good answer as to why an
> index is missing on that form.. now it looks like they have an index on
> the
> Login Name for version 7 but its not unique..
>
> In my experience it doesn't hurt to put those indexes yourself. I've
> always
> done it (both on the group and user form) with no negative effects - in
> fact
> it helped one of my customers quite a bit on the performance side after
> introducing those indexes as required.. Some parts of their system was
> virtually unusable before doing that..
>
> Cheers
>
> Joe
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael M. - ITSD
> Sent: Wednesday, January 09, 2008 4:11 PM
> To: [email protected]
> Subject: ARS 7.x: No unique index on Group ID?
>
>
> **
> I did an application export/import from development to production and it
> replicated our existing Group IDs. Why is there no unique index on Group
> ID? I can't fathom a situation where I would want differently named
> groups
> with the same ID. Am I totally off-base on this or ???
>
> Thanks,
>
> Michael
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.0/1216 - Release Date: 1/9/2008
> 10:16 AM
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"