MicroStrategy ONE

List VLDB Settings statement

Lists all VLDB properties for the specified object.

Copy 
LIST VLDBSETTINGS [GROUP "groupname1 [, 
 ... groupnameN"]] | PROPERTYNAMES "propertyname1" 
 [, ... "propertynameN"]] FOR ((REPORT | METRIC | ATTRIBUTE | TEMPLATE) 
 "objectname" IN FOLDER "folder" IN PROJECT "project_for_object" | DBINSTANCE "dbinstance" | PROJECT "project");

where:

  • GROUP "groupname1..N" are the VLDB property groups that are to be listed.

  • PROPERTYNAMES "propertyname1..N" are the names of the VLDB properties that are to be listed.

  • REPORT "objectname" is the report whose VLDB properties are to be listed, of type string.

  • METRIC "objectname" is the metric whose VLDB properties are to be listed, of type string.

  • ATTRIBUTE "objectname" is the attribute whose VLDB properties are to be listed, of type string.

  • TEMPLATE "objectname" is the template whose VLDB properties are to be listed, of type string.

  • FOLDER "folder" is the location of the object

  • PROJECT "project_for_object" is the project where the object is located

  • DBINSTANCE "dbinstance" is the name of the dbinstance whose VLDB properties are to be listed, of type string.

  • PROJECT "project" is the name of the project whose VLDB properties are to be listed, of type string.

ResultSet Columns

LIST VLDBSETTINGS PROPERTYNAMES

  • VLDB_PROPERTY_NAME: The name of the property, returned as a string.

  • VLDB_PROPERTY_USE_DEFAULT_VALUE: Whether or not the property is set to its default value, returned as a boolean value.

  • VLDB_PROPERTY_VALUE: The value of the property, returned as a string.

LIST VLDBSETTINGS FOR PROJECT

  • VLDB_PROPERTY_GROUP: A ResultSet containing a list of properties associated with a group.

    • VLDB_PROPERTY_NAME: The name of the property, returned as a string.

    • VLDB_PROPERTY_USE_DEFAULT_VALUE: Whether or not the property is set to its default value, returned as a boolean value.

    • VLDB_PROPERTY_VALUE: The value of the property, returned as a string.

  • VLDB_PROPERTY_GROUP_NAME: The group name associated with the project, returned as a string.

LIST VLDBSETTINGS GROUP  

  • VLDB_PROPERTY_GROUP: A ResultSet containing a list of properties associated with a group.

    • VLDB_PROPERTY_NAME: The name of the property, returned as a string.

    • VLDB_PROPERTY_USE_DEFAULT_VALUE: Whether or not the property is set to its default value, returned as a boolean value.

    • VLDB_PROPERTY_VALUE: The value of the property, returned as a string.

  • VLDB_PROPERTY_GROUP_NAME: The group name associated with the project, returned as a string.