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 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.

Regards,

Ariel Vega
Quest

--------------- Original Message ---------------
From: Bill Ameeri [bill.ameeri@omsd.net]
Sent: 8/26/2022 3:11 PM
To: support@quest.com
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.
Bill