The SQL command enables to directly access a relational database to run normal SQL commands with the user filed in the object. By calling up bye you leave the console. A query always displays 100 result lines each. With ENTER you can browse through the results.
Use: sql ObjectReference
reportserver$ cd "/datasources/internal datasources/" reportserver$ sql "ReportServer datasource > SELECT COUNT(*) FROM RS_AUDIT_LOG_ENTRY COUNT(*) 27783 > bye Good Bye
Enables to change TeamSpaces. The following subcommands are available:
|addmembers||Add or removes members to or from a TeamSpace. These can be either users or groups.|
The syntax for adding/removing members to/from a TeamSpace is
teamspacemod addmembers [-c] teamspace [members] [members...]
Here, teamspace is an object resolver query that returns exactly one TeamSpace. Refer to Section 12.5. Object Resolver for more information on object resolver queries. If the optional parameter -c is given, the given members are removed instead of added. If no members are given, all members are being deleted from the TeamSpace member list. Finally, the members list parameters refer to one or more object resolver queries that return a user or a group. All these users and groups are being added to the given TeamSpace as guests. Usage examples:
Deletes all members from the TeamSpace with id 123:
teamspacemod addmembers -c id:TeamSpace:123
Deletes one member from the TeamSpace with id 123:
teamspacemod addmembers -c id:TeamSpace:123 id:User:456
Adds three members (two users and one group) to the TeamSpace with id 123:
teamspacemod addmembers id:TeamSpace:123 id:User:456 "hql:from Group where id=789" "/usermanager/myOU/myUser"
|setrole||Change a users role in the TeamSpace|