There may be occasion where you obtain a query, written in SQL that you would like to run as a report within your appliance. This document demonstrates how to take that query and get a report out of it.
Some places where you might obtain a query:
select P.TITLE AS DISPLAY_NAME, MACHINE.NAME as ComputerName, SYSTEM_DESCRIPTION, IP, MAC, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as USER_LOGGED, CS_DOMAIN from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P where MACHINE.ID = S.MACHINE_ID and S.PATCHUID = P.UID and S.STATUS='PATCHED' order by P.TITLE
However, you can still change some things. If you wanted to change something you can go back into a report editor by simply finding the report in the list of reports and click on the title.
Something that you might want to change is that certain columns only have a couple of different values and most results will show up with one value or another. In these cases it can be great to move the row to show-up as a section in the report instead of as a column.
For the patching SQL example, since we are listing each patch and given a report of the machines that have it there are going to be up to hundreds of machines in a given patch name. So we could have a section that lumps all those related records.
Find the report in the list view and click on one of the formats to view the results (ie HTML, CSV, Excel, PDF, etc)