→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DMermod
Engaged Sweeper
What is the major difference between these two reports?

I have an audit coming up that requires me to show all versions of SQL installed that require a license. Which report would benefit me more?

Thank you,

- DRM
3 REPLIES 3
DMermod
Engaged Sweeper
Stimpy_555,

I will definitely try this report out. I like the idea of modifying the report to show the processors as well. Very good point!

Also, thanks for taking the time to throw together a report for me to start from.

- DRM
stimpy_555
Engaged Sweeper III
Use LansweeperDB
Select dbo.tblAssets.AssetName
,dbo.tblAssets.Domain
,dbo.tsysOS.OSname
,dbo.tblSqlServers.displayVersion As Edition
,dbo.tblSqlServers.skuName As License
,dbo.tblSqlServers.spLevel As SP
,dbo.tblSqlServers.serviceName As Service
,dbo.tblSqlServers.lastChanged
,dbo.tblComputerSystem.NumberOfLogicalProcessors
,dbo.tblComputerSystem.NumberofProcessors
,dbo.tblComputerSystem.SystemType

From dbo.tblAssets
Inner Join dbo.tblAssetCustom On dbo.tblAssets.AssetID = dbo.tblAssetCustom.AssetID
Inner Join dbo.tsysOS On dbo.tblAssets.OScode = dbo.tsysOS.OScode
Inner Join dbo.tblSqlServers On dbo.tblAssets.AssetID = dbo.tblSqlServers.AssetID
Left Join dbo.tblComputerSystem on dbo.tblAssets.AssetID = dbo.tblComputerSystem.AssetID

Where dbo.tblSqlServers.skuName in ('Standard Edition', 'Standard Edition (64-bit)', 'Enterprise Edition', 'Enterprise Edition (64-bit)')

Order By dbo.tblAssets.AssetName

Regards
stimpy_555
Engaged Sweeper III
I myself would use the "All SQL Server Editions" report to show the license used as this is what determines what you need to purchase. I would alo update this report to show Physical Processors and Logical processors.

AS this information is now critical to a license audit on the newer versions of SQL that you may need to purchase as part of your Microsoft Licensing agreement.

Regards

New to Lansweeper?

Try Lansweeper For Free

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

Try Now