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

Active Discussions

Lansweeper K.i.t.c.h.e.n. .U.n.i.t.s. .M.i.d.l.a.n.d.s
by  slowsnake   Go to last post Go to first unread
Last post: Yesterday at 9:09:01 AM(UTC)
Lansweeper K-i-t-c-h-e-n- -U-n-i-t-s- -M-i-d-l-a-n-d-s
by  slowsnake  
Go to last post Go to first unread
Last post: Yesterday at 9:06:20 AM(UTC)
Lansweeper SSH Mac and Linux Scanning
by  tcilmo   Go to last post Go to first unread
Last post: 12/9/2016 8:26:32 PM(UTC)
Lansweeper Office 2016 Deployment
by  GaryT  
Go to last post Go to first unread
Last post: 12/9/2016 4:49:40 PM(UTC)
Lansweeper Report login user 7 days
by  FbrAbreu   Go to last post Go to first unread
Last post: 12/9/2016 1:52:10 PM(UTC)
Lansweeper Null value for unchecked custom field check box.
by  ITops  
Go to last post Go to first unread
Last post: 12/9/2016 12:23:59 AM(UTC)
Lansweeper Outgoing Email template
by  gdudley   Go to last post Go to first unread
Last post: 12/8/2016 4:34:57 PM(UTC)
Lansweeper Unexpected results with added criteria
by  Jeff Henze  
Go to last post Go to first unread
Last post: 12/8/2016 3:50:51 PM(UTC)