→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

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.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now