I am doing somenthing like this:
cmsquery-cmd.bat -username "Administrator" -auth "secEnterprise" -server "localhost" -password "" -sql "SELECT TOP 5000 si_name, si_starttime, si_parent_cuid FROM CI_INFOOBJECTS WHERE si_instance=1 and si_schedule_status=3 AND SI_ANCESTOR=154721 AND SI_NAME not like '%scope%' AND SI_NAME not like '%:%' AND SI_NAME not like '%LOG%' ORDER BY SI_STARTTIME" -containers "yes" -columns "si_name, si_starttime, SI_STATUSINFO, si_parent_cuid" -selectedonly "yes" -csv "C:\Users\sapadmusr\Google Drive\Oficina de Gestión de Información\BI\Bases de Información\Falladas2.csv"
The goal is to extract the information of the error in an instance.
SI_STATUSINFO.SI_SUBST_STRINGS.1
You need to correct the -columns option from -columns "SI_NAME, SI_STARTTIME, SI_STATUSINFO, SI_PARENT_CUID"
to -columns "SI_NAME, SI_STARTTIME, SI_STATUSINFO.SI_SUBST_STRINGS.1, SI_PARENT_CUID"
The option -columns should provide a list of columns of the table that you want to keep in the result. SI_STATUSINFO is a container but there will be no column with the name SI_STATUSINFO in the table.
But I think it makes sense to make possible to select all columns corresponding to a container with the command that you use. We will add this in the next version. Many thanks for your question!
How can I use the option – container?
I am doing somenthing like this:
cmsquery-cmd.bat -username "Administrator" -auth "secEnterprise" -server "localhost" -password "" -sql "SELECT TOP 5000 si_name, si_starttime, si_parent_cuid FROM CI_INFOOBJECTS WHERE si_instance=1 and si_schedule_status=3 AND SI_ANCESTOR=154721 AND SI_NAME not like '%scope%' AND SI_NAME not like '%:%' AND SI_NAME not like '%LOG%' ORDER BY SI_STARTTIME" -containers "yes" -columns "si_name, si_starttime, SI_STATUSINFO, si_parent_cuid" -selectedonly "yes" -csv "C:\Users\sapadmusr\Google Drive\Oficina de Gestión de Información\BI\Bases de Información\Falladas2.csv"
The goal is to extract the information of the error in an instance.
SI_STATUSINFO.SI_SUBST_STRINGS.1
Hi Jesus,
You need to correct the -columns option from
-columns "SI_NAME, SI_STARTTIME, SI_STATUSINFO, SI_PARENT_CUID"to
-columns "SI_NAME, SI_STARTTIME, SI_STATUSINFO.SI_SUBST_STRINGS.1, SI_PARENT_CUID"The option -columns should provide a list of columns of the table that you want to keep in the result. SI_STATUSINFO is a container but there will be no column with the name SI_STATUSINFO in the table.
But I think it makes sense to make possible to select all columns corresponding to a container with the command that you use. We will add this in the next version. Many thanks for your question!
hello,
Thank you for providing such free software. And it has helped us a lot.
Is the CMS Query builder available for BO XI R2 versions ?
When I try to login using Windows AD I always get following error:
No LoginModules configured for com.businessobjects.security.jgss.initiate
Any ideas?
Works in 4.2 SP4
Thanks a lot!
Great software!
Is there a way how to extract more than 1000 rows?
You need to add TOP 10000 after SELECT. E.g. SELECT TOP 10000 * FROM ci_infoobjects WHERE si_kind=’Webi’