Advanced reports can be created through manual SQL coding. Virtually any reporting option is available if you know the database
schema. Clicking
Advanced Query hides the query string list boxes and opens the
Report data query field in which you can insert existing code or write new SQL code.
Restriction: The SQL statement
select top is not supported. It is not possible to report directly on tables which return user information from
Silk Central, for example SCC_Users, SCC_AuditEntries, SCC_UserGroups, and SCC_UserGroupRoles.
One approach is to begin query-string construction using the list boxes as outlined in
Creating New Reports. If the report criteria are valid, the equivalent SQL statement will be generated and displayed, and then move to advanced
mode for further modifications.
Note: If you switch from advanced mode back to simple mode the changes you made within the code will be lost.
To write an advanced query directly in SQL: