For support reasons sometimes we ask you to run some SQL. To get to our SQL Administrator tool (often called SQL tool for short)

Finding and running the SQL Administrator Tool

Then find the SQL Administrator tool in the Configuration list.

or

In the SQL Administrator tool

On the SQL Admin tool screen, the Query tab is where you paste the SQL you were given. Then typically hit the "Execute" button, which in many cases will show you some results below it.

If you are expecting more than 20 rows in your results, you may want to set the Max rows to Return higher. The max is set in case you enter some SQL that takes a very long time per row to return so it doesn't 'kill' the server with overload or bog down your internet connection too long.

Getting the results out of the tool

One you get some results, you can copy or save the results somewhere.

You can copy to the clipboard in several formats: JSON or CSV are usually the most useful formats - decide depending on your preference or what you were asked to do.

Or you can save it to a file you can open or email. In general XLXS for most purposes is highly convenient and we do some default column widths based on data type that give you a good starting point for viewing the data.

Getting Access to the SQL Admin Tool:

If you don't see the SQL Administrator tool, it is because you have not been given permission to see it. Permission can be set by anyone your organization has given rights to the Access Manger license:

To get to change the preferences you have to have access to the "Access Manager"

Getting access to the Access Manager license so that you can get access to the SQL Admin tool

The default OOB (Out of Box) is 'all' but your system probably has it shut down to an access group or two or a handful of users. We (and you) can't see who if you don't have access to this screen, but your IT or EAM administrator should know who.