Windows Professional / Enterprise Report

[brianraley]

Is there a way to create a report that will delineate between Windows Enterprise and Professional OS installations?

[Hemoco · Accepted solution]

Please use the following report:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption
From tblAssets
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where (tblOperatingsystem.Caption Like '%professional%') Or
(tblOperatingsystem.Caption Like '%enterprise%')

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.