Add user to Domain view

[taeratrin]

Is there a way to add a user column for the Domain Overview page?

[jmeola]

Ricardo, thanks for the info. I am using your suggestions now too!


But I wanted to mention that your change in the SP for line...

"AS SELECT dbo.tblComputers.Computername, dbo.tblComputers.Username,"

Needs to be...

"AS SELECT dbo.tblComputers.Computername, ISNULL(dbo.tblComputers.Username, '') AS Username,"

The portion "AS Username" is required to change the name of the result's column from "thedescription".

without this the page throws an error.

Thanks again!

[ricardo]

I wanted to do something similar, remove the Computer Description column and replace it with a UserName column. You just need to modify the stored procedure and the web page. Probably worth backing them up before you make any changes!

NB I am no expert in this, but it worked fine for me.

In the stored procedure 'Web30computers' replace
"AS SELECT dbo.tblComputers.Computername," with
"AS SELECT dbo.tblComputers.Computername, dbo.tblComputers.Username,"


In %ProgramFiles%\lansweeper32\website\it-alldomain.aspx replace
"<td valign="middle" class="tblcell">Description</td>" with
"<td valign="middle" class="tblcell">UserName</td>"

and replace
"<td class="lef"><%=myrow("thedescription") %>&nbsp;</td>" with
"<td class="lef"><a href="default.aspx?item=userdetail&amp;username=<%=myrow("Username")%>&userdomain=<%=request("Domain")%>"><%=myrow("Username")%></a>&nbsp;</td>"

[kiwi_nz]

Does anyone have the code to make this change??
I know I don't have the skills but someones code changes, and page code would be most useful
thanks

[wavin]

Can you let me know how you can modify the view : "dbo.Web30computers" ?!?!

In the list of the view in SQL I only have "dbo.GUI30Computers" but not "web30" !

Thanks

[Hemoco]

wavin wrote:
Can you let me know how you can modify the view : "dbo.Web30computers" ?!?!

In the list of the view in SQL I only have "dbo.GUI30Computers" but not "web30" !

Thanks

I'm sorry, it's a stored procedure instead of a view

[taeratrin]

OK, I tried to edit the page, but apparently failed miserably (web programming is a new field to me). It's not that important, but if anyone who knows how to or already has done this cares to share the changes required, it'd be appreciated.

[Hemoco]

You also need to change the page "it-alldomain.aspx"

[taeratrin]

Any updates on this?

[taeratrin]

I've already done that (opened it in Management Studio and check off the box by Username in tblComputers). It still doesn't show on that page.