About SQL Reporting

Umbria's SQL Reporting is a powerful but easy-to-use tool that allows you to run SQL queries against the Umbria database, the time and billing system database (Elite, CMS, etc.) or any other database. You can view the results onscreen or export to a variety of mediums.

Permissions

The following security permissions relate to SQL Reporting:

• USER_SQL_REPORTING- Allows end-user access to SQL Reporting and the ability to view/execute queries.
• SQL_ANALYTIC- Grants admin access to the tool, including ability to update/insert/delete and configure the queries and connections. This should be assigned to administrators or advanced power users who will be working with SQL.

Accessing SQL Reporting

There are two ways you can access the SQL Reporting tool:

• Select Sql Reporting from the User Menu.
• Access the Sql Reporting on the top right corner of the Admin Page.

SQL Reporting User Interface

The table below lists and describes the primary components of the SQL Reporting screen.

Field/Section	Description
New Query button	Add a new query or click the drop-down button to add a new connection or category.
Search field	Connection string look up.
Edit button	Edit a connection string.
Menu	Display the list of categories, connections, generic look ups, and import or export. It includes: Return to Umbria Go to the Admin module View/edit Categories View/edit Connection Strings View/Add Generic Lookups (for parameters) Import Default Queries (the Umbria out-of-the-box queries) Import Queries (Umbria Reporting queries from another system or created elsewhere) Export Queries Sign out of Umbria
Queries tab	This tab includes all SQL DB non-utility queries. You can filter by category or use the search field to search for a particular query.
Utility Queries tab	Contains all the out-of-the-box utility queries that are useful for information gathering or finding the status of a particular DB.
Recent Visited Queries tab	All of the recently used or edited queries display here.