→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ktb
Engaged Sweeper
All is in the subject
5 REPLIES 5
mbonal
Engaged Sweeper III
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">&nbsp;</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.
ktb
Engaged Sweeper
A good idea for version 3.3 😉

Thanks !
Hemoco
Lansweeper Alumni
Not without reprogramming the web page.
ktb
Engaged Sweeper
Thanks, is it not possible in "Computers in domain ......" for global view ?
Hemoco
Lansweeper Alumni
Should look something like this:
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')