QueryBuilder and SI_PROCESSINFO

security CMC
1

I’ve been researching my question for some time now and would like to double check what I think I know.

I’m trying to pull information from Processing Info.

This works…

 SELECT TOP 1 SI_ID, SI_NAME, SI_PROCESSINFO
 FROM CI_SYSTEMOBJECTS, CI_APPOBJECTS, CI_INFOOBJECTS
 WHERE SI_KIND = 'Excel'

…but this does not work, where I stick SI_PATH at the end of SI_PROCESSINFO.

 SELECT TOP 1 SI_ID, SI_NAME, SI_PROCESSINFO.SI_PATH
 FROM CI_SYSTEMOBJECTS, CI_APPOBJECTS, CI_INFOOBJECTS
 WHERE SI_KIND = 'Excel'

Is there a way for me to pull out on SI_PATH information without using the SDK?

Thanks,
Rob
SI_PATH.jpg

wubertatwork :us: (BOB member since 2011-01-19)

2

SI_PROCESSINFO is a field of type ‘property bag’

Unfortunately you can’t get at the individual key pair items of a property bag field through the query.

You need to use the SDK, or perhaps use one of the tools like CMS Query Builder from BI Clever that allows you to run queries and export them as Excel and CSV.

Hayden_Gill :australia: (BOB member since 2002-08-15)

3

Hi Hayden,

Thank you for the confirmation, and clarification.

Best,
Rob

wubertatwork :us: (BOB member since 2011-01-19)