This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Export Software License Compliance

Go to solution
teejayuu
Engaged Sweeper

‎07-25-2011 12:44 PM

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
Labels:
0 Kudos
1 ACCEPTED SOLUTION
Go to solution
Hemoco
Lansweeper Alumni

‎08-02-2011 01:11 PM

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
Go to solution
Hemoco
Lansweeper Alumni

‎08-02-2011 01:11 PM

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
Go to solution
teejayuu
Engaged Sweeper

‎07-26-2011 02:57 PM

...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
0 Kudos

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now