Lansweeper 5.0 - "Role: SQL Server" vs "Software: All SQL server editions" repor

[DMermod]

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

[DMermod]

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]

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]

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