Lansweeper logo
HomeDownloadBuy NowFeaturesSupportForumBlog
Welcome Guest Search | Active Topics | Log In | Register

Untag as favorite
Help with customized report
Ismail
#1 Posted : Thursday, March 26, 2009 10:36:11 AM

Rank: Premium user

Groups: Member, Premium Users
Posts: 41
Location: Kuwait
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
#2 Posted : Thursday, March 26, 2009 5:33:37 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 149
Location: Omaha
SO you pretty much want to see every Windows computer on the domain?
Ismail
#3 Posted : Sunday, March 29, 2009 11:38:36 AM

Rank: Premium user

Groups: Member, Premium Users
Posts: 41
Location: Kuwait
Yes, indeed I do :)
Cobra7
#4 Posted : Monday, March 30, 2009 5:45:40 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 149
Location: Omaha
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
#5 Posted : Tuesday, March 31, 2009 7:11:34 AM

Rank: Premium user

Groups: Member, Premium Users
Posts: 41
Location: Kuwait
Doesn't seem to be giving out any report whatsoever
Lansweeper
#6 Posted : Tuesday, March 31, 2009 8:32:32 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 13,735
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
#7 Posted : Tuesday, March 31, 2009 10:16:44 AM

Rank: Premium user

Groups: Member, Premium Users
Posts: 41
Location: Kuwait
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
#8 Posted : Friday, April 24, 2009 2:26:24 PM
Rank: Freeware user

Groups: Member
Posts: 1
Location: Leeds
@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
Users browsing this topic
Guest
Untag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.