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
Like
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 Post here about your lansweeper setup.
by  Lansweeper  
Go to last post Go to first unread
Last post: 2/24/2015 5:19:54 AM(UTC)
3 Lansweeper Custom Deployment Retry Time
by  jlorsung  
Go to last post Go to first unread
Last post: 2/25/2015 7:37:03 PM(UTC)
4 Lansweeper Approve software only for certain PCs or Users
by  sarmo  
Go to last post Go to first unread
Last post: 11/13/2014 4:09:33 PM(UTC)
7 Lansweeper Deployment monitor
by  DaveinJP  
Go to last post Go to first unread
Last post: 1/17/2015 12:27:22 PM(UTC)
8 Lansweeper Deployment Organization
by  Niley  
Go to last post Go to first unread
Last post: 1/15/2015 3:19:39 PM(UTC)

Active Discussions

Lansweeper New switch asset overwrites existing switch asset
by  jdteichmer   Go to last post Go to first unread
Last post: Yesterday at 7:54:16 PM(UTC)
Lansweeper What monitors are attached to computers?
by  Graham Gobell  
Go to last post Go to first unread
Last post: Yesterday at 5:25:59 PM(UTC)
Lansweeper Possible to scan SQL inventory?
by  michaelh   Go to last post Go to first unread
Last post: Yesterday at 4:58:28 PM(UTC)
Lansweeper Help me understand what LS can do in these areas...
by  RJAH  
Go to last post Go to first unread
Last post: Yesterday at 4:51:44 PM(UTC)
Lansweeper SQL Installs
by  Susan.A   Go to last post Go to first unread
Last post: Yesterday at 3:47:56 PM(UTC)
Lansweeper Anti-virus Out of Date
by  Susan.A  
Go to last post Go to first unread
Last post: Yesterday at 3:15:38 PM(UTC)
Lansweeper Scan chromebook
by  Susan.A   Go to last post Go to first unread
Last post: Yesterday at 3:12:45 PM(UTC)
Lansweeper Dell Warranty scan errors
by  Susan.A  
Go to last post Go to first unread
Last post: Yesterday at 3:07:10 PM(UTC)