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 Premium Users Posts: 6
0
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 Premium Users 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 Post here about your lansweeper setup.
by  Lansweeper  
Go to last post Go to first unread
Last post: 6/13/2014 1:18:56 AM(UTC)
2 Lansweeper Add Report Column showing Office version
by  Jono  
Go to last post Go to first unread
Last post: Yesterday at 11:34:01 PM(UTC)
3 Lansweeper List of Devices matching list of MAC addresses
by  atkinsjd  
Go to last post Go to first unread
Last post: 9/10/2013 11:36:51 PM(UTC)
4 Lansweeper Looking for customers in the US using LanSweeper
by  WbstDev  
Go to last post Go to first unread
Last post: 12/4/2013 10:30:34 PM(UTC)
5 Lansweeper Seperate logins
by  akosters  
Go to last post Go to first unread
Last post: 1/10/2014 6:20:40 AM(UTC)
6 Lansweeper 5.1 Lansweeper Error- Adding New Assets
by  Mlacombe  
Go to last post Go to first unread
Last post: 1/13/2014 5:41:35 PM(UTC)
7 Lansweeper Scanning Credentials - Webserver Error
by  ccdesktop  
Go to last post Go to first unread
Last post: 1/20/2014 5:16:37 PM(UTC)
8 Lansweeper Number of CPU cores and one result per server
by  jaekob  
Go to last post Go to first unread
Last post: 10/20/2014 3:31:46 PM(UTC)

Active Discussions

Lansweeper Which account is being used to scan
by  FixitDave   Go to last post Go to first unread
Last post: Today at 5:41:36 PM(UTC)
Lansweeper Antivirus Report For systems
by  Susan.A  
Go to last post Go to first unread
Last post: Today at 3:33:45 PM(UTC)
Lansweeper Software: ALL SQL Server Editions Report
by  Daniel.B   Go to last post Go to first unread
Last post: Today at 3:14:38 PM(UTC)
Lansweeper Localization
by  Susan.A  
Go to last post Go to first unread
Last post: Today at 3:07:38 PM(UTC)
Lansweeper Report showing device types by group
by  Susan.A   Go to last post Go to first unread
Last post: Today at 2:44:12 PM(UTC)
Lansweeper Inventory of non network devices
by  pskup  
Go to last post Go to first unread
Last post: Today at 2:00:02 PM(UTC)
Lansweeper suppress custom action error
by  Susan.A  
Go to last post Go to first unread
Last post: Today at 12:00:59 PM(UTC)