Notification

Icon
Error

Help with customized report

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

Ismail

Member Posts: 45
0
Like
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
#1Cobra7 Member  
posted: 3/26/2009 6:33:37 PM(UTC)
SO you pretty much want to see every Windows computer on the domain?
Ismail
#2Ismail Member  
posted: 3/29/2009 12:38:36 PM(UTC)
Yes, indeed I do :)
Cobra7
#3Cobra7 Member  
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
#4Ismail Member  
posted: 3/31/2009 8:11:34 AM(UTC)
Doesn't seem to be giving out any report whatsoever
Lansweeper
#5Lansweeper Member 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
#6Ismail Member  
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
#7TheWood 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

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)