get the BOBJ version using query builder statement

[former_member332039]

Hi

I wonder if there is a sentence (SLECT * FROM ...) from query builder to obtain the business objects version, patch level and operating system.

I have the Java SDK, and I need to develop an app for scan a list o BOBJ servers and get at least their versions.

thanks in advance.

Eusebio Martinez

[former_member250633]

If you execute the following query:
select SI_METRICS from CI_infoobjects, CI_appobjects, CI_systemobjects where SI_NAME='BIPW12R2.CentralManagementServer'

In the results in query builder,
under SI_METRICS property bag,
SI_NAME=ISPROP_GEN_VERSION records the product version

SI_NAME=ISPROP_GEN_MACH_OSNAME records the OS

However, It is not possible to write nested queries in Query Builder.

You may use SDK to retrieve these nested properties.

Thanks,
Kamiya

[former_member332039]

Kamiya,

thank you very much, it worked..!

Eusebio Martinez.