Notification

Icon
Error

Help with customized report

Posted: Thursday, March 26, 2009 11:36:11 AM(UTC)
Ismail

Ismail

Member Premium Users Posts: 45
0
Hello,

I am stumped, I tried to run a customized report that would show me the following:

All servers (Domain controllers)
All member servers (Non DC's)
All Workstations (NON Servers)
All portable Workstations

In that same report I would like to view the following of each Computer:

Computer name
IP Address
Operating system
Computer manufacturer

Would anyone be kind enough to give me the SQL Query that would allow me to obtain this report ?
Cobra7
#-29Cobra7 Member Premium Users  
posted: 3/26/2009 6:33:37 PM(UTC)
SO you pretty much want to see every Windows computer on the domain?
Ismail
#-28Ismail Member Premium Users  
posted: 3/29/2009 12:38:36 PM(UTC)
Yes, indeed I do :)
Cobra7
#-27Cobra7 Member Premium Users  
posted: 3/30/2009 6:45:40 PM(UTC)
SELECT
dbo.tblComputers.Computername,
dbo.tblComputers.Domain,
dbo.tblComputersystem.Domainrole
FROM
dbo.tblComputersystem
INNER JOIN dbo.tblComputers ON (dbo.tblComputersystem.Computername = dbo.tblComputers.Computername)


That should do it. The only problem is I have not upgraded to 3.5 so I don't know the table for an IP address. Someone else should be able to plug it in pretty quickly.
Ismail
#-26Ismail Member Premium Users  
posted: 3/31/2009 8:11:34 AM(UTC)
Doesn't seem to be giving out any report whatsoever
Lansweeper
#-25Lansweeper Member Premium Users Administration  
posted: 3/31/2009 9:32:32 AM(UTC)
Use this

Code:
SELECT dbo.tblComputers.Computername, dbo.tblComputersystem.Domainrole, dbo.tblComputers.Domain, dbo.tblComputers.LastknownIP,
dbo.tblComputersystem.Manufacturer, dbo.tblOperatingsystem.Caption
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername LEFT OUTER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername
Ismail
#-24Ismail Member Premium Users  
posted: 3/31/2009 11:16:44 AM(UTC)
Lansweeper wrote:
Use this

Code:
SELECT dbo.tblComputers.Computername, dbo.tblComputersystem.Domainrole, dbo.tblComputers.Domain, dbo.tblComputers.LastknownIP,
dbo.tblComputersystem.Manufacturer, dbo.tblOperatingsystem.Caption
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername LEFT OUTER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername


This report works great but the problem is that the IP Address is empty.
TheWood
#-23TheWood Member  
posted: 4/24/2009 3:26:24 PM(UTC)
@lansweeper

This is almost a perfect query for me, i just need to add in the Model, Serial / Service Tag, Memory and CPU Number and Speed.

Any help will be greatly appreciated.

Regards

Matt

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 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)
3 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)
4 Lansweeper Lansweeper 5.2 (recent update)
by  MikeInLa  
Go to last post Go to first unread
Last post: Yesterday at 5:48:04 PM(UTC)
5 Lansweeper Dell Warranty
by  tonyoh  
Go to last post Go to first unread
Last post: 1/23/2014 9:41:55 PM(UTC)
6 Lansweeper Managing Licenses
by  coraz  
Go to last post Go to first unread
Last post: 10/24/2014 5:59:13 PM(UTC)
7 Lansweeper Display A/V info on asset page
by  gwelsted  
Go to last post Go to first unread
Last post: 10/24/2014 10:34:14 PM(UTC)
8 Lansweeper Confused on a report output.
by  drlord  
Go to last post Go to first unread
Last post: 10/10/2014 2:29:21 PM(UTC)

Active Discussions

Lansweeper Bar Chairs
by  lionhorest   Go to last post Go to first unread
Last post: Today at 5:34:38 AM(UTC)
Lansweeper Add Report Column showing Office version
by  RC62N  
Go to last post Go to first unread
Last post: Yesterday at 10:56:07 PM(UTC)
Lansweeper Bitlocker Reporting
by  brianraley   Go to last post Go to first unread
Last post: Yesterday at 9:34:09 PM(UTC)
Lansweeper LS Push Custom Action
by  chads  
Go to last post Go to first unread
Last post: Yesterday at 7:46:31 PM(UTC)
Lansweeper Device down notifications
by  Michael.V   Go to last post Go to first unread
Last post: Yesterday at 7:22:53 PM(UTC)
Lansweeper Is it possible to link a web page to an asset?
by  Michael.V  
Go to last post Go to first unread
Last post: Yesterday at 7:22:03 PM(UTC)
Lansweeper custom sip port scanning
by  hpitman   Go to last post Go to first unread
Last post: Yesterday at 7:19:23 PM(UTC)
Lansweeper OS Update Report
by  BrianM  
Go to last post Go to first unread
Last post: Yesterday at 6:47:30 PM(UTC)