Generating 'Scanned Software' reports
I am looking to generate a scanned software report. Currently, I am using the following query:
select SOFTWARENAME,SOFTWARETYPE,PRODUCTVERSION,COMPANYNAME,WORKSTATIONNAME from SoftwareList sl LEFT JOIN SoftwareInfo si ON sl.SOFTWAREID=si.SOFTWAREID LEFT JOIN SoftwareType st ON sl.SOFTWARETYPEID=st.SOFTWARETYPEID LEFT JOIN SystemInfo sys ON si.WORKSTATIONID=sys.WORKSTATIONID order by 1
However, the CSV export this query generates is not in a database-friendly format. Is it possible generate a 'Scanned Software' report and export to CSV which can be used in a database? Thanks