Re: Importing data into join forms in Asset Management module SOLVED
I've been working on a Remedy Asset Management project on and off for some time now. also, ive taken the atrium cmdb: administering course which I can reccommend if you'll have to create any integration with the CMDB at some point. Regards, MIchiel On 5/11/06, Dwayne Martin <[EMAIL PROTECTED]> wrote: Thanks, Michiel and James and Roger, I did a mass update on BMC:BMC_ComputerSystem and set DatasetID to "BMC.ASSET." Now they show up in AST:ComputerSystem. I am trying not to be a "Lazy poster." I searched the Asset Management pdf document for "DatasetID" and didn't find anything. I've also taken the "Asset Management Administering" class and can't find anything about "DatasetID" in the course manual. (I may not have looked in the right place.) How did you guys learn all this? Dwayne Original message >Date: Thu, 11 May 2006 09:05:20 +0200 >From: Michiel Beijen <[EMAIL PROTECTED]> >Subject: Re: Importing data into join forms in Asset Management module >To: arslist@ARSLIST.ORG > >You probably mean the Instance ID field. Since this is field ID 179 it >is automatically generated by the system as long as you don't map it >in the Import tool. > >Regards, >Michiel > >On 5/11/06, McKenzie, James J C-E LCMC HQISEC/L3 ><[EMAIL PROTECTED]> wrote: >> ** >> >> >> Roger and all: >> >> I forgot about that one. Also, the item id (I forget which field this is >> but it is the field directly above the data set id and is quite a few >> characters in length) must be unique. If there is not workflow to set this, >> I would create such so that it functions on Merge and gives the asset a >> different set of ids than that set by the 'other' workflow. >> >> Also, I would like to state that I was very successful in RE-IMPORTING data >> back into the AST:Computer System form, but if you are trying to import NEW >> data, you have to use the BMC: forms (I don't know why, but this is the only >> way that I was able to do so.) I would set the dataset ID to BMC.ASSET or >> your items will not appear. >> >> James McKenzie >> L-3 GSI >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> To: arslist@ARSLIST.ORG >> Sent: 5/10/2006 1:22 PM >> Subject: Re: Importing data into join forms in Asset Management module >> >> >> >> >> ** >> On import the field datasetid must be set to BMC.ASSET >> >> -Original Message- >> From: Dwayne Martin <[EMAIL PROTECTED]> >> To: arslist@ARSLIST.ORG >> Sent: Wed, 10 May 2006 15:34:49 -0400 >> Subject: Importing data into join forms in Asset Management module >> >> >> >> Hello everyone, >> >> >> >> We are trying to import data into the Asset module >> >> AST:Computer system form. >> >> >> >> This is a self-join of BMC:BMC_ComputerSystem on InstanceId. >> >> >> >> BMC:BMC_ComputerSystem in turn is a join of >> >> BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based >> >> on InstanceId. >> >> >> >> The data imports and BMC:BMC_ComputerSystem_, >> >> BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have >> >> thousands of records. Most importantly, they all have >> >> matching InstanceId values. >> >> >> >> But when we query the AST:Computer system form it has no >> >> records. >> >> >> >> BMC:BMC_ComputerSystem has thousands of records, with values >> >> in InstanceId. So how can you join it to itself based on >> >> InstanceId and not get any records? >> >> >> >> What are we missing? >> >> >> >> ARS 6.3, HPUX 11 server, Oracle 9.2 db >> >> >> >> Dwayne Martin >> >> Computing Support >> >> James Madison University >> >> >> >> >> ___ >> >> >> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> <http://www.wwrug.org> >> >> >> >> >> __20060125___This posting was submitted >> with HTML in >> it___ >> __20060125___This posting was >> submitted with HTML in it___ > >___ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Importing data into join forms in Asset Management module SOLVED
Thanks, Michiel and James and Roger, I did a mass update on BMC:BMC_ComputerSystem and set DatasetID to “BMC.ASSET.” Now they show up in AST:ComputerSystem. I am trying not to be a “Lazy poster.” I searched the Asset Management pdf document for “DatasetID” and didn’t find anything. I’ve also taken the “Asset Management Administering” class and can’t find anything about “DatasetID” in the course manual. (I may not have looked in the right place.) How did you guys learn all this? Dwayne Original message >Date: Thu, 11 May 2006 09:05:20 +0200 >From: Michiel Beijen <[EMAIL PROTECTED]> >Subject: Re: Importing data into join forms in Asset Management module >To: arslist@ARSLIST.ORG > >You probably mean the Instance ID field. Since this is field ID 179 it >is automatically generated by the system as long as you don't map it >in the Import tool. > >Regards, >Michiel > >On 5/11/06, McKenzie, James J C-E LCMC HQISEC/L3 ><[EMAIL PROTECTED]> wrote: >> ** >> >> >> Roger and all: >> >> I forgot about that one. Also, the item id (I forget which field this is >> but it is the field directly above the data set id and is quite a few >> characters in length) must be unique. If there is not workflow to set this, >> I would create such so that it functions on Merge and gives the asset a >> different set of ids than that set by the 'other' workflow. >> >> Also, I would like to state that I was very successful in RE-IMPORTING data >> back into the AST:Computer System form, but if you are trying to import NEW >> data, you have to use the BMC: forms (I don't know why, but this is the only >> way that I was able to do so.) I would set the dataset ID to BMC.ASSET or >> your items will not appear. >> >> James McKenzie >> L-3 GSI >> >> -----Original Message- >> From: Action Request System discussion list(ARSList) >> To: arslist@ARSLIST.ORG >> Sent: 5/10/2006 1:22 PM >> Subject: Re: Importing data into join forms in Asset Management module >> >> >> >> >> ** >> On import the field datasetid must be set to BMC.ASSET >> >> -Original Message- >> From: Dwayne Martin <[EMAIL PROTECTED]> >> To: arslist@ARSLIST.ORG >> Sent: Wed, 10 May 2006 15:34:49 -0400 >> Subject: Importing data into join forms in Asset Management module >> >> >> >> Hello everyone, >> >> >> >> We are trying to import data into the Asset module >> >> AST:Computer system form. >> >> >> >> This is a self-join of BMC:BMC_ComputerSystem on InstanceId. >> >> >> >> BMC:BMC_ComputerSystem in turn is a join of >> >> BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based >> >> on InstanceId. >> >> >> >> The data imports and BMC:BMC_ComputerSystem_, >> >> BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have >> >> thousands of records. Most importantly, they all have >> >> matching InstanceId values. >> >> >> >> But when we query the AST:Computer system form it has no >> >> records. >> >> >> >> BMC:BMC_ComputerSystem has thousands of records, with values >> >> in InstanceId. So how can you join it to itself based on >> >> InstanceId and not get any records? >> >> >> >> What are we missing? >> >> >> >> ARS 6.3, HPUX 11 server, Oracle 9.2 db >> >> >> >> Dwayne Martin >> >> Computing Support >> >> James Madison University >> >> >> >> >> ___ >> >> >> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> <http://www.wwrug.org> >> >> >> >> >> __20060125___This posting was submitted >> with HTML in >> it___ >> __20060125___This posting was >> submitted with HTML in it___ > >___ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Dwayne Martin Computing Support James Madison University
Re: Importing data into join forms in Asset Management module
It is my understanding that you can submit to a Join form but the submit in and of itself does nothing. You can however create workflow that fires on submit to create the underlying entries in the appropriate tables. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron Fariss Sent: Thursday, May 11, 2006 9:03 AM To: arslist@ARSLIST.ORG Subject: Re: Importing data into join forms in Asset Management module Question - It is my understanding that Join forms contain data that result from a database search. I do updates via joins, but have never tried to import new data directly into a join. If, as in the original question the join is the product of one form and an initial join of 2 other forms, does the import attempt to create 3 new records (1 in each form) if all of the required fields are present? Ron Fariss AIG Technologies Remedy & TelAlert Administration Work: (713) 831-2365 Cell: (281) 782-0979 "McKenzie, James J C-E LCMC To: arslist@ARSLIST.ORG HQISEC/L3"cc: <[EMAIL PROTECTED] Subject: Re: Importing data into join forms in Asset Management module S.ARMY.MIL> Sent by: "Action Request System discussion list(ARSList)" <[EMAIL PROTECTED] RG> 05/10/2006 09:48 PM Please respond to arslist ** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -Original Message- From: Dwayne Martin <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org <http://www.wwrug.org> __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Importing data into join forms in Asset Management module
Question - It is my understanding that Join forms contain data that result from a database search. I do updates via joins, but have never tried to import new data directly into a join. If, as in the original question the join is the product of one form and an initial join of 2 other forms, does the import attempt to create 3 new records (1 in each form) if all of the required fields are present? Ron Fariss AIG Technologies Remedy & TelAlert Administration Work: (713) 831-2365 Cell: (281) 782-0979 "McKenzie, James J C-E LCMC To: arslist@ARSLIST.ORG HQISEC/L3"cc: <[EMAIL PROTECTED] Subject: Re: Importing data into join forms in Asset Management module S.ARMY.MIL> Sent by: "Action Request System discussion list(ARSList)" <[EMAIL PROTECTED] RG> 05/10/2006 09:48 PM Please respond to arslist ** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -Original Message- From: Dwayne Martin <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system f
Re: Importing data into join forms in Asset Management module
You probably mean the Instance ID field. Since this is field ID 179 it is automatically generated by the system as long as you don't map it in the Import tool. Regards, Michiel On 5/11/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote: ** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -Original Message- From: Dwayne Martin <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org <http://www.wwrug.org> __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Importing data into join forms in Asset Management module
Title: RE: Importing data into join forms in Asset Management module ** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -Original Message- From: Dwayne Martin <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org <http://www.wwrug.org> __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Importing data into join forms in Asset Management module
** On import the field datasetid must be set to BMC.ASSET -Original Message-From: Dwayne Martin <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Wed, 10 May 2006 15:34:49 -0400Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Importing data into join forms in Asset Management module
Title: RE: Importing data into join forms in Asset Management module ** Dwayne: Are you looking for NULL/NOT NULL or trying to do a wildcard search? If it is the latter you will need to surround the value with database wildcard characters. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 12:34 PM Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Importing data into join forms in Asset Management module
Dwayne, If you want to import data in the CMDB you should import it into BMC:BMC_Computersystem and not in the AST: form. Please note that when you query the AST form it will only return rows for the selected dataset (global field). You can see the dataset name in the DatasetID field on the MC:BMC forms. Kind regards, \ Michiel On 5/10/06, Dwayne Martin <[EMAIL PROTECTED]> wrote: Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org