→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
teejayuu
Engaged Sweeper
Hello,

Is there a way I can export Software license compliance and OS license to Excel/CSV etc?

Thanks
Tony
Tony In view of the fact that God limited the intelligence of man, it seems unfair that He did not also limit his stupidity. Konrad Adenauer
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
try this:

SELECT dbo.web40licenseview.LicenseidID, dbo.web40licenseview.License, dbo.web40licenseview.Nrlicenses, dbo.web40licenseview.Priceperlicense,
dbo.web40licenseview.Missing, dbo.web40licenseview.Price, dbo.web40licenseview.[number in use], dbo.tblsublicenses.softwareName,
dbo.web40usedsoftware.softwareVersion, dbo.web40usedsoftware.SoftwarePublisher, dbo.web40usedsoftware.[number in use] AS Subtotal
FROM dbo.web40licenseview INNER JOIN
dbo.tblLicenses ON dbo.web40licenseview.LicenseidID = dbo.tblLicenses.LicenseidID LEFT OUTER JOIN
dbo.web40usedsoftware INNER JOIN
dbo.tblsublicenses ON dbo.web40usedsoftware.softwareName = dbo.tblsublicenses.softwareName AND
ISNULL(dbo.web40usedsoftware.softwareVersion, '') LIKE ISNULL(dbo.tblsublicenses.softwareVersion, '') ON
dbo.tblLicenses.LicenseidID = dbo.tblsublicenses.LicenseidID
ORDER BY dbo.web40licenseview.License, dbo.tblsublicenses.softwareName, dbo.web40usedsoftware.softwareVersion

View solution in original post

2 REPLIES 2
Hemoco
Lansweeper Alumni
try this:

SELECT dbo.web40licenseview.LicenseidID, dbo.web40licenseview.License, dbo.web40licenseview.Nrlicenses, dbo.web40licenseview.Priceperlicense,
dbo.web40licenseview.Missing, dbo.web40licenseview.Price, dbo.web40licenseview.[number in use], dbo.tblsublicenses.softwareName,
dbo.web40usedsoftware.softwareVersion, dbo.web40usedsoftware.SoftwarePublisher, dbo.web40usedsoftware.[number in use] AS Subtotal
FROM dbo.web40licenseview INNER JOIN
dbo.tblLicenses ON dbo.web40licenseview.LicenseidID = dbo.tblLicenses.LicenseidID LEFT OUTER JOIN
dbo.web40usedsoftware INNER JOIN
dbo.tblsublicenses ON dbo.web40usedsoftware.softwareName = dbo.tblsublicenses.softwareName AND
ISNULL(dbo.web40usedsoftware.softwareVersion, '') LIKE ISNULL(dbo.tblsublicenses.softwareVersion, '') ON
dbo.tblLicenses.LicenseidID = dbo.tblsublicenses.LicenseidID
ORDER BY dbo.web40licenseview.License, dbo.tblsublicenses.softwareName, dbo.web40usedsoftware.softwareVersion
teejayuu
Engaged Sweeper
...or create a report that mimics this?
Tony In view of the fact that God limited the intelligence of man, it seems unfair that He did not also limit his stupidity. Konrad Adenauer