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 Remove old scanning errors
by  MakeBug   Go to last post Go to first unread
Last post: Today at 9:44:02 AM(UTC)
Lansweeper Changing header logo
by  MakeBug  
Go to last post Go to first unread
Last post: Today at 9:36:19 AM(UTC)
Lansweeper VMWare-Server recognized as normal Windows client
by  MakeBug   Go to last post Go to first unread
Last post: Today at 9:25:14 AM(UTC)
Lansweeper Warranty Tracking URLs Required
by  MrCount  
Go to last post Go to first unread
Last post: Today at 7:43:03 AM(UTC)
Lansweeper Need assistance creating a report Asset-Relations
by  Chris@BCD   Go to last post Go to first unread
Last post: Yesterday at 9:15:14 PM(UTC)
Lansweeper using LANsweeper to install office365 ProPlus
by  kchilton27  
Go to last post Go to first unread
Last post: Yesterday at 6:47:55 PM(UTC)
Lansweeper Copy and paste articles into the knowledgebase
by  ucorreia   Go to last post Go to first unread
Last post: Yesterday at 5:44:46 PM(UTC)
Lansweeper Installed Software showing "This report has no results"
by  ABECU  
Go to last post Go to first unread
Last post: Yesterday at 3:47:47 PM(UTC)