Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.

Duplicate User Notification

From: ggutierrez (2011-09-19 12:44)

It is personid.

Thank You,

George Gutierrez Jr.
Maximo Administration
Pasadena Refining Systems
713.920.3908 Direct
832.473.5330 Cell
U1O2 - Chave

"Victor"
<vikas17.j@gmail.com
> To
Sent by: MAXIMO@yahoogroups.com
MAXIMO@yahoogroups.c cc
om
Subject
[MAXIMO List] Re: Duplicate User
09/19/2011 12:38 PM Notification

Please respond to
MAXIMO@yahoogroups.c
om

Hi Mrggutz,

what is the criteria for your requirement to flag when a user is
duplicate ?

Is it display name or userid or personid ?

Thanks,
Victor.

--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> Has anyone ever tried to create an escalation to send notification of
duplicate users?
> I'm trying to get a handle on all this and have very little knowledge of
escalations and how to create new ones.
> I have a screen shot of what I got but I don't know where to put it and
don't want to get in trouble for posting it within the message.
>
> I'm using Maximo 6.2.1.
>
> Thanks in advance,
> mrggutz
>

From: Victor (2011-09-19 18:36)

Hi George,
Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
Thanks,
Victor.
--- In MAXIMO@yahoogroups.com, ggutierrez@... wrote:
>
> It is personid.
>
>
>
> Thank You,
>
> George Gutierrez Jr.
> Maximo Administration
> Pasadena Refining Systems
> 713.920.3908 Direct
> 832.473.5330 Cell
> U1O2 - Chave
>
>
>
> "Victor"
> <vikas17.j@...
> > To
> Sent by: MAXIMO@yahoogroups.com
> MAXIMO@... cc
> om
> Subject
> [MAXIMO List] Re: Duplicate User
> 09/19/2011 12:38 PM Notification
>
>
> Please respond to
> MAXIMO@...
> om
>
>
>
>
>
>
>
>
>
> Hi Mrggutz,
>
> what is the criteria for your requirement to flag when a user is
> duplicate ?
>
> Is it display name or userid or personid ?
>
> Thanks,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >
> > Has anyone ever tried to create an escalation to send notification of
> duplicate users?
> > I'm trying to get a handle on all this and have very little knowledge of
> escalations and how to create new ones.
> > I have a screen shot of what I got but I don't know where to put it and
> don't want to get in trouble for posting it within the message.
> >
> > I'm using Maximo 6.2.1.
> >
> > Thanks in advance,
> > mrggutz
> >
>

From: Victor (2011-09-19 18:48)

Hi George,
Steps to create the escalation :
1.Object : MAXUSER
2.Condition : EXISTS (SELECT personid FROM PERSON where person.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1))
3.Set up escalation points accordingly.
4.Add a communication template created for the user notification.
OR
1. OBJECT : PERSON
2. EXISTS (SELECT personid FROM PERSON where person.personid=person.personid group by personid HAVING (COUNT(PERSONID) > 1))
3.Set up escalation points accordingly.
4.Add a communication template created for the user notification.
Thanks,
Victor.
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hi George,
>
> Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
>
> Thanks,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> >
> > It is personid.
> >
> >
> >
> > Thank You,
> >
> > George Gutierrez Jr.
> > Maximo Administration
> > Pasadena Refining Systems
> > 713.920.3908 Direct
> > 832.473.5330 Cell
> > U1O2 - Chave
> >
> >
> >
> > "Victor"
> > <vikas17.j@
> > > To
> > Sent by: MAXIMO@yahoogroups.com
> > MAXIMO@ cc
> > om
> > Subject
> > [MAXIMO List] Re: Duplicate User
> > 09/19/2011 12:38 PM Notification
> >
> >
> > Please respond to
> > MAXIMO@
> > om
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Hi Mrggutz,
> >
> > what is the criteria for your requirement to flag when a user is
> > duplicate ?
> >
> > Is it display name or userid or personid ?
> >
> > Thanks,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > >
> > > Has anyone ever tried to create an escalation to send notification of
> > duplicate users?
> > > I'm trying to get a handle on all this and have very little knowledge of
> > escalations and how to create new ones.
> > > I have a screen shot of what I got but I don't know where to put it and
> > don't want to get in trouble for posting it within the message.
> > >
> > > I'm using Maximo 6.2.1.
> > >
> > > Thanks in advance,
> > > mrggutz
> > >
> >
>

From: George (2011-09-19 18:50)

which one is better to use for this?
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hi George,
>
> Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
>
> Thanks,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> >
> > It is personid.
> >
> >
> >
> > Thank You,
> >
> > George Gutierrez Jr.
> > Maximo Administration
> > Pasadena Refining Systems
> > 713.920.3908 Direct
> > 832.473.5330 Cell
> > U1O2 - Chave
> >
> >
> >
> > "Victor"
> > <vikas17.j@
> > > To
> > Sent by: MAXIMO@yahoogroups.com
> > MAXIMO@ cc
> > om
> > Subject
> > [MAXIMO List] Re: Duplicate User
> > 09/19/2011 12:38 PM Notification
> >
> >
> > Please respond to
> > MAXIMO@
> > om
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Hi Mrggutz,
> >
> > what is the criteria for your requirement to flag when a user is
> > duplicate ?
> >
> > Is it display name or userid or personid ?
> >
> > Thanks,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > >
> > > Has anyone ever tried to create an escalation to send notification of
> > duplicate users?
> > > I'm trying to get a handle on all this and have very little knowledge of
> > escalations and how to create new ones.
> > > I have a screen shot of what I got but I don't know where to put it and
> > don't want to get in trouble for posting it within the message.
> > >
> > > I'm using Maximo 6.2.1.
> > >
> > > Thanks in advance,
> > > mrggutz
> > >
> >
>

From: George (2011-09-19 18:53)

Thank you Victor I will try it out and let you know the outcome.
--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> which one is better to use for this?
>
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >
> > Hi George,
> >
> > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> >
> > Thanks,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > >
> > > It is personid.
> > >
> > >
> > >
> > > Thank You,
> > >
> > > George Gutierrez Jr.
> > > Maximo Administration
> > > Pasadena Refining Systems
> > > 713.920.3908 Direct
> > > 832.473.5330 Cell
> > > U1O2 - Chave
> > >
> > >
> > >
> > > "Victor"
> > > <vikas17.j@
> > > > To
> > > Sent by: MAXIMO@yahoogroups.com
> > > MAXIMO@ cc
> > > om
> > > Subject
> > > [MAXIMO List] Re: Duplicate User
> > > 09/19/2011 12:38 PM Notification
> > >
> > >
> > > Please respond to
> > > MAXIMO@
> > > om
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hi Mrggutz,
> > >
> > > what is the criteria for your requirement to flag when a user is
> > > duplicate ?
> > >
> > > Is it display name or userid or personid ?
> > >
> > > Thanks,
> > > Victor.
> > >
> > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > >
> > > > Has anyone ever tried to create an escalation to send notification of
> > > duplicate users?
> > > > I'm trying to get a handle on all this and have very little knowledge of
> > > escalations and how to create new ones.
> > > > I have a screen shot of what I got but I don't know where to put it and
> > > don't want to get in trouble for posting it within the message.
> > > >
> > > > I'm using Maximo 6.2.1.
> > > >
> > > > Thanks in advance,
> > > > mrggutz
> > > >
> > >
> >
>

From: Victor (2011-09-19 18:55)

Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
If you have the requirement to get the duplicate users then the condition will change as follows :
1.object: MAXUSER
2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
If your requirement is looking for duplicate person records then any of the previous solution options will work.
Thanks,
Victor.
--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> which one is better to use for this?
>
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >
> > Hi George,
> >
> > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> >
> > Thanks,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > >
> > > It is personid.
> > >
> > >
> > >
> > > Thank You,
> > >
> > > George Gutierrez Jr.
> > > Maximo Administration
> > > Pasadena Refining Systems
> > > 713.920.3908 Direct
> > > 832.473.5330 Cell
> > > U1O2 - Chave
> > >
> > >
> > >
> > > "Victor"
> > > <vikas17.j@
> > > > To
> > > Sent by: MAXIMO@yahoogroups.com
> > > MAXIMO@ cc
> > > om
> > > Subject
> > > [MAXIMO List] Re: Duplicate User
> > > 09/19/2011 12:38 PM Notification
> > >
> > >
> > > Please respond to
> > > MAXIMO@
> > > om
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hi Mrggutz,
> > >
> > > what is the criteria for your requirement to flag when a user is
> > > duplicate ?
> > >
> > > Is it display name or userid or personid ?
> > >
> > > Thanks,
> > > Victor.
> > >
> > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > >
> > > > Has anyone ever tried to create an escalation to send notification of
> > > duplicate users?
> > > > I'm trying to get a handle on all this and have very little knowledge of
> > > escalations and how to create new ones.
> > > > I have a screen shot of what I got but I don't know where to put it and
> > > don't want to get in trouble for posting it within the message.
> > > >
> > > > I'm using Maximo 6.2.1.
> > > >
> > > > Thanks in advance,
> > > > mrggutz
> > > >
> > >
> >
>

From: George (2011-09-19 19:00)

I want to check for duplicate users. I created the escalation and it validated successfully so hope fully I will get a notification of a duplicate when it happens.
thanks again Victor.
mrggutz
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
>
> If you have the requirement to get the duplicate users then the condition will change as follows :
> 1.object: MAXUSER
> 2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
>
> If your requirement is looking for duplicate person records then any of the previous solution options will work.
>
>
> Thanks,
> Victor.
>
>
> --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >
> > which one is better to use for this?
> >
> >
> > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > >
> > > Hi George,
> > >
> > > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> > >
> > > Thanks,
> > > Victor.
> > >
> > > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > > >
> > > > It is personid.
> > > >
> > > >
> > > >
> > > > Thank You,
> > > >
> > > > George Gutierrez Jr.
> > > > Maximo Administration
> > > > Pasadena Refining Systems
> > > > 713.920.3908 Direct
> > > > 832.473.5330 Cell
> > > > U1O2 - Chave
> > > >
> > > >
> > > >
> > > > "Victor"
> > > > <vikas17.j@
> > > > > To
> > > > Sent by: MAXIMO@yahoogroups.com
> > > > MAXIMO@ cc
> > > > om
> > > > Subject
> > > > [MAXIMO List] Re: Duplicate User
> > > > 09/19/2011 12:38 PM Notification
> > > >
> > > >
> > > > Please respond to
> > > > MAXIMO@
> > > > om
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Hi Mrggutz,
> > > >
> > > > what is the criteria for your requirement to flag when a user is
> > > > duplicate ?
> > > >
> > > > Is it display name or userid or personid ?
> > > >
> > > > Thanks,
> > > > Victor.
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > >
> > > > > Has anyone ever tried to create an escalation to send notification of
> > > > duplicate users?
> > > > > I'm trying to get a handle on all this and have very little knowledge of
> > > > escalations and how to create new ones.
> > > > > I have a screen shot of what I got but I don't know where to put it and
> > > > don't want to get in trouble for posting it within the message.
> > > > >
> > > > > I'm using Maximo 6.2.1.
> > > > >
> > > > > Thanks in advance,
> > > > > mrggutz
> > > > >
> > > >
> > >
> >
>

From: Victor (2011-09-19 19:11)

Thank me once you get the notification :) , but if there are no records in database as duplicate then there will be no notification. Did you run the query on database.
By the way, You're very welcome.
Thanks,
Victor.
--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> I want to check for duplicate users. I created the escalation and it validated successfully so hope fully I will get a notification of a duplicate when it happens.
> thanks again Victor.
>
> mrggutz
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >
> > Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
> >
> > If you have the requirement to get the duplicate users then the condition will change as follows :
> > 1.object: MAXUSER
> > 2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
> >
> > If your requirement is looking for duplicate person records then any of the previous solution options will work.
> >
> >
> > Thanks,
> > Victor.
> >
> >
> > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > >
> > > which one is better to use for this?
> > >
> > >
> > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > >
> > > > Hi George,
> > > >
> > > > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> > > >
> > > > Thanks,
> > > > Victor.
> > > >
> > > > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > > > >
> > > > > It is personid.
> > > > >
> > > > >
> > > > >
> > > > > Thank You,
> > > > >
> > > > > George Gutierrez Jr.
> > > > > Maximo Administration
> > > > > Pasadena Refining Systems
> > > > > 713.920.3908 Direct
> > > > > 832.473.5330 Cell
> > > > > U1O2 - Chave
> > > > >
> > > > >
> > > > >
> > > > > "Victor"
> > > > > <vikas17.j@
> > > > > > To
> > > > > Sent by: MAXIMO@yahoogroups.com
> > > > > MAXIMO@ cc
> > > > > om
> > > > > Subject
> > > > > [MAXIMO List] Re: Duplicate User
> > > > > 09/19/2011 12:38 PM Notification
> > > > >
> > > > >
> > > > > Please respond to
> > > > > MAXIMO@
> > > > > om
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Hi Mrggutz,
> > > > >
> > > > > what is the criteria for your requirement to flag when a user is
> > > > > duplicate ?
> > > > >
> > > > > Is it display name or userid or personid ?
> > > > >
> > > > > Thanks,
> > > > > Victor.
> > > > >
> > > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > > >
> > > > > > Has anyone ever tried to create an escalation to send notification of
> > > > > duplicate users?
> > > > > > I'm trying to get a handle on all this and have very little knowledge of
> > > > > escalations and how to create new ones.
> > > > > > I have a screen shot of what I got but I don't know where to put it and
> > > > > don't want to get in trouble for posting it within the message.
> > > > > >
> > > > > > I'm using Maximo 6.2.1.
> > > > > >
> > > > > > Thanks in advance,
> > > > > > mrggutz
> > > > > >
> > > > >
> > > >
> > >
> >
>

From: George (2011-09-19 19:19)

tried this in sql and got this
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'EXISTS'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ')'.
hmm did I do something wrong?
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
>
> If you have the requirement to get the duplicate users then the condition will change as follows :
> 1.object: MAXUSER
> 2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
>
> If your requirement is looking for duplicate person records then any of the previous solution options will work.
>
>
> Thanks,
> Victor.
>
>
> --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >
> > which one is better to use for this?
> >
> >
> > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > >
> > > Hi George,
> > >
> > > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> > >
> > > Thanks,
> > > Victor.
> > >
> > > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > > >
> > > > It is personid.
> > > >
> > > >
> > > >
> > > > Thank You,
> > > >
> > > > George Gutierrez Jr.
> > > > Maximo Administration
> > > > Pasadena Refining Systems
> > > > 713.920.3908 Direct
> > > > 832.473.5330 Cell
> > > > U1O2 - Chave
> > > >
> > > >
> > > >
> > > > "Victor"
> > > > <vikas17.j@
> > > > > To
> > > > Sent by: MAXIMO@yahoogroups.com
> > > > MAXIMO@ cc
> > > > om
> > > > Subject
> > > > [MAXIMO List] Re: Duplicate User
> > > > 09/19/2011 12:38 PM Notification
> > > >
> > > >
> > > > Please respond to
> > > > MAXIMO@
> > > > om
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Hi Mrggutz,
> > > >
> > > > what is the criteria for your requirement to flag when a user is
> > > > duplicate ?
> > > >
> > > > Is it display name or userid or personid ?
> > > >
> > > > Thanks,
> > > > Victor.
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > >
> > > > > Has anyone ever tried to create an escalation to send notification of
> > > > duplicate users?
> > > > > I'm trying to get a handle on all this and have very little knowledge of
> > > > escalations and how to create new ones.
> > > > > I have a screen shot of what I got but I don't know where to put it and
> > > > don't want to get in trouble for posting it within the message.
> > > > >
> > > > > I'm using Maximo 6.2.1.
> > > > >
> > > > > Thanks in advance,
> > > > > mrggutz
> > > > >
> > > >
> > >
> >
>

From: Victor (2011-09-19 19:38)

Can you paste the sql you tried ?
--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> tried this in sql and got this
>
> Msg 156, Level 15, State 1, Line 1
> Incorrect syntax near the keyword 'EXISTS'.
> Msg 102, Level 15, State 1, Line 1
> Incorrect syntax near ')'.
>
> hmm did I do something wrong?
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >
> > Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
> >
> > If you have the requirement to get the duplicate users then the condition will change as follows :
> > 1.object: MAXUSER
> > 2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
> >
> > If your requirement is looking for duplicate person records then any of the previous solution options will work.
> >
> >
> > Thanks,
> > Victor.
> >
> >
> > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > >
> > > which one is better to use for this?
> > >
> > >
> > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > >
> > > > Hi George,
> > > >
> > > > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> > > >
> > > > Thanks,
> > > > Victor.
> > > >
> > > > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > > > >
> > > > > It is personid.
> > > > >
> > > > >
> > > > >
> > > > > Thank You,
> > > > >
> > > > > George Gutierrez Jr.
> > > > > Maximo Administration
> > > > > Pasadena Refining Systems
> > > > > 713.920.3908 Direct
> > > > > 832.473.5330 Cell
> > > > > U1O2 - Chave
> > > > >
> > > > >
> > > > >
> > > > > "Victor"
> > > > > <vikas17.j@
> > > > > > To
> > > > > Sent by: MAXIMO@yahoogroups.com
> > > > > MAXIMO@ cc
> > > > > om
> > > > > Subject
> > > > > [MAXIMO List] Re: Duplicate User
> > > > > 09/19/2011 12:38 PM Notification
> > > > >
> > > > >
> > > > > Please respond to
> > > > > MAXIMO@
> > > > > om
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Hi Mrggutz,
> > > > >
> > > > > what is the criteria for your requirement to flag when a user is
> > > > > duplicate ?
> > > > >
> > > > > Is it display name or userid or personid ?
> > > > >
> > > > > Thanks,
> > > > > Victor.
> > > > >
> > > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > > >
> > > > > > Has anyone ever tried to create an escalation to send notification of
> > > > > duplicate users?
> > > > > > I'm trying to get a handle on all this and have very little knowledge of
> > > > > escalations and how to create new ones.
> > > > > > I have a screen shot of what I got but I don't know where to put it and
> > > > > don't want to get in trouble for posting it within the message.
> > > > > >
> > > > > > I'm using Maximo 6.2.1.
> > > > > >
> > > > > > Thanks in advance,
> > > > > > mrggutz
> > > > > >
> > > > >
> > > >
> > >
> >
>

From: George (2011-09-19 19:42)

EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1))
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Can you paste the sql you tried ?
>
> --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >
> > tried this in sql and got this
> >
> > Msg 156, Level 15, State 1, Line 1
> > Incorrect syntax near the keyword 'EXISTS'.
> > Msg 102, Level 15, State 1, Line 1
> > Incorrect syntax near ')'.
> >
> > hmm did I do something wrong?
> >
> > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > >
> > > Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
> > >
> > > If you have the requirement to get the duplicate users then the condition will change as follows :
> > > 1.object: MAXUSER
> > > 2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
> > >
> > > If your requirement is looking for duplicate person records then any of the previous solution options will work.
> > >
> > >
> > > Thanks,
> > > Victor.
> > >
> > >
> > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > >
> > > > which one is better to use for this?
> > > >
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > > >
> > > > > Hi George,
> > > > >
> > > > > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> > > > >
> > > > > Thanks,
> > > > > Victor.
> > > > >
> > > > > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > > > > >
> > > > > > It is personid.
> > > > > >
> > > > > >
> > > > > >
> > > > > > Thank You,
> > > > > >
> > > > > > George Gutierrez Jr.
> > > > > > Maximo Administration
> > > > > > Pasadena Refining Systems
> > > > > > 713.920.3908 Direct
> > > > > > 832.473.5330 Cell
> > > > > > U1O2 - Chave
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Victor"
> > > > > > <vikas17.j@
> > > > > > > To
> > > > > > Sent by: MAXIMO@yahoogroups.com
> > > > > > MAXIMO@ cc
> > > > > > om
> > > > > > Subject
> > > > > > [MAXIMO List] Re: Duplicate User
> > > > > > 09/19/2011 12:38 PM Notification
> > > > > >
> > > > > >
> > > > > > Please respond to
> > > > > > MAXIMO@
> > > > > > om
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Hi Mrggutz,
> > > > > >
> > > > > > what is the criteria for your requirement to flag when a user is
> > > > > > duplicate ?
> > > > > >
> > > > > > Is it display name or userid or personid ?
> > > > > >
> > > > > > Thanks,
> > > > > > Victor.
> > > > > >
> > > > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > > > >
> > > > > > > Has anyone ever tried to create an escalation to send notification of
> > > > > > duplicate users?
> > > > > > > I'm trying to get a handle on all this and have very little knowledge of
> > > > > > escalations and how to create new ones.
> > > > > > > I have a screen shot of what I got but I don't know where to put it and
> > > > > > don't want to get in trouble for posting it within the message.
> > > > > > >
> > > > > > > I'm using Maximo 6.2.1.
> > > > > > >
> > > > > > > Thanks in advance,
> > > > > > > mrggutz
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

From: Victor (2011-09-19 19:46)

Hi George,
When you are running in SQL developer kind of tools you have add Select statement in front of any escalation condition, as Maximo adds this on its on , hence we only add the where clause condition in any maximo where clause or conditional expressions.
Run this :
Select * from maxuser where
EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1))
or
Select * from person where
EXISTS (SELECT personid FROM person
where person.personid=person.personid group by personid HAVING (COUNT(PERSONID) > 1))
Thanks,
Victor.
--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1))
>
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >
> > Can you paste the sql you tried ?
> >
> > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > >
> > > tried this in sql and got this
> > >
> > > Msg 156, Level 15, State 1, Line 1
> > > Incorrect syntax near the keyword 'EXISTS'.
> > > Msg 102, Level 15, State 1, Line 1
> > > Incorrect syntax near ')'.
> > >
> > > hmm did I do something wrong?
> > >
> > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > >
> > > > Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
> > > >
> > > > If you have the requirement to get the duplicate users then the condition will change as follows :
> > > > 1.object: MAXUSER
> > > > 2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
> > > >
> > > > If your requirement is looking for duplicate person records then any of the previous solution options will work.
> > > >
> > > >
> > > > Thanks,
> > > > Victor.
> > > >
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > >
> > > > > which one is better to use for this?
> > > > >
> > > > >
> > > > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > > > >
> > > > > > Hi George,
> > > > > >
> > > > > > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> > > > > >
> > > > > > Thanks,
> > > > > > Victor.
> > > > > >
> > > > > > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > > > > > >
> > > > > > > It is personid.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Thank You,
> > > > > > >
> > > > > > > George Gutierrez Jr.
> > > > > > > Maximo Administration
> > > > > > > Pasadena Refining Systems
> > > > > > > 713.920.3908 Direct
> > > > > > > 832.473.5330 Cell
> > > > > > > U1O2 - Chave
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Victor"
> > > > > > > <vikas17.j@
> > > > > > > > To
> > > > > > > Sent by: MAXIMO@yahoogroups.com
> > > > > > > MAXIMO@ cc
> > > > > > > om
> > > > > > > Subject
> > > > > > > [MAXIMO List] Re: Duplicate User
> > > > > > > 09/19/2011 12:38 PM Notification
> > > > > > >
> > > > > > >
> > > > > > > Please respond to
> > > > > > > MAXIMO@
> > > > > > > om
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Hi Mrggutz,
> > > > > > >
> > > > > > > what is the criteria for your requirement to flag when a user is
> > > > > > > duplicate ?
> > > > > > >
> > > > > > > Is it display name or userid or personid ?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Victor.
> > > > > > >
> > > > > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > > > > >
> > > > > > > > Has anyone ever tried to create an escalation to send notification of
> > > > > > > duplicate users?
> > > > > > > > I'm trying to get a handle on all this and have very little knowledge of
> > > > > > > escalations and how to create new ones.
> > > > > > > > I have a screen shot of what I got but I don't know where to put it and
> > > > > > > don't want to get in trouble for posting it within the message.
> > > > > > > >
> > > > > > > > I'm using Maximo 6.2.1.
> > > > > > > >
> > > > > > > > Thanks in advance,
> > > > > > > > mrggutz
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

From: George (2011-09-19 19:50)

Once I added that to the front of it, it worked in sql manager.
thanks again.
I'm still learning and hopefully one day I can help someone out.
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hi George,
>
> When you are running in SQL developer kind of tools you have add Select statement in front of any escalation condition, as Maximo adds this on its on , hence we only add the where clause condition in any maximo where clause or conditional expressions.
>
> Run this :
>
> Select * from maxuser where
> EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1))
>
> or
>
> Select * from person where
> EXISTS (SELECT personid FROM person
> where person.personid=person.personid group by personid HAVING (COUNT(PERSONID) > 1))
>
> Thanks,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >
> > EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1))
> >
> >
> > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > >
> > > Can you paste the sql you tried ?
> > >
> > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > >
> > > > tried this in sql and got this
> > > >
> > > > Msg 156, Level 15, State 1, Line 1
> > > > Incorrect syntax near the keyword 'EXISTS'.
> > > > Msg 102, Level 15, State 1, Line 1
> > > > Incorrect syntax near ')'.
> > > >
> > > > hmm did I do something wrong?
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > > >
> > > > > Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
> > > > >
> > > > > If you have the requirement to get the duplicate users then the condition will change as follows :
> > > > > 1.object: MAXUSER
> > > > > 2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
> > > > >
> > > > > If your requirement is looking for duplicate person records then any of the previous solution options will work.
> > > > >
> > > > >
> > > > > Thanks,
> > > > > Victor.
> > > > >
> > > > >
> > > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > > >
> > > > > > which one is better to use for this?
> > > > > >
> > > > > >
> > > > > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > > > > >
> > > > > > > Hi George,
> > > > > > >
> > > > > > > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Victor.
> > > > > > >
> > > > > > > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > > > > > > >
> > > > > > > > It is personid.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Thank You,
> > > > > > > >
> > > > > > > > George Gutierrez Jr.
> > > > > > > > Maximo Administration
> > > > > > > > Pasadena Refining Systems
> > > > > > > > 713.920.3908 Direct
> > > > > > > > 832.473.5330 Cell
> > > > > > > > U1O2 - Chave
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "Victor"
> > > > > > > > <vikas17.j@
> > > > > > > > > To
> > > > > > > > Sent by: MAXIMO@yahoogroups.com
> > > > > > > > MAXIMO@ cc
> > > > > > > > om
> > > > > > > > Subject
> > > > > > > > [MAXIMO List] Re: Duplicate User
> > > > > > > > 09/19/2011 12:38 PM Notification
> > > > > > > >
> > > > > > > >
> > > > > > > > Please respond to
> > > > > > > > MAXIMO@
> > > > > > > > om
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Hi Mrggutz,
> > > > > > > >
> > > > > > > > what is the criteria for your requirement to flag when a user is
> > > > > > > > duplicate ?
> > > > > > > >
> > > > > > > > Is it display name or userid or personid ?
> > > > > > > >
> > > > > > > > Thanks,
> > > > > > > > Victor.
> > > > > > > >
> > > > > > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > > > > > >
> > > > > > > > > Has anyone ever tried to create an escalation to send notification of
> > > > > > > > duplicate users?
> > > > > > > > > I'm trying to get a handle on all this and have very little knowledge of
> > > > > > > > escalations and how to create new ones.
> > > > > > > > > I have a screen shot of what I got but I don't know where to put it and
> > > > > > > > don't want to get in trouble for posting it within the message.
> > > > > > > > >
> > > > > > > > > I'm using Maximo 6.2.1.
> > > > > > > > >
> > > > > > > > > Thanks in advance,
> > > > > > > > > mrggutz
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

From: Victor (2011-09-19 19:57)

That day is gonna come soon dude, if we won't fail, we won't learn.
Failure is the stepping stone to success :)
--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> Once I added that to the front of it, it worked in sql manager.
> thanks again.
> I'm still learning and hopefully one day I can help someone out.
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >
> > Hi George,
> >
> > When you are running in SQL developer kind of tools you have add Select statement in front of any escalation condition, as Maximo adds this on its on , hence we only add the where clause condition in any maximo where clause or conditional expressions.
> >
> > Run this :
> >
> > Select * from maxuser where
> > EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1))
> >
> > or
> >
> > Select * from person where
> > EXISTS (SELECT personid FROM person
> > where person.personid=person.personid group by personid HAVING (COUNT(PERSONID) > 1))
> >
> > Thanks,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > >
> > > EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1))
> > >
> > >
> > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > >
> > > > Can you paste the sql you tried ?
> > > >
> > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > >
> > > > > tried this in sql and got this
> > > > >
> > > > > Msg 156, Level 15, State 1, Line 1
> > > > > Incorrect syntax near the keyword 'EXISTS'.
> > > > > Msg 102, Level 15, State 1, Line 1
> > > > > Incorrect syntax near ')'.
> > > > >
> > > > > hmm did I do something wrong?
> > > > >
> > > > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > > > >
> > > > > > Depends on your requirement, whether you are checking the duplicate user or duplicate person records ?
> > > > > >
> > > > > > If you have the requirement to get the duplicate users then the condition will change as follows :
> > > > > > 1.object: MAXUSER
> > > > > > 2.CONDITION : EXISTS (SELECT personid FROM MAXUSER where MAXUSER.personid=maxuser.personid group by personid HAVING (COUNT(PERSONID) > 1) )
> > > > > >
> > > > > > If your requirement is looking for duplicate person records then any of the previous solution options will work.
> > > > > >
> > > > > >
> > > > > > Thanks,
> > > > > > Victor.
> > > > > >
> > > > > >
> > > > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > > > >
> > > > > > > which one is better to use for this?
> > > > > > >
> > > > > > >
> > > > > > > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> > > > > > > >
> > > > > > > > Hi George,
> > > > > > > >
> > > > > > > > Also, I would like to know, whether you are checking the maxuser table or person table for the duplicacy.
> > > > > > > >
> > > > > > > > Thanks,
> > > > > > > > Victor.
> > > > > > > >
> > > > > > > > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > > > > > > > >
> > > > > > > > > It is personid.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Thank You,
> > > > > > > > >
> > > > > > > > > George Gutierrez Jr.
> > > > > > > > > Maximo Administration
> > > > > > > > > Pasadena Refining Systems
> > > > > > > > > 713.920.3908 Direct
> > > > > > > > > 832.473.5330 Cell
> > > > > > > > > U1O2 - Chave
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Victor"
> > > > > > > > > <vikas17.j@
> > > > > > > > > > To
> > > > > > > > > Sent by: MAXIMO@yahoogroups.com
> > > > > > > > > MAXIMO@ cc
> > > > > > > > > om
> > > > > > > > > Subject
> > > > > > > > > [MAXIMO List] Re: Duplicate User
> > > > > > > > > 09/19/2011 12:38 PM Notification
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Please respond to
> > > > > > > > > MAXIMO@
> > > > > > > > > om
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Hi Mrggutz,
> > > > > > > > >
> > > > > > > > > what is the criteria for your requirement to flag when a user is
> > > > > > > > > duplicate ?
> > > > > > > > >
> > > > > > > > > Is it display name or userid or personid ?
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > > Victor.
> > > > > > > > >
> > > > > > > > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > > > > > > > >
> > > > > > > > > > Has anyone ever tried to create an escalation to send notification of
> > > > > > > > > duplicate users?
> > > > > > > > > > I'm trying to get a handle on all this and have very little knowledge of
> > > > > > > > > escalations and how to create new ones.
> > > > > > > > > > I have a screen shot of what I got but I don't know where to put it and
> > > > > > > > > don't want to get in trouble for posting it within the message.
> > > > > > > > > >
> > > > > > > > > > I'm using Maximo 6.2.1.
> > > > > > > > > >
> > > > > > > > > > Thanks in advance,
> > > > > > > > > > mrggutz
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>