Chapter 22: Generating and Viewing Reports in Report Center
Report Center Reference
AdminStudio 9.5 User Guide
ADS-0950-UG00
1725
Reports Wizard
Using the Reports Wizard, you can generate a Custom SQL Query report. See
Generating a Custom SQL Query
Report for AdminStudio
and the
Enter SQL Query Panel
.
Select Report Type Panel
On the
Select Report Type Panel
of the Reports Wizard, select one of the following options:
Enter SQL Query Panel
On the
Enter SQL Query Panel
of the
Custom SQL Query Reports Wizard
, enter an SQL query to retrieve the
data for this report. Click the
Test Query
button to verify the query syntax, and click
Next
to proceed.
Wildcard Support in Report Center SQL Queries
In Report Center searches, the
LIKE
operator is always used. You can combine the
LIKE
operator with a wildcard
character, and the following rules apply:
Table 22-38 •
Select Report Type Panel Options
Option
Description
Custom Report
Select to create a custom report.
Activity Report
Select to create report that exclusively lists Application Request activities.
Custom SQL Query
Report
Select to create a custom report defined by entering an SQL query in the Report
Wizard.
Table 22-39 •
Wildcard Support in Report Center Queries
Situation
Rule
When no
wildcards are
used
If you do not enter a wildcard character in the
Search
box, then Report Center performs
a “LIKE” search, which searches for any occurrence of that text anywhere in the item
that is being searched for.
For example, if you are searching for a file name that has the word
test
anywhere in the
file name, and you entered
test
in the
Search
box, it would be interpreted by Report
Center as:
*test*
And the following files would be found:
MyTestFile and TestFile
Summary of Contents for ADMINSTUDIO 9.5
Page 1: ...AdminStudio 9 5 User Guide Version 9 5...
Page 50: ...Contents 50 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 52: ...52 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 156: ...156 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 440: ...440 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1090: ...1090 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1426: ...1426 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1686: ...1686 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1794: ...Chapter 24 AdminStudio Public API Reference 1794 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1842: ...Index 1842 ADS 0950 UG00 AdminStudio 9 5 User Guide...
