Make sure DatasetId is set to BMC.ASSET. You *may* also need to set zTmpKeyword and zTmpSchemaName.
Scott is right. Do a query on BMC:BMC_AssetBase for a record you can see and a record you can't and note the differences. Cheers Ben >----- ------- Original Message ------- ----- >From: Scott Parrish ><[EMAIL PROTECTED]> >To: [email protected] >Sent: Wed, 22 Nov 2006 11:09:56 > >Off the top of my head, I believe the ClassId for >the imported records must >match the ClassId for the class in SHR:SchemaNames >. . . if you look at the >ClassID of the records that you manually created >you will notice that it is >the same for each record. You will need to add the >ClassID field and it's >hard coded value to your import (or create workflow >to do a lookup on >import). > >Scott Parrish >IT Prophets, LLC >(770) 653-5203 >http://www.itprophets.com > > >-----Original Message----- >From: Action Request System discussion >list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Meyer, >Jennifer >Sent: Wednesday, November 22, 2006 11:06 AM >To: [email protected] >Subject: Query does not show existing records > >Hello, Listers, > >Overview:I have imported a number of test records >into >AST:ComputerSystem; however, when I perform an >unqualified search on the >form, no records are retrieved. > >Details:If I create new records from >AST:ComputerSystem, those records >are retrieved, but not my imported records. I have >run logging on both >the submit and the query. > >AST:ComputerSystem is an inner join of >BMC:BMC_ComputerSystem on itself. >BMC:BMC_ComputerSystem is an inner join of >BMC:BMC_ComputerSystem_ with >BMC:BMC_AssetBase. > >So in order to import records to >AST:ComputerSystem, I imported records >to both BMC:BMC_ComputerSystem_ and >BMC:BMC_AssetBase with matching >Instance IDs. I can see the records exist in >AST:ComputerSystem using a >SQL select statement, but they don't appear in the >Remedy query. >(select InstanceID from AST_ComputerSystem) > >Environment: ARS 6.3, ITSM 6.0, Solaris 10, Oracle >9i > >Does anyone have an idea what I'm doing wrong? > >Jennifer Meyer >Remedy Support Engineer >Strategic Technologies Inc. >[EMAIL PROTECTED] > >___________________________________________________ >_________________________ >___ >UNSUBSCRIBE or access ARSlist Archives at >www.arslist.org ARSlist:"Where the >Answers Are" > >___________________________________________________ >____________________________ >UNSUBSCRIBE or access ARSlist Archives at >www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
