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 need help in generating report
by  MikeMc   Go to last post Go to first unread
Last post: Yesterday at 8:29:11 PM(UTC)
Lansweeper VMware ESXi Host Scanning
by  toddcbrown  
Go to last post Go to first unread
Last post: Yesterday at 6:49:21 PM(UTC)
Lansweeper Non active Assets show old path in Active Directory
by  hannes_kann_es   Go to last post Go to first unread
Last post: Yesterday at 3:46:40 PM(UTC)
Lansweeper Timestamp of computer object of AD available?
by  hannes_kann_es  
Go to last post Go to first unread
Last post: Yesterday at 3:44:30 PM(UTC)
Lansweeper Outgoing Templates & Incoming responses
by  satxx   Go to last post Go to first unread
Last post: Yesterday at 3:42:13 PM(UTC)
Lansweeper Update Custom Field with Custom Action
by  thmtech  
Go to last post Go to first unread
Last post: Yesterday at 3:17:12 PM(UTC)
Lansweeper Ip Range Location problem
by  SNF   Go to last post Go to first unread
Last post: Yesterday at 12:52:23 PM(UTC)
Lansweeper Report to show certain fields please
by  BradG  
Go to last post Go to first unread
Last post: Yesterday at 12:04:28 PM(UTC)