MicroStrategy ONE

List Fences Statements

List all fences or all properties of a specific fence.

Copy
LIST [ALL] PROPERTIES FOR FENCE name;
Copy
LIST [ALL] FENCES;

where:

name is the name of the fence.

Examples

Copy
LIST ALL PROPERTIES FOR FENCE "fence2";
Copy
LIST ALL FENCES;

ResultSet Columns

LIST [ALL] PROPERTIES FOR FENCE name;

  • NAME: The name of the fence, returned as a string.
  • TYPE: The type of the fence, returned as a string.
  • USER_RESULTSET: A ResultSet containing a list of users or user groups inside the fence and related details.

    • NAME: The name of the user / user group, returned as a string.
    • IS_GROUP: Specifies if the NAME is a user group, returned as a Boolean value.
  • FENCE_NODE_RESULTSET: A ResultSet containing a list of nodes included in the fence.

    • NAME: The name of the node, returned as a String.
  • PROJECTS: A ResultSet containing a list of projects included in the fence.

    • NAME: The name of the project, returned as a String.
  • FENCE_PRECEDENCE: The order of the fence in the fence list, returned as a integer.

LIST [ALL] FENCES;

  • NAME: The name of the fence, returned as a string.
  • TYPE: The type of the fence, returned as a string.