
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-25-2014 05:11 PM
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?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-26-2014 06:10 PM
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.
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.
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-26-2014 06:13 PM
Awesome, thank you, worked great!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-26-2014 06:10 PM
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.
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.
