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 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 ...Query to extract the “Software-License Additional Fields” along with the existing additional fields (PGSQL)
(Applicable for builds 14300 & above) Below query has been modified to add a LEFT JOIN between the additional fields table and the table from which you extracted the softwares: QUERY: SELECT SUM(scd.ALLOCATED) AS "Allocated", ...