How can I have a list of I.P. address with dns name ? - Reports and queries

Welcome Guest

Search | Active Topics | Members | Log In | Register

Lansweeper Forum » Lansweeper » Reports and queries » How can I have a list of I.P. address with dns name ?

How can I have a list of I.P. address with dns name ?

Options

Previous Topic · Next Topic

ktb

Posted: Thursday, September 04, 2008 2:29:39 PM

Rank: Premium user
Groups: Member , Premium Users

Joined: 7/30/2008
Posts: 3
Location: belgium

All is in the subject Think

Lansweeper

Posted: Thursday, September 04, 2008 2:59:34 PM

Rank: Administration
Groups: Administration

Joined: 2/10/2005
Posts: 1,451
Location: Hamme Belgium

Should look something like this:

Code:

SELECT dbo.tblComputers.Computername, dbo.tblNetwork.IPAddress, dbo.tblNetwork.IPSubnet
FROM dbo.tblComputers INNER JOIN
dbo.tblNetwork ON dbo.tblComputers.Computername = dbo.tblNetwork.Computername
WHERE (dbo.tblNetwork.IPAddress <> '') AND (dbo.tblNetwork.IPAddress <> '0.0.0.0')

ktb

Posted: Thursday, September 04, 2008 3:11:08 PM

Rank: Premium user
Groups: Member , Premium Users

Joined: 7/30/2008
Posts: 3
Location: belgium

Thanks, is it not possible in "Computers in domain ......" for global view ?

Lansweeper

Posted: Thursday, September 04, 2008 4:19:56 PM

Rank: Administration
Groups: Administration

Joined: 2/10/2005
Posts: 1,451
Location: Hamme Belgium

Not without reprogramming the web page.

ktb

Posted: Thursday, September 04, 2008 4:25:53 PM

Rank: Premium user
Groups: Member , Premium Users

Joined: 7/30/2008
Posts: 3
Location: belgium

A good idea for version 3.3 ;-)

Thanks !

mbonal

Posted: Tuesday, December 02, 2008 10:24:18 PM

Rank: Freeware user
Groups: Member

Joined: 11/5/2008
Posts: 6
Location: S

sure you can and all you have to do is modify this asp page called it-alldomain.asp and add in the following code similar to mine.

td><table border="0" cellpadding="1" cellspacing="0" class="sortable">
<tr>
<td valign="middle" class="sorttable_nosort"> </td>
<td valign="middle" class="tblcell">Computer</td>
<td valign="middle" class="tblcell">IP Address </td>
<td valign="middle" class="tblcell">Description</td>
<td valign="middle" class="tblcell">OS</td>

The caveat to this is you have to define a new table called IPAddress os something similar and populate the tables from a view or a SQL stored procedure.

The wola you have the domain view with what you want.

Users browsing this topic

Guest

Lansweeper Forum » Lansweeper » Reports and queries » How can I have a list of I.P. address with dns name ?

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.