Notification

Icon
Error

Help with customized report

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

Ismail

Member Posts: 46
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 Windows 10 Build Version report
by  pfenton   Go to last post Go to first unread
Last post: Yesterday at 4:23:31 AM(UTC)
Lansweeper Scan an IP range from a different subnet
by  pfenton  
Go to last post Go to first unread
Last post: Yesterday at 4:03:06 AM(UTC)
Lansweeper Adobe reader install
by  Cardealer_Roc   Go to last post Go to first unread
Last post: 11/17/2017 11:19:28 PM(UTC)
Lansweeper Add MIB for snmp devices
by  crashff  
Go to last post Go to first unread
Last post: 11/17/2017 10:56:03 PM(UTC)
Lansweeper Wrong uptimes for windows 10 assets
by  cbenedict   Go to last post Go to first unread
Last post: 11/17/2017 9:13:48 PM(UTC)
Lansweeper Hide a ticket for just me
by  jeremy.parker  
Go to last post Go to first unread
Last post: 11/17/2017 8:21:41 PM(UTC)
Lansweeper Cleanup options don't work
by  czubai   Go to last post Go to first unread
Last post: 11/17/2017 6:08:49 PM(UTC)
Lansweeper Lansweeper Raports problem
by  RpiTMS  
Go to last post Go to first unread
Last post: 11/17/2017 3:24:54 PM(UTC)