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.
Here, datasource is an object resolver query that returns exactly one datasource of type DatabaseDatasource. Refer to Section 13.5. Object Resolver for more information on object resolver queries.
reportserver$ cd "/datasources/internal datasources/" reportserver$ sql "ReportServer Data Source" > SELECT COUNT(*) FROM RS_AUDIT_LOG_ENTRY COUNT(*) 27783 > bye Good Bye
Use: sql datasource
Checks if a given table exists in a given datasource. Here, datasource is an object resolver query that returns exactly one datasource. Refer to Section 13.5. Object Resolver for more information on object resolver queries.
The following example checks if the ''T_AGG_CUSTOMER'' table exists in the datasource with id 123.
tableExists id:DatasourceDefinition:123 T_AGG_CUSTOMER
Use: tableExists datasource table
Allows you to test your SSL configuration. For example, the following allows you to test a HTTPS connection to www.google.com:
ssltest www.google.com 443
In case you installed a server's certificate, for example for LDAPS or LDAP StartTLS, this command is useful for testing the installed certificate analogously as shown below:
ssltest ipOrHostOfYourServer 10389
Use: ssltest host port
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 13.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|