Hi Alberto, Bitte sehr. :) Just to understand/be sure: Are you using the Remedy ODBC driver or the ORACLE ODBC driver? When using Remedy ODBC driver: In Access - do you use the form AST:BaseElement or BMC.CORE:BMC_BaseElement to query for data? Are all expected CIs already in the productive dataset BMC.ASSET? Are you running Multitenancy? Are you using a login that has sufficient permissions?
Thanks. :) -- Mit freundlichen Grüßen Rüdiger Tams >________________________________ >Von: Alberto M. Lopez <[email protected]> >An: [email protected] >Gesendet: 12:27 Montag, 23.September 2013 >Betreff: Re: ODBC driver (MS Access) doesn't show all the records > > > >** >Hi Rüdiger! > >First "danke schön" for your quick answer. > >No, the value is "0" so there is no limit. It's strange because I'm sure that >the data are in the CMDB (I've did a report and I have a .csv file with the >data (name) of BMC_CORE_BMC_BaseElement and in Access I've joined this field >with a linked odbc table (the same BaseElement) and I have no result. :-( > >Thank you very much again! > > > >2013/9/23 Rüdiger Tams <[email protected]> > >** >>Hello Alberto, >> >>are you sure that there is no server side restriction regarding the data >>retrieval? >>e.g. Max-Entries-Per-Query: 10000 >> >>Regards >>Rüdiger >> >> >>Von: Alberto M. Lopez <[email protected]> >>>An: [email protected] >>>Gesendet: 10:54 Montag, 23.September 2013 >>>Betreff: ODBC driver (MS Access) doesn't show all the records >>> >>> >>> >>>** >>>Hi all! >>> >>> >>>I have a issue with the odbc driver when I work with MS Access. >>> >>> >>>I want to extract some data of the CMDB (8.1), MS Access doesn't show all >>>the results and I'm sure that the data I want to show are in the CMDB. >>> >>> >>>Anyone knows restrictions or similar with ODBC?. >>> >>> >>>Why I have not the data in Access?. >>> >>> >>>Thank you very much in advance!!!! >>> >>> >>>Alberto_ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >>>_ARSlist: "Where the Answers Are" and have been for 20 years_ >_ARSlist: "Where the Answers Are" and have been for 20 years_ > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
