Adm:Timing Test please ignore

2009-12-30 Thread Daniel Bloom
8:12am EST

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Service

2009-12-30 Thread Mark Lev
Does anyone know where in BMC Remedy 7.5 documentation it is discussed how to 
create/manage services.

The field I am referring to is on the Incident form, Service*+.

I understand services are CI's and need to be related, and I am able to create 
these and get them to work, but I would like to better understand how and why 
they work.  I cannot seem to locate any documentation on this topic.

Thanks,
Mark


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: ARDBC LDAP Active Directory question

2009-12-30 Thread Kevin Begosh
Fred,
How do you add the OU to the vendor form query string, I added mine and I am
getting an error?  ARS 7.5, ITMS 7.5, Windows 2003

Kevin

On Tue, Dec 29, 2009 at 4:51 PM, Drew Shuller d...@io.com wrote:

 Norm! Thanks for the help. Thanks again Fred.

 I tried it out in a form, it looks like it's going to work.

 Drew


 On Tue, Dec 29, 2009 at 3:44 PM, Drew Shuller drew.shul...@gmail.com
 wrote:
  Norm! Thanks for the help. Thanks again Fred.
 
  I tried it out in a form, it looks like it's going to work.
 
  Drew
 
  On Tue, Dec 29, 2009 at 2:53 PM, Grooms, Frederick W
  frederick.w.gro...@xo.com wrote:
  I learned not to use sAMAccountName as Request ID.  I use uSNCreated
 (which *SHOULD BE* unique and less than 15 characters).  Just use
 sAMAccountName as a regular field from the ActiveDirectory.
 
  Fred
 
  -Original Message-
  From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Drew Shuller
  Sent: Tuesday, December 29, 2009 2:35 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: ARDBC LDAP Active Directory question
 
  Thank you Fred, that's very helpful. After some googling I was able to
  generate a query using the MMC console, which was helpful in that I
  got to see a lot of columns of data all in one place.
 
  Thanks for the query string. My guy wanted to see what Remedy was
  generating...no one can see that in Remedy itself but it looks like
  one can figure it out and build it because an LDAP/AD query is an
  LDAP/AD query, so to speak.
 
  My only other problem (AD-wise that is) is the mismatch between the
  samAccountName attribute length and the 6.3 RequestID field length,
  which causes blank entries in the vendor form. Oddly enough I can see
  the name in the Results list but not in the fields of the form itself.
  I suggested that we truncate the samAccountName field to 15 characters
  and put the result in an unused AD attribute and then use that for the
  Request ID map. Any suggestions on that? Has this been handled in the
  Remedy versions released after the stone age? Not that I'm knocking
  6.3, I kinda like it, it gives me a nice warm fuzzy. :-)
 
  Drew
  Soto Cano
 
  On Tue, Dec 29, 2009 at 1:39 PM, Grooms, Frederick W wrote:
  ldap://host[:port]/User Base??sub?(User Filter)
 
  As long as you have sub in there it should look at your user base and
 all sublevels (the other option I know of is one).
 
  In your Vendor Form definition you set the User Base to be the top
 level of your organization where you want to start searching. In my case I
 have it set to the root of the tree.
 
  If you turn on the plugin log to the highest level you can see the
 queries generated.  Basically all the system is doing is to append to the
 ldap string the rest of your search parameters.  i.e.  If I put grooms in
 the sAMAccountName field on my LDAP vendor form the query generated is:
 
  
 ldap://DNS_SERVER/DC=AAA,DC=,DC=NET??sub?((objectclass=user)(sAMAccountName=*grooms*))
  In my case the record is in the sublevel:  OU=User
 Accounts,DC=AAA,DC=,DC=net
 
  As for tools, the 2 most common (Free ones) I know of are:
   Microsoft's LDP utility
 http://technet.microsoft.com/en-us/library/cc772839(WS.10).aspx
   Softerra LDAP Browser  http://www.softerra.com/download.htm
 
 
  Fred
 
  -Original Message-
  From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Drew Shuller
  Sent: Tuesday, December 29, 2009 11:13 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: ARDBC LDAP Active Directory question
 
  Thanks Fred.
 
  So I could substitute another value in the ldap string and get further
  down in the tree? But not in the same form?
 
  My server guys instists that there's a query that Remedy is using to
  return the information in the Vendor form, but we can't see that
  query. Or can we? If anyone knows, please clue me in.
 
  I can create a vendor form and add every single field available, but
  only a few of them can be added to the results field list and the
  normal way of exporting records to an excel file doesn't work. How do
  I build queries into the AD, and what tools should I use?
 
  Drew
 
  On Mon, Dec 28, 2009 at 4:35 PM, Grooms, Frederick W wrote:
  Check the Form Properties - Vendor Information tab for your form. The
 Table Name field needs to have the sub value in it to allow searches to go
 beyond the currently defined level.
 
  ldap://DNS_SERVER/DC=AAA,DC=,DC=NET??sub?(objectclass=user)
 
  The objectclass=user just restricts the results to values with user in
 the objectclass field, not what levels to search.
 
  Fred
 
 
  -Original Message-
  From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Drew Shuller
  Sent: Monday, December 28, 2009 3:59 PM
  To: arslist@ARSLIST.ORG
  Subject: ARDBC LDAP Active Directory question
 
  Hello list, I've got an AD question.
 
  We search our user info using the ARDBC LDAP 

Re: ARDBC LDAP Active Directory question

2009-12-30 Thread Grooms, Frederick W
It should go something like this (in this case I am looking at an OU of: User 
Accounts):

ldap://host/OU=User 
Accounts,DC=www,DC=mycompany,DC=net??sub?(objectclass=user)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh
Sent: Wednesday, December 30, 2009 8:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARDBC LDAP Active Directory question

** 
Fred,
How do you add the OU to the vendor form query string, I added mine and I am 
getting an error?  ARS 7.5, ITMS 7.5, Windows 2003
 
Kevin
On Tue, Dec 29, 2009 at 4:51 PM, Drew Shuller d...@io.com wrote:
Norm! Thanks for the help. Thanks again Fred.

I tried it out in a form, it looks like it's going to work.

Drew


On Tue, Dec 29, 2009 at 3:44 PM, Drew Shuller wrote:
 Norm! Thanks for the help. Thanks again Fred.

 I tried it out in a form, it looks like it's going to work.

 Drew

 On Tue, Dec 29, 2009 at 2:53 PM, Grooms, Frederick W wrote:
 I learned not to use sAMAccountName as Request ID.  I use uSNCreated (which 
 *SHOULD BE* unique and less than 15 characters).  Just use sAMAccountName as 
 a regular field from the ActiveDirectory.

 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller
 Sent: Tuesday, December 29, 2009 2:35 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARDBC LDAP Active Directory question

 Thank you Fred, that's very helpful. After some googling I was able to
 generate a query using the MMC console, which was helpful in that I
 got to see a lot of columns of data all in one place.

 Thanks for the query string. My guy wanted to see what Remedy was
 generating...no one can see that in Remedy itself but it looks like
 one can figure it out and build it because an LDAP/AD query is an
 LDAP/AD query, so to speak.

 My only other problem (AD-wise that is) is the mismatch between the
 samAccountName attribute length and the 6.3 RequestID field length,
 which causes blank entries in the vendor form. Oddly enough I can see
 the name in the Results list but not in the fields of the form itself.
 I suggested that we truncate the samAccountName field to 15 characters
 and put the result in an unused AD attribute and then use that for the
 Request ID map. Any suggestions on that? Has this been handled in the
 Remedy versions released after the stone age? Not that I'm knocking
 6.3, I kinda like it, it gives me a nice warm fuzzy. :-)

 Drew
 Soto Cano

 On Tue, Dec 29, 2009 at 1:39 PM, Grooms, Frederick W wrote:
 ldap://host[:port]/User Base??sub?(User Filter)

 As long as you have sub in there it should look at your user base and all 
 sublevels (the other option I know of is one).

 In your Vendor Form definition you set the User Base to be the top level 
 of your organization where you want to start searching. In my case I have 
 it set to the root of the tree.

 If you turn on the plugin log to the highest level you can see the queries 
 generated.  Basically all the system is doing is to append to the ldap 
 string the rest of your search parameters.  i.e.  If I put grooms in the 
 sAMAccountName field on my LDAP vendor form the query generated is:
  ldap://DNS_SERVER/DC=AAA,DC=,DC=NET??sub?((objectclass=user)(sAMAccountName=*grooms*))
 In my case the record is in the sublevel:  OU=User 
 Accounts,DC=AAA,DC=,DC=net

 As for tools, the 2 most common (Free ones) I know of are:
  Microsoft's LDP utility 
 http://technet.microsoft.com/en-us/library/cc772839(WS.10).aspx
  Softerra LDAP Browser  http://www.softerra.com/download.htm


 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller
 Sent: Tuesday, December 29, 2009 11:13 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARDBC LDAP Active Directory question

 Thanks Fred.

 So I could substitute another value in the ldap string and get further
 down in the tree? But not in the same form?

 My server guys instists that there's a query that Remedy is using to
 return the information in the Vendor form, but we can't see that
 query. Or can we? If anyone knows, please clue me in.

 I can create a vendor form and add every single field available, but
 only a few of them can be added to the results field list and the
 normal way of exporting records to an excel file doesn't work. How do
 I build queries into the AD, and what tools should I use?

 Drew

 On Mon, Dec 28, 2009 at 4:35 PM, Grooms, Frederick W wrote:
 Check the Form Properties - Vendor Information tab for your form. The 
 Table Name field needs to have the sub value in it to allow searches to 
 go beyond the currently defined level.

 ldap://DNS_SERVER/DC=AAA,DC=,DC=NET??sub?(objectclass=user)

 The objectclass=user just restricts the results to values with user in the 
 objectclass field, not what levels to search.

 Fred


 -Original Message-
 From: Action 

Re: ARDBC LDAP Active Directory question

2009-12-30 Thread Kevin Begosh
okay so all the OU's would go before the DC's, thanks.  I was trying it the
other way around.

Kevin

On Wed, Dec 30, 2009 at 11:02 AM, Grooms, Frederick W 
frederick.w.gro...@xo.com wrote:

 It should go something like this (in this case I am looking at an OU of:
 User Accounts):

 ldap://host/OU=User
 Accounts,DC=www,DC=mycompany,DC=net??sub?(objectclass=user)

 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Kevin Begosh
 Sent: Wednesday, December 30, 2009 8:38 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARDBC LDAP Active Directory question

 **
 Fred,
 How do you add the OU to the vendor form query string, I added mine and I
 am getting an error?  ARS 7.5, ITMS 7.5, Windows 2003

 Kevin
 On Tue, Dec 29, 2009 at 4:51 PM, Drew Shuller d...@io.com wrote:
 Norm! Thanks for the help. Thanks again Fred.

 I tried it out in a form, it looks like it's going to work.

 Drew


 On Tue, Dec 29, 2009 at 3:44 PM, Drew Shuller wrote:
  Norm! Thanks for the help. Thanks again Fred.
 
  I tried it out in a form, it looks like it's going to work.
 
  Drew
 
   On Tue, Dec 29, 2009 at 2:53 PM, Grooms, Frederick W wrote:
  I learned not to use sAMAccountName as Request ID.  I use uSNCreated
 (which *SHOULD BE* unique and less than 15 characters).  Just use
 sAMAccountName as a regular field from the ActiveDirectory.
 
  Fred
 
  -Original Message-
  From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Drew Shuller
  Sent: Tuesday, December 29, 2009 2:35 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: ARDBC LDAP Active Directory question
 
  Thank you Fred, that's very helpful. After some googling I was able to
  generate a query using the MMC console, which was helpful in that I
  got to see a lot of columns of data all in one place.
 
  Thanks for the query string. My guy wanted to see what Remedy was
  generating...no one can see that in Remedy itself but it looks like
  one can figure it out and build it because an LDAP/AD query is an
  LDAP/AD query, so to speak.
 
  My only other problem (AD-wise that is) is the mismatch between the
  samAccountName attribute length and the 6.3 RequestID field length,
  which causes blank entries in the vendor form. Oddly enough I can see
  the name in the Results list but not in the fields of the form itself.
  I suggested that we truncate the samAccountName field to 15 characters
  and put the result in an unused AD attribute and then use that for the
  Request ID map. Any suggestions on that? Has this been handled in the
  Remedy versions released after the stone age? Not that I'm knocking
  6.3, I kinda like it, it gives me a nice warm fuzzy. :-)
 
  Drew
  Soto Cano
 
  On Tue, Dec 29, 2009 at 1:39 PM, Grooms, Frederick W wrote:
  ldap://host[:port]/User Base??sub?(User Filter)
 
  As long as you have sub in there it should look at your user base and
 all sublevels (the other option I know of is one).
 
  In your Vendor Form definition you set the User Base to be the top
 level of your organization where you want to start searching. In my case I
 have it set to the root of the tree.
 
  If you turn on the plugin log to the highest level you can see the
 queries generated.  Basically all the system is doing is to append to the
 ldap string the rest of your search parameters.  i.e.  If I put grooms in
 the sAMAccountName field on my LDAP vendor form the query generated is:
 
  
 ldap://DNS_SERVER/DC=AAA,DC=,DC=NET??sub?((objectclass=user)(sAMAccountName=*grooms*))
  In my case the record is in the sublevel:  OU=User
 Accounts,DC=AAA,DC=,DC=net
 
  As for tools, the 2 most common (Free ones) I know of are:
   Microsoft's LDP utility
 http://technet.microsoft.com/en-us/library/cc772839(WS.10).aspx
   Softerra LDAP Browser  http://www.softerra.com/download.htm
 
 
  Fred
 
  -Original Message-
  From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Drew Shuller
  Sent: Tuesday, December 29, 2009 11:13 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: ARDBC LDAP Active Directory question
 
  Thanks Fred.
 
  So I could substitute another value in the ldap string and get further
  down in the tree? But not in the same form?
 
  My server guys instists that there's a query that Remedy is using to
  return the information in the Vendor form, but we can't see that
  query. Or can we? If anyone knows, please clue me in.
 
  I can create a vendor form and add every single field available, but
  only a few of them can be added to the results field list and the
  normal way of exporting records to an excel file doesn't work. How do
  I build queries into the AD, and what tools should I use?
 
  Drew
 
  On Mon, Dec 28, 2009 at 4:35 PM, Grooms, Frederick W wrote:
  Check the Form Properties - Vendor Information tab for your form. The
 Table Name field needs to have the sub value in it to allow searches to go
 

Re: ARDBC LDAP Active Directory question

2009-12-30 Thread Grooms, Frederick W
Use a tool like LDP and see what the distinguishedName is for a user and that 
will tell you how it is laid out in your tree.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh
Sent: Wednesday, December 30, 2009 10:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARDBC LDAP Active Directory question

** 
okay so all the OU's would go before the DC's, thanks.  I was trying it the 
other way around.
 
Kevin


On Wed, Dec 30, 2009 at 11:02 AM, Grooms, Frederick W wrote:
It should go something like this (in this case I am looking at an OU of: User 
Accounts):

ldap://host/OU=User 
Accounts,DC=www,DC=mycompany,DC=net??sub?(objectclass=user)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh
Sent: Wednesday, December 30, 2009 8:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARDBC LDAP Active Directory question
**
Fred,
How do you add the OU to the vendor form query string, I added mine and I am 
getting an error?  ARS 7.5, ITMS 7.5, Windows 2003
 
Kevin
On Tue, Dec 29, 2009 at 4:51 PM, Drew Shuller d...@io.com wrote:
Norm! Thanks for the help. Thanks again Fred.

I tried it out in a form, it looks like it's going to work.

Drew

On Tue, Dec 29, 2009 at 3:44 PM, Drew Shuller wrote:
 Norm! Thanks for the help. Thanks again Fred.

 I tried it out in a form, it looks like it's going to work.

 Drew

 On Tue, Dec 29, 2009 at 2:53 PM, Grooms, Frederick W wrote:
 I learned not to use sAMAccountName as Request ID.  I use uSNCreated (which 
 *SHOULD BE* unique and less than 15 characters).  Just use sAMAccountName as 
 a regular field from the ActiveDirectory.

 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller
 Sent: Tuesday, December 29, 2009 2:35 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARDBC LDAP Active Directory question

 Thank you Fred, that's very helpful. After some googling I was able to
 generate a query using the MMC console, which was helpful in that I
 got to see a lot of columns of data all in one place.

 Thanks for the query string. My guy wanted to see what Remedy was
 generating...no one can see that in Remedy itself but it looks like
 one can figure it out and build it because an LDAP/AD query is an
 LDAP/AD query, so to speak.

 My only other problem (AD-wise that is) is the mismatch between the
 samAccountName attribute length and the 6.3 RequestID field length,
 which causes blank entries in the vendor form. Oddly enough I can see
 the name in the Results list but not in the fields of the form itself.
 I suggested that we truncate the samAccountName field to 15 characters
 and put the result in an unused AD attribute and then use that for the
 Request ID map. Any suggestions on that? Has this been handled in the
 Remedy versions released after the stone age? Not that I'm knocking
 6.3, I kinda like it, it gives me a nice warm fuzzy. :-)

 Drew
 Soto Cano

 On Tue, Dec 29, 2009 at 1:39 PM, Grooms, Frederick W wrote:
 ldap://host[:port]/User Base??sub?(User Filter)

 As long as you have sub in there it should look at your user base and all 
 sublevels (the other option I know of is one).

 In your Vendor Form definition you set the User Base to be the top level 
 of your organization where you want to start searching. In my case I have 
 it set to the root of the tree.

 If you turn on the plugin log to the highest level you can see the queries 
 generated.  Basically all the system is doing is to append to the ldap 
 string the rest of your search parameters.  i.e.  If I put grooms in the 
 sAMAccountName field on my LDAP vendor form the query generated is:
  ldap://DNS_SERVER/DC=AAA,DC=,DC=NET??sub?((objectclass=user)(sAMAccountName=*grooms*))
 In my case the record is in the sublevel:  OU=User 
 Accounts,DC=AAA,DC=,DC=net

 As for tools, the 2 most common (Free ones) I know of are:
  Microsoft's LDP utility 
 http://technet.microsoft.com/en-us/library/cc772839(WS.10).aspx
  Softerra LDAP Browser  http://www.softerra.com/download.htm


 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller
 Sent: Tuesday, December 29, 2009 11:13 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARDBC LDAP Active Directory question

 Thanks Fred.

 So I could substitute another value in the ldap string and get further
 down in the tree? But not in the same form?

 My server guys instists that there's a query that Remedy is using to
 return the information in the Vendor form, but we can't see that
 query. Or can we? If anyone knows, please clue me in.

 I can create a vendor form and add every single field available, but
 only a few of them can be added to the results field list and the
 normal way of exporting records to an excel file doesn't work. How do
 I build 

Re: ARDBC LDAP Active Directory question

2009-12-30 Thread Kevin Begosh
I have been using ADExplorer.  It calls out the tree it is just a little
different and backwards from the way remedy puts it in.

Thanks,
Kevin

On Wed, Dec 30, 2009 at 11:54 AM, Grooms, Frederick W 
frederick.w.gro...@xo.com wrote:

 Use a tool like LDP and see what the distinguishedName is for a user and
 that will tell you how it is laid out in your tree.

 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Kevin Begosh
 Sent: Wednesday, December 30, 2009 10:36 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARDBC LDAP Active Directory question

 **
 okay so all the OU's would go before the DC's, thanks.  I was trying it the
 other way around.

 Kevin


  On Wed, Dec 30, 2009 at 11:02 AM, Grooms, Frederick W wrote:
 It should go something like this (in this case I am looking at an OU of:
 User Accounts):

 ldap://host/OU=User
 Accounts,DC=www,DC=mycompany,DC=net??sub?(objectclass=user)

 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Kevin Begosh
 Sent: Wednesday, December 30, 2009 8:38 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARDBC LDAP Active Directory question
 **
 Fred,
 How do you add the OU to the vendor form query string, I added mine and I
 am getting an error?  ARS 7.5, ITMS 7.5, Windows 2003

 Kevin
 On Tue, Dec 29, 2009 at 4:51 PM, Drew Shuller d...@io.com wrote:
 Norm! Thanks for the help. Thanks again Fred.

 I tried it out in a form, it looks like it's going to work.

 Drew

 On Tue, Dec 29, 2009 at 3:44 PM, Drew Shuller wrote:
  Norm! Thanks for the help. Thanks again Fred.
 
  I tried it out in a form, it looks like it's going to work.
 
  Drew
 
  On Tue, Dec 29, 2009 at 2:53 PM, Grooms, Frederick W wrote:
  I learned not to use sAMAccountName as Request ID.  I use uSNCreated
 (which *SHOULD BE* unique and less than 15 characters).  Just use
 sAMAccountName as a regular field from the ActiveDirectory.
 
  Fred
 
  -Original Message-
  From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Drew Shuller
  Sent: Tuesday, December 29, 2009 2:35 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: ARDBC LDAP Active Directory question
 
  Thank you Fred, that's very helpful. After some googling I was able to
  generate a query using the MMC console, which was helpful in that I
  got to see a lot of columns of data all in one place.
 
  Thanks for the query string. My guy wanted to see what Remedy was
  generating...no one can see that in Remedy itself but it looks like
  one can figure it out and build it because an LDAP/AD query is an
  LDAP/AD query, so to speak.
 
  My only other problem (AD-wise that is) is the mismatch between the
  samAccountName attribute length and the 6.3 RequestID field length,
  which causes blank entries in the vendor form. Oddly enough I can see
  the name in the Results list but not in the fields of the form itself.
  I suggested that we truncate the samAccountName field to 15 characters
  and put the result in an unused AD attribute and then use that for the
  Request ID map. Any suggestions on that? Has this been handled in the
  Remedy versions released after the stone age? Not that I'm knocking
  6.3, I kinda like it, it gives me a nice warm fuzzy. :-)
 
  Drew
  Soto Cano
 
  On Tue, Dec 29, 2009 at 1:39 PM, Grooms, Frederick W wrote:
  ldap://host[:port]/User Base??sub?(User Filter)
 
  As long as you have sub in there it should look at your user base and
 all sublevels (the other option I know of is one).
 
  In your Vendor Form definition you set the User Base to be the top
 level of your organization where you want to start searching. In my case I
 have it set to the root of the tree.
 
  If you turn on the plugin log to the highest level you can see the
 queries generated.  Basically all the system is doing is to append to the
 ldap string the rest of your search parameters.  i.e.  If I put grooms in
 the sAMAccountName field on my LDAP vendor form the query generated is:
 
  
 ldap://DNS_SERVER/DC=AAA,DC=,DC=NET??sub?((objectclass=user)(sAMAccountName=*grooms*))
  In my case the record is in the sublevel:  OU=User
 Accounts,DC=AAA,DC=,DC=net
 
  As for tools, the 2 most common (Free ones) I know of are:
   Microsoft's LDP utility
 http://technet.microsoft.com/en-us/library/cc772839(WS.10).aspx
   Softerra LDAP Browser  http://www.softerra.com/download.htm
 
 
  Fred
 
  -Original Message-
  From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Drew Shuller
  Sent: Tuesday, December 29, 2009 11:13 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: ARDBC LDAP Active Directory question
 
  Thanks Fred.
 
  So I could substitute another value in the ldap string and get further
  down in the tree? But not in the same form?
 
  My server guys instists that there's a query that Remedy is using to
  return the 

Re: Service

2009-12-30 Thread Barb Wagner
Hi Mark

I think this is discussed in the BMC Atrium documentation - it was covered
as part of the Atrium 7.5 What's New course ... so I think that is where
you could probably find more info regarding this

Barb Wagner
Remedy Architect
IBM Global Services
(612) 397-2955
Tie Line 608-1958
bar...@us.ibm.com



   
 Mark Lev  
 mark@rightst 
 ARSYSTEMS.COM To 
 Sent by: Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion list   
 (ARSList)Subject 
 arsl...@arslist. Service 
 ORG  
   
   
 12/30/2009 07:16  
 AM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




**
Does anyone know where in BMC Remedy 7.5 documentation it is discussed how
to create/manage services.

The field I am referring to is on the Incident form, Service*+.

I understand services are CI’s and need to be related, and I am able to
create these and get them to work, but I would like to better understand
how and why they work.  I cannot seem to locate any documentation on this
topic.

Thanks,
Mark



_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

inline: graycol.gifinline: pic20621.gifinline: ecblank.gif

Error with API integration

2009-12-30 Thread SriSamSri Appecherla
Hi Listers,

I am trying to connect to Remedy using a Java API. Though the server is up
and running. I am able to login to the User tool using the same credentials
that I am using in API. But the API is unable to connect to Remedy and is
showing this error:

ERROR (90): Cannot establish a network connection to the AR System server;
Connection refused

I am using ARS 7.5 with Oracle 11g DB on Sun Solaris platform.

I checked the Minimum API version, it is set to 0. The arplugin.log has the
error:

 2009-12-30 20:12:19,605 ERROR [main]
com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup
Error
java.net.BindException: Address already in use
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
at java.net.ServerSocket.bind(ServerSocket.java:319)
at java.net.ServerSocket.init(ServerSocket.java:185)
at org.acplt.oncrpc.server.OncRpcTcpServerTransport.init(Unknown
Source)
at com.bmc.arsys.arrpc.ARPluginServerDispatcher.init(Unknown
Source)
at com.bmc.arsys.pluginsvr.a.init(Unknown Source)
at
com.bmc.arsys.pluginsvr.ARPluginServerManager.initRpcDispatcher(Unknown
Source)
at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)
Exception in thread main java.lang.NullPointerException
at com.bmc.arsys.pluginsvr.ARPluginServerMain.stopServer(Unknown
Source)
at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)
Can anybody please help me in troubleshooting this?

Regards,
SriSamSri Appecherla
Mobile# +91 988 480 4001

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Error with API integration

2009-12-30 Thread Juan Ingles
Check to make sure that the TCP port that you have configured for ARS is
free and not in use by another application.

Note that it could be that ARS didn't shutdown cleanly and the previous
instance is actually the one holding the port open. The lsof command is
pretty handy in determining what has a particular port open.

Until you get a clean ARS startup, it's hard to say what's going on with the
API program. ARERR 90 is pretty generic error.


Juan Ingles




On Wed, Dec 30, 2009 at 10:39 AM, SriSamSri Appecherla 
appecherla@gmail.com wrote:

 **
 Hi Listers,

 I am trying to connect to Remedy using a Java API. Though the server is up
 and running. I am able to login to the User tool using the same credentials
 that I am using in API. But the API is unable to connect to Remedy and is
 showing this error:

 ERROR (90): Cannot establish a network connection to the AR System server;
 Connection refused

 I am using ARS 7.5 with Oracle 11g DB on Sun Solaris platform.

 I checked the Minimum API version, it is set to 0. The arplugin.log has the
 error:

  2009-12-30 20:12:19,605 ERROR [main]
 com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR Plugin Server Startup
 Error
 java.net.BindException: Address already in use
 at java.net.PlainSocketImpl.socketBind(Native Method)
 at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
 at java.net.ServerSocket.bind(ServerSocket.java:319)
 at java.net.ServerSocket.init(ServerSocket.java:185)
 at org.acplt.oncrpc.server.OncRpcTcpServerTransport.init(Unknown
 Source)
 at com.bmc.arsys.arrpc.ARPluginServerDispatcher.init(Unknown
 Source)
 at com.bmc.arsys.pluginsvr.a.init(Unknown Source)
 at
 com.bmc.arsys.pluginsvr.ARPluginServerManager.initRpcDispatcher(Unknown
 Source)
 at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)
 Exception in thread main java.lang.NullPointerException
 at com.bmc.arsys.pluginsvr.ARPluginServerMain.stopServer(Unknown
 Source)
 at com.bmc.arsys.pluginsvr.ARPluginServerMain.main(Unknown Source)
 Can anybody please help me in troubleshooting this?

 Regards,
 SriSamSri Appecherla
 Mobile# +91 988 480 4001
 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
 Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Discovery 1.6

2009-12-30 Thread Kathy Morris
Hi All,
 
Is there a way to know exactly what servers failed the discovery? We are  
discovering both Windows and Linux (using WMI and SSH) within the same  task. 
 When I view the discovery report - I have 50 pages with caution  messages 
stating WMI failed.  However somewhere later in the 50 pages  it may say SSH 
worked.  There are hundreds of servers.  I can't  trace/re-discover every 
single IP/host individually to find out if the  discovery eventually worked 
or the CI updated.
 
I see in the report 100 computers, then 50 Linux hosts with messages  with 
port not opened or credential errors, WMI not found.  However  just because 
it says this - how do I know it was not successful on the next pass  when 
SSH was triggered.  When I check the report - the asset said agent  found so 
it is terribly confusing..
 
Is there a way to just get the bottom line number - X amount of  servers 
updated, and  X number failed the discovery.
 
Then there are size restrictions on the log size that I can't seem to  
modify.
 
ugghhh

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Service

2009-12-30 Thread Mark Lev
I don’t know why I didn’t think of looking there, I would have thought they 
would have at least mentioned in an ITSM guide.

This is pointing me in the right direction.  Thanks!

Mark



From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Barb Wagner
Sent: Wednesday, December 30, 2009 12:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Service


Hi Mark

I think this is discussed in the BMC Atrium documentation - it was covered as 
part of the Atrium 7.5 What's New course ... so I think that is where you could 
probably find more info regarding this

Barb Wagner
Remedy Architect
IBM Global Services
(612) 397-2955
Tie Line 608-1958
bar...@us.ibm.com


[cid:image001.gif@01CA895F.49B35B70]Mark Lev ---12/30/2009 07:24:36 AM---** 
Does anyone know where in BMC Remedy 7.5 documentation it is discussed how to 
create/manage services.
Mark Lev mark@rightstarsystems.com
Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG

12/30/2009 07:16 AM
Please respond to
arslist@ARSLIST.ORG



To


arslist@ARSLIST.ORG


cc




Subject


Service








**
Does anyone know where in BMC Remedy 7.5 documentation it is discussed how to 
create/manage services.

The field I am referring to is on the Incident form, Service*+.

I understand services are CI’s and need to be related, and I am able to create 
these and get them to work, but I would like to better understand how and why 
they work. I cannot seem to locate any documentation on this topic.

Thanks,
Mark

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
inline: image001.gifinline: image002.pnginline: image003.png

Q: GUID Generation

2009-12-30 Thread Craig Carter
Anyone know if the actual code behind Application_Generate_GUID is available 
anywhere?  We need to try and duplicate this functionality in a different 
system for integration purposes and wondered if this information is available 
anywhere?

Regards,
Craig Carter
Information Technology Manager, RSP




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Q: GUID Generation

2009-12-30 Thread tristan.rop...@t-online.de
**
Hi,I don´t know,
what you want to do with this information.But
you can also use the sequence generation function of the database
(Oracle).CheersTristan-Original Message-Date:
Wed, 30 Dec 2009 21:28:07 +0100Subject: Q: GUID GenerationFrom:         Craig Carter craig.car...@arpc.denver.af.milTo:           arslist@ARSLIST.ORG** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
Where the Answers Are_ Anyone know if the actual
code behind “Application_Generate_GUID” is available anywhere?  We need
to try and duplicate this functionality in a different system for
integration purposes and wondered if this information is available
anywhere?Regards,Craig CarterInformation Technology Manager,
RSP
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


Re: Q: GUID Generation

2009-12-30 Thread Craig Carter
We're actually on SQL Server and they are on MySQL and we can't use a simple 
sequencer anyway.  After reviewing GUID and UUID, there are several variances 
on this and I'd like to basically duplicate what the BMC/Remedy function does 
rather than have them call a Remedy web service and pass one back.  We're 
basically migrating certain processes to another system but keeping them 
integrated so it would be easier if their system could generate a like value 
going forward.

Craig Carter
Information Technology Manager, RSP

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of tristan.rop...@t-online.de
Sent: Wednesday, December 30, 2009 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

** 

Hi,


I don´t know, what you want to do with this information.

But you can also use the sequence generation function of the database (Oracle).


Cheers


Tristan
-Original Message-
Date: Wed, 30 Dec 2009 21:28:07 +0100
Subject: Q: GUID Generation
From: Craig Carter craig.car...@arpc.denver.af.mil
To:   arslist@ARSLIST.ORG

** 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

Anyone know if the actual code behind Application_Generate_GUID is available 
anywhere?  We need to try and duplicate this functionality in a different 
system for integration purposes and wondered if this information is available 
anywhere?
Regards,
Craig Carter
Information Technology Manager, RSP
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


7.5 Hover on the user tool

2009-12-30 Thread Kevin Begosh
List,
Does anyone know how to change the hover time on the Remedy User Tool.  I
found this

Arsystemhover_wait_time = 500

but it did not work, adding it to the ar.cfg file.  I also see an entry in
the config.properties on the mid tier but I did not know if that fixed the
user tool.

Any one mess with that

ARS 7.5, ITSM 7.5, Windows 2003

-- 
Kevin Begosh

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Q: GUID Generation

2009-12-30 Thread Grooms, Frederick W
I'm not exactly clear why you need to use Remedy's GUID.
  On MS SQL server you could use the NewID() function to generate a unique ID   
  On MySQL you can use UUID() function
Either one of those will give you a Unique ID to work with.

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Craig Carter
Sent: Wednesday, December 30, 2009 2:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

We're actually on SQL Server and they are on MySQL and we can't use a simple 
sequencer anyway.  After reviewing GUID and UUID, there are several variances 
on this and I'd like to basically duplicate what the BMC/Remedy function does 
rather than have them call a Remedy web service and pass one back.  We're 
basically migrating certain processes to another system but keeping them 
integrated so it would be easier if their system could generate a like value 
going forward.

Craig Carter
Information Technology Manager, RSP

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of tristan.rop...@t-online.de
Sent: Wednesday, December 30, 2009 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

** 

Hi,


I don´t know, what you want to do with this information.

But you can also use the sequence generation function of the database (Oracle).


Cheers


Tristan
-Original Message-
Date: Wed, 30 Dec 2009 21:28:07 +0100
Subject: Q: GUID Generation
From: Craig Carter craig.car...@arpc.denver.af.mil
To:   arslist@ARSLIST.ORG

** 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

Anyone know if the actual code behind Application_Generate_GUID is available 
anywhere?  We need to try and duplicate this functionality in a different 
system for integration purposes and wondered if this information is available 
anywhere?
Regards,
Craig Carter
Information Technology Manager, RSP
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


MidTier and Macintosh -- end of year fun

2009-12-30 Thread John Sundberg



Just wondering -- is anybody heavily using MidTier 7.5 and the Mac?

If so -- happy?

If not happy -- why?


Followup -- will MidTier 7.5 work against 7.01 ARS?
And - is anybody doing it?




Side question - any idea why these files exist in the MidTier.war?

./WEB-INF/lib/arapi75.dll
./WEB-INF/lib/arjni75.dll
./WEB-INF/lib/arodbc75.dll
./WEB-INF/lib/arrpc75.dll
./WEB-INF/lib/arutiljni75.dll
./WEB-INF/lib/arutl75.dll






-John





--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of the WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com








___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


SRM

2009-12-30 Thread Tommy Morris
Has anyone installed SRM 7.6? If so what do you think about it?



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: 7.5 Hover on the user tool

2009-12-30 Thread DCI Remedy
You can change the hover time in the AR System User preference form, Web
tab.  Page 110 in the config guide.  Its all in milliseconds, so 500
milliseconds = 0.5 seconds.

On Wed, Dec 30, 2009 at 2:18 PM, Kevin Begosh kbeg...@gmail.com wrote:

 **
 List,
 Does anyone know how to change the hover time on the Remedy User Tool.  I
 found this

 Arsystemhover_wait_time = 500

 but it did not work, adding it to the ar.cfg file.  I also see an entry in
 the config.properties on the mid tier but I did not know if that fixed the
 user tool.

 Any one mess with that

 ARS 7.5, ITSM 7.5, Windows 2003

 --
 Kevin Begosh
 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
 Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: 7.5 Hover on the user tool

2009-12-30 Thread Kevin Begosh
is there anyway to do it for the server and not for each user.

On Wed, Dec 30, 2009 at 4:33 PM, DCI Remedy dci.rem...@gmail.com wrote:

 ** You can change the hover time in the AR System User preference form, Web
 tab.  Page 110 in the config guide.  Its all in milliseconds, so 500
 milliseconds = 0.5 seconds.

 On Wed, Dec 30, 2009 at 2:18 PM, Kevin Begosh kbeg...@gmail.com wrote:

 **
  List,
 Does anyone know how to change the hover time on the Remedy User Tool.  I
 found this

 Arsystemhover_wait_time = 500

 but it did not work, adding it to the ar.cfg file.  I also see an entry in
 the config.properties on the mid tier but I did not know if that fixed the
 user tool.

 Any one mess with that

 ARS 7.5, ITSM 7.5, Windows 2003

 --
 Kevin Begosh
 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
 Are_


 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
 Are_




-- 
Kevin Begosh

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Q: GUID Generation

2009-12-30 Thread Craig Carter
We were primarily trying to keep consistency between the million or so records 
we already have with the old format that will still be there.  We'll 
investigate the UUID function on MySQL and see if that will work.  Having never 
used MySQL, I wasn't aware that existed.

Craig Carter
Information Technology Manager, RSP

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, December 30, 2009 2:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

I'm not exactly clear why you need to use Remedy's GUID.
  On MS SQL server you could use the NewID() function to generate a unique ID   
  On MySQL you can use UUID() function
Either one of those will give you a Unique ID to work with.

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Craig Carter
Sent: Wednesday, December 30, 2009 2:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

We're actually on SQL Server and they are on MySQL and we can't use a simple 
sequencer anyway.  After reviewing GUID and UUID, there are several variances 
on this and I'd like to basically duplicate what the BMC/Remedy function does 
rather than have them call a Remedy web service and pass one back.  We're 
basically migrating certain processes to another system but keeping them 
integrated so it would be easier if their system could generate a like value 
going forward.

Craig Carter
Information Technology Manager, RSP

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of tristan.rop...@t-online.de
Sent: Wednesday, December 30, 2009 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

** 

Hi,


I don´t know, what you want to do with this information.

But you can also use the sequence generation function of the database (Oracle).


Cheers


Tristan
-Original Message-
Date: Wed, 30 Dec 2009 21:28:07 +0100
Subject: Q: GUID Generation
From: Craig Carter craig.car...@arpc.denver.af.mil
To:   arslist@ARSLIST.ORG

** 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

Anyone know if the actual code behind Application_Generate_GUID is available 
anywhere?  We need to try and duplicate this functionality in a different 
system for integration purposes and wondered if this information is available 
anywhere?
Regards,
Craig Carter
Information Technology Manager, RSP
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Re: Q: GUID Generation

2009-12-30 Thread John Sundberg

Depending on your need.

You could just write a filter to generate 1,000,000 GUIDs -- then copy  
them over to MySQL.


Then -- pluck them off one at a time.

(There -- you get the exact GUID :)



(I like to throw out ideas -- that are crazy -- but would work --  
kinda fun)




-John












On Dec 30, 2009, at 4:52 PM, Craig Carter wrote:

We were primarily trying to keep consistency between the million or so  
records we already have with the old format that will still be there.   
We'll investigate the UUID function on MySQL and see if that will  
work.  Having never used MySQL, I wasn't aware that existed.


Craig Carter
Information Technology Manager, RSP

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG 
] On Behalf Of Grooms, Frederick W

Sent: Wednesday, December 30, 2009 2:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

I'm not exactly clear why you need to use Remedy's GUID.
 On MS SQL server you could use the NewID() function to generate a  
unique ID

 On MySQL you can use UUID() function
Either one of those will give you a Unique ID to work with.

Fred


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG 
] On Behalf Of Craig Carter

Sent: Wednesday, December 30, 2009 2:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

We're actually on SQL Server and they are on MySQL and we can't use a  
simple sequencer anyway.  After reviewing GUID and UUID, there are  
several variances on this and I'd like to basically duplicate what the  
BMC/Remedy function does rather than have them call a Remedy web  
service and pass one back.  We're basically migrating certain  
processes to another system but keeping them integrated so it would be  
easier if their system could generate a like value going forward.


Craig Carter
Information Technology Manager, RSP

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG 
] On Behalf Of tristan.rop...@t-online.de

Sent: Wednesday, December 30, 2009 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Q: GUID Generation

**

Hi,


I don´t know, what you want to do with this information.

But you can also use the sequence generation function of the database  
(Oracle).



Cheers


Tristan
-Original Message-
Date: Wed, 30 Dec 2009 21:28:07 +0100
Subject: Q: GUID Generation
From: Craig Carter craig.car...@arpc.denver.af.mil
To:   arslist@ARSLIST.ORG

**
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the  
Answers Are_


Anyone know if the actual code behind Application_Generate_GUID is  
available anywhere?  We need to try and duplicate this functionality  
in a different system for integration purposes and wondered if this  
information is available anywhere?

Regards,
Craig Carter
Information Technology Manager, RSP
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the  
Answers Are_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers  
Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers  
Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers  
Are


--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of the WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are