Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pwalach
Engaged Sweeper III
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?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

2 REPLIES 2
pwalach
Engaged Sweeper III
Awesome, thank you, worked great!
Hemoco
Lansweeper Alumni
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.

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now