Add column to Computer Search

[mikegrous]

I want to add the serial Numbers and Models to the general computer seach. How do i do this?
I have edited the it-compsearch.aspx file so it looks like this...
<tr>
<td valign="middle" class="tblcell">&nbsp;</td>
<td valign="middle" class="tblcell">Computer</td>
<td valign="middle" class="tblcell">Description</td>
<td valign="middle" class="tblcell">OS</td>
<td valign="middle" class="tblcell">Processor</td>
<td valign="middle" class="tblcell">Memory</td>
<td valign="middle" class="tblcell">Domain</td>
<td valign="middle" class="tblcell">Date </td>
<td valign="middle" class="tblcell">vendor</td>
</tr>
<%dim tel as integer
dim myrow as system.data.datarow
tel = 1%>
<% For Each myrow In dscomputers.DefaultView.Table.Rows%>
<tr <%if (tel mod 2) = 0 then%>class="ne"<%end if%>>
<td class="lijntje"><%if myrow("notscanned")=1 then%><img src="images/cnok.gif" width="16" height="16" hspace="1" />
<%else%>
<img src="images/cok.gif" width="16" height="16" hspace="1" />
<%end if%></td>
<td class="lijntje"><a href="default.aspx?item=compdetail&amp;comp=<%=myrow("Computername") %>"><%=myrow("Computername") %></a>&nbsp;</td>
<td class="lef"><%=myrow("Description") %>&nbsp;</td>
<td class="lef"><%=myrow("Caption") %>&nbsp;</td>
<td class="lef"><%=myrow("Processor") %>&nbsp;</td>
<td align="right" class="lef"><%=myrow("Memory") %>&nbsp;</td>
<td class="lef"><%=myrow("Domain") %>&nbsp;</td>
<td align="right" class="lef"><%=datetime.parse(myrow("Last seen")).tostring(ConfigurationSettings.AppSettings("dateformat"))%></td>
<td class="lef"><%=myrow("vendor") %>&nbsp;</td>

I found CommandText="dbo.web30compsearch" and then founf the dbo.web30compsearch in the buildobjects.sql file however could not get it to work. I assume it has to do with some SQL Table somewhere? But i have no idea where to do this. I started editing

This is as far as i can get/..

Column 'vendor' does not belong to table theTable.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Column 'vendor' does not belong to table theTable.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


[ArgumentException: Column 'vendor' does not belong to table theTable.]
System.Data.DataRow.GetDataColumn(String columnName) +1962843
System.Data.DataRow.get_Item(String columnName) +10
ASP.it_compsearch_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +1127
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +98
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
System.Web.UI.Page.Render(HtmlTextWriter writer) +26
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2558

[mikegrous]

ahh no i only have the free version

[Hemoco]

Don't know if you have the premium version.
But in the premium version it's allowed to change the webpages.
Also the report builder allows exporting into excel/xml,...

[mikegrous]

if this isnt possible is it possible to output the database somehow in to an excel file or a text delimited file. I am trying to output this info into an asset management program