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.