Software
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 ...
License agreement
SELECT DISTINCT licenseagreement.agreementnumber "Agreement Number", softwaremanufacturer.NAME "Manufacturer", Longtodate(licenseagreement.acquisitiondate) "Acquisition Date", ...
Software Licenses
SELECT resource.resourcename "License Name", Max(softwarelist.softwarename) "Software_Name", Max(resource.acquisitiondate) "Acquisition Date", ...
Unlicensed
SELECT systeminfo.workstationid, systeminfo.workstationname "Workstation", aaauser.first_name "UserName", softwarelist.softwarename "Software Name", ...
Specific Software
SELECT ( softl.softwarename ) "Software Name", Max(workstation.workstationname) "Workstation", Max(workstation.model) "Model", Max(aaauser.first_name) "User", ...
License key
SELECT ( systeminfo.workstationname ) "Workstation", ( net.ipaddress ) "IP Address", ( softl.softwarename ) "Software Name", ( softwarelicenses.licensekey ) "LicenseKey" FROM softwareinfo ...
Software Not installed machines
SELECT Max(workstation.workstationname)"Machine Name", Max(aaauser.first_name) "User" FROM systeminfo workstation LEFT JOIN resources rs ON workstation.workstationid = rs.resourceid LEFT JOIN softwareinfo si ...
Software details
SELECT systeminfo.workstationname "Workstation", Max(aaauser.first_name) "User", ( softwarelist.softwarename ) "Software_Name", Max(softwaretype.softwaretype) "Software_Type", ...
Workstation and installed software
SELECT systeminfo.workstationname "Workstation", ( softwarelist.softwarename ) "Software_Name", Max(swmfg.NAME) "Manufacturer", Max(softwareinfo.fileversion) "Version" FROM softwareinfo ...