Need A Report Summarizing # of Windows 7 Professional Clients

[pwalach]

I am very new to SQL and am trying to get a report of all of the Computers that have Windows 7 Professional on our network. Currently, the report I have gives me a summary of all the computers running any version of Windows 7, whether it's Professional or Enterprise. I need just those with Windows 7 Professional. What am I doing wrong?

[pwalach]

Awesome, thank you, worked great!

[Hemoco · Accepted solution]

Please use the following report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption
From tblOperatingsystem
Inner Join tblAssets On tblAssets.AssetID = tblOperatingsystem.AssetID
Where (tblOperatingsystem.Caption = 'Microsoft Windows 7 Professional') Or
(tblOperatingsystem.Caption = 'Microsoft Windows 7 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.