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
