This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Community FAQ
Register | Log In
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- Reports & Analytics
- Re: Need A Report Summarizing # of Windows 7 Profe...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
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.
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