I want to create a KACE Report on my Knowledgebase data. I have the following query for a basic report however, I don't know the database column for the knowledgebase field labeled on the form as "TEXT". If someone could provide that for me, that would be great. Thanks
select CONCAT('KB:0000',ADVISORY.ID) as 'Article ID', ADVISORY.TITLE as Title, ADVISORY.CATEGORY as Category, ADVISORY.PLATFORM as Platform, ADVISORY.IMPORTANCE as Importance ,(select round(coalesce(avg(RATING), 0), 2) as AVERAGE_RATING from ADVISORY_RATINGS where ADVISORY_ID = ADVISORY.ID) as Rating, PAGE_VIEWS as 'Page Views', PAGE_VOTES as 'Page Votes', ADVISORY.CREATED as Created, ADVISORY.MODIFIED as Modified from ADVISORY
left join ADVISORY_LABEL_JT on ADVISORY_LABEL_JT.ADVISORY_ID = ADVISORY.ID
left join LABEL on LABEL.ID = ADVISORY_LABEL_JT.LABEL_ID
where (1 = 1) and ((ADVISORY_LABEL_JT.LABEL_ID = 0)
or (ADVISORY_LABEL_JT.LABEL_ID is NULL)
or (ADVISORY_LABEL_JT.LABEL_ID in
(select LABEL_ID
from USER_LABEL_JT
where USER_ID = 1268)))
group by ADVISORY.ID order by TITLE
