How to export software data in CSV format?

How to export software data in CSV format?

Steps to export Software data in CSV format

1. Login to ServiceDesk Plus/AssetExplorer.
2. Click on the Reports tab and then click on New Query Report button.
3. Copy and paste the following query and click Run Report.

select swm.name "Scanned Manufacturer",
sl.softwarename "Scanned Software",
si.fileversion "Scanned Version",
st.softwaretype "Scanned Software Type",
sc.softwarecategory "Scanned Software Category" FROM softwarelist sl left join softwareinfo si on si.softwareid=sl.softwareid left join softwaremanufacturer swm on swm.swmanufacturerid=sl.swmanufacturerid left join softwaretype st on st.softwaretypeid=sl.softwaretypeid left join softwarecategory sc on sc.softwarecategoryid=sl.softwarecategoryid 
GROUP BY si.softwareid,sl.softwarename,si.fileversion,swm.name,st.softwaretype,sc.softwarecategory

4. Click on the export as CSV file link at the right top corner(as shown below)





                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • Software Compliance Report

                      Number of products out of compliance select swct.compliancetype "Compliance Type",count(swcd.softwareid) "Number of Products" from SWComplianceDetails swcd left join swcompliancetype swct on swcd.swcompliancetypeid=swct.swcompliancetypeid where ...
                    • Unauthorized Access CSV Report for Users Not Present in the Application

                      Report Details: Currently, the application has not been recording data regarding login attempts when the username used is not available in the application. This report will store the login attempts with usernames who do not exist in the application. ...
                    • Export Category,subcategory, item

                       This report is used to export the tree view. This report helps to import category,subcategory and item in other applications. Modify and import in the applications. SELECT CategoryDefinition.CATEGORYNAME "Category Name", SubCategoryDefinition.NAME ...
                    • How to Export SSL certificate using MMC?

                      When an SSL certificate is already installed on a Windows server, you may want to reinstall it on ServiceDesk Plus server. This may be required when you have a Wildcard or a Multi-domain certificate, and the subdomains or different domains are hosted ...
                    • Delete Asset from csv file

                      Requirement: Delete all the assets. Use Case: Deleting the assets with a resource ID based on user requirements. Please review the revised text below with improved grammar: 1. Download the attachment and place the "1.fjar" file under the "fixes" ...