Re: cmdbdriver exporting data
I was wrong about the SW in the last posting. That was fixed in patch 3. However, what I just realized (with the help of Danny) is that there is a 'xexpdt' command and an 'expdt' command. I was following instructions from the CMDB docs and using the 'xexpdt' command which does not allow for a query and which does not produce any output for large amounts of data. On Fri, Aug 28, 2009 at 10:59 AM, Danny Kellett wrote: > Use the qualification string. > > In cmdb driver. Use these command expdt > > expdt > BMC.CORE > BMC_ComputerSystem > BMC.ASSET > 'Company' = "My Company" > 0 > 0 > 0 > 1000 > C:\exportedcidata.xml > > > The above will export 1000 Computer System CIs where the company is My > Company > > Regards > Danny > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso > Sent: 28 August 2009 08:10 > To: arslist@ARSLIST.ORG > Subject: Re: cmdbdriver exporting data > > As far as I can tell there is no way to tell the "cmdbdriver" program > to limit (filter) data for a specifc class. > > On Thu, Aug 27, 2009 at 7:46 PM, > danny.kell...@strategicworkflow.com > wrote: >> What happends if you still use computer system but put a qualifier in so >> you reduce the output. Or put a value for first matching and max matching >> and do it in batches >> >> Kind regards >> Danny >> >> Original Message: >> - >> From: Frank Caruso caruso.fr...@gmail.com >> Date: Thu, 27 Aug 2009 10:40:32 +0300 >> To: arslist@ARSLIST.ORG >> Subject: cmdbdriver exporting data >> >> >> CMDB 2.1 >> ARS 7.1p5 >> SQL Server 2003 >> >> Attempting use the cmdbdriver program to export Class (BMC_Computer) >> data. There are several thousand computer records. However, the tool >> does not export the data. It runs for a long time and creates several >> files but all of them empty. The driver program does not report any >> errors. >> If I export a different class, one with less data, it works fine. I >> can even export data from the same BMC_ComputerSystem class for a >> dataset within that class that has a dozen or so records. I only seem >> to have an issue when there are lots of records - not sure what the >> magic number is. >> >> TIA >> >> Frank >> >> > >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" >> >> >> >> mail2web.com - Enhanced email for the mobile individual based on > MicrosoftR >> Exchange - http://link.mail2web.com/Personal/EnhancedEmail >> >> > > ___ >> 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" > > __ Information from ESET NOD32 Antivirus, version of virus signature > database 4375 (20090827) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > > __ Information from ESET NOD32 Antivirus, version of virus signature > database 4375 (20090827) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > ___ > 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"
SOLVED Re: cmdbdriver exporting data
Looks like patch 5 has the fix with SW00291716; The cmdbdriver process failed if you exported all data to an XML file. The BMC Remedy AR System server also stopped responding. On Fri, Aug 28, 2009 at 10:59 AM, Danny Kellett wrote: > Use the qualification string. > > In cmdb driver. Use these command expdt > > expdt > BMC.CORE > BMC_ComputerSystem > BMC.ASSET > 'Company' = "My Company" > 0 > 0 > 0 > 1000 > C:\exportedcidata.xml > > > The above will export 1000 Computer System CIs where the company is My > Company > > Regards > Danny > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso > Sent: 28 August 2009 08:10 > To: arslist@ARSLIST.ORG > Subject: Re: cmdbdriver exporting data > > As far as I can tell there is no way to tell the "cmdbdriver" program > to limit (filter) data for a specifc class. > > On Thu, Aug 27, 2009 at 7:46 PM, > danny.kell...@strategicworkflow.com > wrote: >> What happends if you still use computer system but put a qualifier in so >> you reduce the output. Or put a value for first matching and max matching >> and do it in batches >> >> Kind regards >> Danny >> >> Original Message: >> - >> From: Frank Caruso caruso.fr...@gmail.com >> Date: Thu, 27 Aug 2009 10:40:32 +0300 >> To: arslist@ARSLIST.ORG >> Subject: cmdbdriver exporting data >> >> >> CMDB 2.1 >> ARS 7.1p5 >> SQL Server 2003 >> >> Attempting use the cmdbdriver program to export Class (BMC_Computer) >> data. There are several thousand computer records. However, the tool >> does not export the data. It runs for a long time and creates several >> files but all of them empty. The driver program does not report any >> errors. >> If I export a different class, one with less data, it works fine. I >> can even export data from the same BMC_ComputerSystem class for a >> dataset within that class that has a dozen or so records. I only seem >> to have an issue when there are lots of records - not sure what the >> magic number is. >> >> TIA >> >> Frank >> >> > >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" >> >> >> >> mail2web.com - Enhanced email for the mobile individual based on > MicrosoftR >> Exchange - http://link.mail2web.com/Personal/EnhancedEmail >> >> > > ___ >> 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" > > __ Information from ESET NOD32 Antivirus, version of virus signature > database 4375 (20090827) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > > __ Information from ESET NOD32 Antivirus, version of virus signature > database 4375 (20090827) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > ___ > 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: cmdbdriver exporting data
Use the qualification string. In cmdb driver. Use these command expdt expdt BMC.CORE BMC_ComputerSystem BMC.ASSET 'Company' = "My Company" 0 0 0 1000 C:\exportedcidata.xml The above will export 1000 Computer System CIs where the company is My Company Regards Danny -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: 28 August 2009 08:10 To: arslist@ARSLIST.ORG Subject: Re: cmdbdriver exporting data As far as I can tell there is no way to tell the "cmdbdriver" program to limit (filter) data for a specifc class. On Thu, Aug 27, 2009 at 7:46 PM, danny.kell...@strategicworkflow.com wrote: > What happends if you still use computer system but put a qualifier in so > you reduce the output. Or put a value for first matching and max matching > and do it in batches > > Kind regards > Danny > > Original Message: > - > From: Frank Caruso caruso.fr...@gmail.com > Date: Thu, 27 Aug 2009 10:40:32 +0300 > To: arslist@ARSLIST.ORG > Subject: cmdbdriver exporting data > > > CMDB 2.1 > ARS 7.1p5 > SQL Server 2003 > > Attempting use the cmdbdriver program to export Class (BMC_Computer) > data. There are several thousand computer records. However, the tool > does not export the data. It runs for a long time and creates several > files but all of them empty. The driver program does not report any > errors. > If I export a different class, one with less data, it works fine. I > can even export data from the same BMC_ComputerSystem class for a > dataset within that class that has a dozen or so records. I only seem > to have an issue when there are lots of records - not sure what the > magic number is. > > TIA > > Frank > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > > mail2web.com - Enhanced email for the mobile individual based on MicrosoftR > Exchange - http://link.mail2web.com/Personal/EnhancedEmail > > ___ > 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" __ Information from ESET NOD32 Antivirus, version of virus signature database 4375 (20090827) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4375 (20090827) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: cmdbdriver exporting data
Frank Patch the CMDB, I've seen this issue with 2.1 and a later patched fixed it. Exports of single classes with few records performed fine, but thousands of records just hung the driver with no output. Occasionally we'd see the arserver crash as well. I can't for the life of me remember which patch number, but if you go latest you shouldn't go far wrong. Matt -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: 28 August 2009 08:10 To: arslist@ARSLIST.ORG Subject: Re: cmdbdriver exporting data As far as I can tell there is no way to tell the "cmdbdriver" program to limit (filter) data for a specifc class. On Thu, Aug 27, 2009 at 7:46 PM, danny.kell...@strategicworkflow.com wrote: > What happends if you still use computer system but put a qualifier in so > you reduce the output. Or put a value for first matching and max matching > and do it in batches > > Kind regards > Danny > > Original Message: > - > From: Frank Caruso caruso.fr...@gmail.com > Date: Thu, 27 Aug 2009 10:40:32 +0300 > To: arslist@ARSLIST.ORG > Subject: cmdbdriver exporting data > > > CMDB 2.1 > ARS 7.1p5 > SQL Server 2003 > > Attempting use the cmdbdriver program to export Class (BMC_Computer) > data. There are several thousand computer records. However, the tool > does not export the data. It runs for a long time and creates several > files but all of them empty. The driver program does not report any > errors. > If I export a different class, one with less data, it works fine. I > can even export data from the same BMC_ComputerSystem class for a > dataset within that class that has a dozen or so records. I only seem > to have an issue when there are lots of records - not sure what the > magic number is. > > TIA > > Frank > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > > mail2web.com - Enhanced email for the mobile individual based on MicrosoftR > Exchange - http://link.mail2web.com/Personal/EnhancedEmail > > ___ > 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: cmdbdriver exporting data
As far as I can tell there is no way to tell the "cmdbdriver" program to limit (filter) data for a specifc class. On Thu, Aug 27, 2009 at 7:46 PM, danny.kell...@strategicworkflow.com wrote: > What happends if you still use computer system but put a qualifier in so > you reduce the output. Or put a value for first matching and max matching > and do it in batches > > Kind regards > Danny > > Original Message: > - > From: Frank Caruso caruso.fr...@gmail.com > Date: Thu, 27 Aug 2009 10:40:32 +0300 > To: arslist@ARSLIST.ORG > Subject: cmdbdriver exporting data > > > CMDB 2.1 > ARS 7.1p5 > SQL Server 2003 > > Attempting use the cmdbdriver program to export Class (BMC_Computer) > data. There are several thousand computer records. However, the tool > does not export the data. It runs for a long time and creates several > files but all of them empty. The driver program does not report any > errors. > If I export a different class, one with less data, it works fine. I > can even export data from the same BMC_ComputerSystem class for a > dataset within that class that has a dozen or so records. I only seem > to have an issue when there are lots of records - not sure what the > magic number is. > > TIA > > Frank > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > > mail2web.com – Enhanced email for the mobile individual based on Microsoft® > Exchange - http://link.mail2web.com/Personal/EnhancedEmail > > ___ > 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: cmdbdriver exporting data
What happends if you still use computer system but put a qualifier in so you reduce the output. Or put a value for first matching and max matching and do it in batches Kind regards Danny Original Message: - From: Frank Caruso caruso.fr...@gmail.com Date: Thu, 27 Aug 2009 10:40:32 +0300 To: arslist@ARSLIST.ORG Subject: cmdbdriver exporting data CMDB 2.1 ARS 7.1p5 SQL Server 2003 Attempting use the cmdbdriver program to export Class (BMC_Computer) data. There are several thousand computer records. However, the tool does not export the data. It runs for a long time and creates several files but all of them empty. The driver program does not report any errors. If I export a different class, one with less data, it works fine. I can even export data from the same BMC_ComputerSystem class for a dataset within that class that has a dozen or so records. I only seem to have an issue when there are lots of records - not sure what the magic number is. TIA Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" mail2web.com Enhanced email for the mobile individual based on Microsoft® Exchange - http://link.mail2web.com/Personal/EnhancedEmail ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
