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 ...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) ...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 -> ...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. ...