Skip to Content
avatar image
Former Member

CMS Query to get File Repository Server Properties

How to get the properties of File Repository Server using cms query?

(I can view FRS properties from console)

Any advice (sample links) would be much appreciated.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Aug 10, 2017 at 12:56 PM

    Start with this query:

    select si_hosted_services from ci_systemobjects where si_kind = 'server' and si_server_kind = 'fileserver'

    This will get you most of what you're looking for, although you'll have to search through the results. To get Max Idle Time, for example, search the page for "Maximum Idle Time". You'll find it in a SI_ML_DISPLAY_NAME property bag. There will be a sibling of that bag named SI_VALUE, which will contain the actual value for the setting.

    File directory is a bit more complicated. As above, you can search the page for "File Store Directory", and check in the associated SI_VALUE property. However, this will just display the same value that is displayed in the CMC -- if your FRS is set to use the default location, then this will be "%DefaultOutputFRSDir%" and "%DefaultInputFRSDir%". If you want to see the actual location (that is, what those placeholders are defined as), then you'll need another query:

    select si_placeholders from ci_systemobjects where SI_KIND='enterprisenode'

    Within this result, you'll find DefaultInputFRSDir and DefaultOutputFRSDir, along with the associated physical paths.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 11, 2017 at 02:07 PM

    QB queries that Joe provided should work if you are in BI 4.x. If you are looking for a specific property from CMC share us the screen capture of the same so that we can try to formulate the query for you.



    Add comment
    10|10000 characters needed characters exceeded

  • Aug 10, 2017 at 08:27 AM

    Hi Sarath,

    The following query will retrieve all of the properties and data associated with the File Repository servers:
    select * from ci_infoobjects,ci_systemobjects,ci_appobjects where si_description like '%File Repository%'

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member


      Thanks much for the reply..

      I executed the above query but I didn't get the properties of FRS.

      (eg. if I select a Crystal File Repository Server through Console then I can see the properties like Root Directory and Maximum Idle Time under "Properties" tab.Can we get these details from query?)

  • avatar image
    Former Member
    Aug 15, 2017 at 01:05 PM

    Hi Mani,

    Currently we are using Business Objects 4.2.our Input and Output file repositories in CMC showing danger status(Red) also checked in Monitoring, showing lesser disk space. Can you suggest us how to increase the disk space in servers.



    Add comment
    10|10000 characters needed characters exceeded