After selecting a software in the Inventory Software page and clicking, Choose Action, then create report. An error will appear when saving the report:
mysqli error: [1054: Unknown column 'HAS_FILE' in 'order clause'] in EXECUTE( "select DISPLAY_NAME, PUBLISHER, DISPLAY, VERSION, (select count(distinct MACHINE_ID) from MACHINE_SOFTWARE_JT WHERE SOFTWARE_ID=SOFTWARE.ID) as MACHINES_AFFECTED from SOFTWARE left join SOFTWARE_LABEL_JT on SOFTWARE_LABEL_JT.SOFTWARE_ID = SOFTWARE.ID left join LABEL on LABEL.ID = SOFTWARE_LABE_JT.LABEL_ID where (1 = 1) group by SOFTWARE.ID order by HAS_FILE desc, DONT_REPLICATE desc, DISPLAY_NAME asc LIMIT 0")
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center