Hello Bill, When using the wizard, there is no option to add clauses or commands like "Alter Table", "RENAME COLUMN" or "AS" to rename a co
When using the wizard, there is no option to add clauses or commands like "Alter Table", "RENAME COLUMN" or "AS" to rename a column on syntax, the best option will be to create this report using the SQL option which gives you more flexibility to create a customized query as desired.
This might also be a good enhancement for the KACE SMA Reporting module, feel free to submit this idea in our KACE UserVoice portal https://kace.uservoice.com/ so it might get included in a future releases.
--------------- Original Message ---------------
From: Bill Ameeri [email@example.com]
Sent: 8/26/2022 3:11 PM
Subject: RE: New Case | Case Number: 01836772
I created a report using the wizard…i added all the columns and for the ip address column, I want to add a translation so for example if ip address contains 10.20 then name = school name. I want the school name to display instead of the ip address for ease of use of the report.