Query to get software data in CSV format.

Query to get software data in CSV format.

Steps to export Software data in CSV format

1. Login to ServiceDesk Plus MSP/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 ADSelfService Plus?

                    • Related Articles

                    • 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 ...
                    • How to migrate data from SDP to SDP MSP.

                      Below are the only details which can be exported from SDP and imported to SDP MSP application. 1) You can export request data from ServiceDesk Plus (SDP) using XLS format. Requests -> Goto Admin -> Reports -> New custom report -> Tabular reports -> ...
                    • Query report to get the successfully scanned assets (MSSQL & PGSQL)

                      Tested in builds from PGSQL (14300) or MSSQL (14306) Query report to get the successfully scanned assets with audit status, state , Serial no and site. SELECT max(resource.resourcename) "Asset Name", max(resource.SERIALNO) AS "Org Serial Number", ...
                    • Asset Ownership History Report

                      Please use the below query to get the report on Asset Ownership History. SELECT r.resourcename AS "Workstation Name", ct.componenttypename AS "Product type", rs.displaystate AS "Asset State", aa.first_name AS "Assigned User", LONGTODATE(sh.starttime) ...
                    • MSP - Remote Asset Explorer Compatible Versions

                      Remote Asset Explorer-MSP Compatible Version From MSP 14000 - Compatible RAE version 6970-6985 From MSP 13000 - Compatible AE version (6900-6979). But RAE - DC integration, - If 6900,6901 RAE is used, then latest DC will not work. Bundled DC in RAE ...