Notification

Icon
Error

Windows 10 Pro

Posted: Friday, April 9, 2021 7:37:51 PM(UTC)
dc74

dc74

Member Original PosterPosts: 5
0
Like
This issue has been solved! Click here to view the solution
I'm attempting to create a report containing all Windows 10 Pro operating systems, as we need to upgrade them to Enterprise. I've tried a number of SQL variables related to the OS but so far have had no luck returning a successful report. What's the best way to find all Windows 10 Pro machines on my network?
Brandon
#1Brandon Member Posts: 139  
posted: 4/9/2021 8:12:17 PM(UTC)
Try this and see if it gives you the information you need.

Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblComputersystem.Lastchanged,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join lansweeperdb.dbo.tblOperatingsystem On tblAssets.AssetID =
tblOperatingsystem.AssetID
Where tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName


Originally Posted by: dc74 Go to Quoted Post
I'm attempting to create a report containing all Windows 10 Pro operating systems, as we need to upgrade them to Enterprise. I've tried a number of SQL variables related to the OS but so far have had no luck returning a successful report. What's the best way to find all Windows 10 Pro machines on my network?


dc74
#2dc74 Member Original PosterPosts: 5  
posted: 4/9/2021 8:15:19 PM(UTC)
Originally Posted by: Brandon Go to Quoted Post
Try this and see if it gives you the information you need.

Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblComputersystem.Lastchanged,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join lansweeperdb.dbo.tblOperatingsystem On tblAssets.AssetID =
tblOperatingsystem.AssetID
Where tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName


Originally Posted by: dc74 Go to Quoted Post
I'm attempting to create a report containing all Windows 10 Pro operating systems, as we need to upgrade them to Enterprise. I've tried a number of SQL variables related to the OS but so far have had no luck returning a successful report. What's the best way to find all Windows 10 Pro machines on my network?




This gives me all of our Windows machines, I need the report to give me only those running Windows 10 Pro.
Brandon
#3Brandon Member Posts: 139  
posted: 4/9/2021 8:19:29 PM(UTC)
This should now only show Windows 10 pro.

Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblComputersystem.Lastchanged,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join lansweeperdb.dbo.tblOperatingsystem On tblAssets.AssetID =
tblOperatingsystem.AssetID
Where tblOperatingsystem.Caption = 'Microsoft Windows 10 Pro' And
tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName


Originally Posted by: dc74 Go to Quoted Post
Originally Posted by: Brandon Go to Quoted Post
Try this and see if it gives you the information you need.

Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblComputersystem.Lastchanged,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join lansweeperdb.dbo.tblOperatingsystem On tblAssets.AssetID =
tblOperatingsystem.AssetID
Where tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName


Originally Posted by: dc74 Go to Quoted Post
I'm attempting to create a report containing all Windows 10 Pro operating systems, as we need to upgrade them to Enterprise. I've tried a number of SQL variables related to the OS but so far have had no luck returning a successful report. What's the best way to find all Windows 10 Pro machines on my network?




This gives me all of our Windows machines, I need the report to give me only those running Windows 10 Pro.


dc74
#4dc74 Member Original PosterPosts: 5  
posted: 4/9/2021 8:42:31 PM(UTC)
Originally Posted by: Brandon Go to Quoted Post
This should now only show Windows 10 pro.

Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblComputersystem.Lastchanged,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join lansweeperdb.dbo.tblOperatingsystem On tblAssets.AssetID =
tblOperatingsystem.AssetID
Where tblOperatingsystem.Caption = 'Microsoft Windows 10 Pro' And
tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName


Originally Posted by: dc74 Go to Quoted Post
Originally Posted by: Brandon Go to Quoted Post
Try this and see if it gives you the information you need.

Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption,
tblComputersystem.Lastchanged,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join lansweeperdb.dbo.tblOperatingsystem On tblAssets.AssetID =
tblOperatingsystem.AssetID
Where tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName


Originally Posted by: dc74 Go to Quoted Post
I'm attempting to create a report containing all Windows 10 Pro operating systems, as we need to upgrade them to Enterprise. I've tried a number of SQL variables related to the OS but so far have had no luck returning a successful report. What's the best way to find all Windows 10 Pro machines on my network?




This gives me all of our Windows machines, I need the report to give me only those running Windows 10 Pro.




Yeah that did it, thanks for the quick assistance!

Active Discussions

Installer Install .Net Framework 4.7.2
by  John B Fairbrother   Go to last post Go to first unread
Last post: 5/6/2021 4:58:23 PM(UTC)
Installer Sophos Silent Install
by  Craig  
Go to last post Go to first unread
Last post: 4/14/2021 8:09:58 PM(UTC)
Installer Say what you write
by  RobertoP   Go to last post Go to first unread
Last post: 3/31/2021 1:30:54 PM(UTC)
Installer Uninstall KB5000802
by  CyberCitizen  
Go to last post Go to first unread
Last post: 3/25/2021 7:51:14 AM(UTC)
Installer RDP - enable/disable - add/delete users
by  RobertoP   Go to last post Go to first unread
Last post: 2/9/2021 11:25:52 AM(UTC)
Installer Microsoft Edge (Chromium) 84.0.522.44
by  PLSJohnJohn  
Go to last post Go to first unread
Last post: 1/21/2021 11:46:38 PM(UTC)
Installer Install Tight VNC server
by  RobertoP   Go to last post Go to first unread
Last post: 12/16/2020 2:48:36 PM(UTC)
Installer Instal/Update Firefox to 84.0
by  RobertoP  
Go to last post Go to first unread
Last post: 12/16/2020 2:36:41 PM(UTC)