Notification

Icon
Error

Report to get all server and workstation operating systems reported

Posted: Monday, October 3, 2011 11:49:21 AM(UTC)
jonnyni

jonnyni

Member Posts: 6
0
Like
This issue has been solved! Click here to view the solution
Hi I was wondering if anyone had the sql query designed to report back on server os installed

eg

windows server 2003
windows server 2003 standard / enterprise / data centre / web
windows server 2008 standard / enterprise / data centre / web server / hpc server /

windows xp - all
windows vista
windows 7

also is there a way to differentiate between versions of office installed?

many thanks

Jonny
Lansweeper
#1Lansweeper Member Administration  
posted: 10/4/2011 2:56:38 PM(UTC)
Basic OS overview for server-type machines:

Quote:
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.OSname, tblComputersystem.Lastchanged,
Web40OSName.Compimage As icon
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Where tblComputersystem.Domainrole > 1
Order By dbo.tblComputers.Computer



Office versions can be filtered in a number of ways, the most common being by name. Example report to show all computers that have Microsoft Office 2003 installed:

Quote:
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName, tblSoftware.softwareVersion
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like 'Microsoft Office 2003%'
Order By tblComputers.Computer

Top Rated

1 Lansweeper Lansweeper 5.2 (recent update)
by  MikeInLa  
Go to last post Go to first unread
Last post: 11/26/2014 9:57:29 AM(UTC)
2 Lansweeper Network Printer by user
by  mikesecond  
Go to last post Go to first unread
Last post: 1/1/2015 6:13:41 AM(UTC)
3 Lansweeper Deployment Organization
by  Niley  
Go to last post Go to first unread
Last post: 7/10/2015 10:50:17 AM(UTC)
4 Lansweeper Deployment monitor
by  DaveinJP  
Go to last post Go to first unread
Last post: 3/19/2015 1:36:19 PM(UTC)
5 Lansweeper VMware ESXi Host Scanning
by  sukaitsu  
Go to last post Go to first unread
Last post: 8/13/2015 11:52:26 AM(UTC)
6 Lansweeper Restricted asset / user / ip-range viewing
by  Solina  
Go to last post Go to first unread
Last post: 8/27/2015 11:06:22 AM(UTC)
7 Lansweeper Custom Fields for User Pages
by  novasam  
Go to last post Go to first unread
Last post: 3/18/2015 1:23:33 PM(UTC)
8 Lansweeper Microsoft Surface Pro 3 Purchase/Warranty lookup and scanning
by  yallah  
Go to last post Go to first unread
Last post: 8/27/2015 10:43:13 AM(UTC)

Active Discussions

Report Center Computer time zone setting
by  Susan.A   Go to last post Go to first unread
Last post: 8/28/2015 12:51:27 PM(UTC)
Report Center BIOS version check
by  Susan.A  
Go to last post Go to first unread
Last post: 8/21/2015 3:36:33 PM(UTC)
Report Center Registry: Internet explorer version (Built-in)
by  brican847   Go to last post Go to first unread
Last post: 8/18/2015 4:31:43 PM(UTC)
Report Center FileScan Report
by  PeterG  
Go to last post Go to first unread
Last post: 8/14/2015 9:16:06 PM(UTC)
Report Center Export custom reports (SQL Server only)
by  esr   Go to last post Go to first unread
Last post: 8/13/2015 8:19:21 PM(UTC)
Report Center Report for visual studio installs per user with computers
by  njordur  
Go to last post Go to first unread
Last post: 8/11/2015 10:39:23 AM(UTC)
Report Center Disk: Workstations less than 1 GB free HD (Built-in)
by  tylerh   Go to last post Go to first unread
Last post: 7/28/2015 10:18:46 PM(UTC)
Report Center Inventory report for Adobe license reviews
by  Daniel.B  
Go to last post Go to first unread
Last post: 7/8/2015 2:06:43 PM(UTC)