add/modify columns in web console

[bobsensor]

Hello Support!..

great product!...

I would like to know if there is a way to add/modify columns in the web console. More specifically in "computers in domain" page

By default I have "computer" "description" "os" "sp" .... I like to have the custom field "location"

Than you
bob

[telesphere]

Hi Bob...

Thanks for asking a great question. After a small addition I was able to make necessary db adjustments to show what you are looking for. The only thing you missed was the actual JOIN on the tables at the bottom...I highlighted your correct code as well as the missing code below in red.

ALTER PROCEDURE [dbo].[Web40getdomain](@domain nvarchar(80))
AS SELECT dbo.Web40OSName.Compimage AS Icon, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Computername,
dbo.Web40OSName.OSname AS OS, dbo.tblCompCustom.Location AS Location, dbo.tblComputers.Description AS Description, dbo.tblComputers.Username AS LastUser, dbo.Web40OSName.SP AS SP,
dbo.web40ProcessorCapacity.NrOfProcessors AS [Proc], dbo.web40ProcessorCapacity.MaxClockSpeed AS Speed, dbo.web40CorrectMemory.Memory,
dbo.tblComputers.LastknownIP AS IP, dbo.tblComputers.Lastseen
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.web40allcompstates ON dbo.tblComputers.Computername = dbo.web40allcompstates.Computername LEFT OUTER JOIN
dbo.web40CorrectMemory ON dbo.tblComputers.Computername = dbo.web40CorrectMemory.Computername LEFT OUTER JOIN
dbo.Web40OSName ON dbo.tblComputers.Computername = dbo.Web40OSName.Computername LEFT OUTER JOIN
dbo.web40ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web40ProcessorCapacity.Computername LEFT OUTER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
dbo.tblCompCustom ON dbo.tblComputers.Computername = dbo.tblCompCustom.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblComputers.Domain LIKE @domain)

It worked for me so hopefully it will work for you too. You asking in the first place helped me waste away a Saturday of making stored procedure changes!
Happy Coding

[bobsensor]

USE [lansweeperdb]
GO
/****** Object: StoredProcedure [dbo].[Web40getdomain] Script Date: 06/03/2010 08:09:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Web40getdomain](@domain nvarchar(80))
AS SELECT dbo.Web40OSName.Compimage AS Icon, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Computername,
dbo.Web40OSName.OSname AS OS, dbo.tblCompCustom.Location AS Location, dbo.tblComputers.Description AS Description, dbo.tblComputers.Username AS LastUser, dbo.Web40OSName.SP AS SP,
dbo.web40ProcessorCapacity.NrOfProcessors AS [Proc], dbo.web40ProcessorCapacity.MaxClockSpeed AS Speed, dbo.web40CorrectMemory.Memory,
dbo.tblComputers.LastknownIP AS IP, dbo.tblComputers.Lastseen
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.web40allcompstates ON dbo.tblComputers.Computername = dbo.web40allcompstates.Computername LEFT OUTER JOIN
dbo.web40CorrectMemory ON dbo.tblComputers.Computername = dbo.web40CorrectMemory.Computername LEFT OUTER JOIN
dbo.Web40OSName ON dbo.tblComputers.Computername = dbo.Web40OSName.Computername LEFT OUTER JOIN
dbo.web40ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web40ProcessorCapacity.Computername LEFT OUTER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblComputers.Domain LIKE @domain)
ORDER BY dbo.tblComputers.Computer

[Hemoco]

Please post your complete stored procedure

[bobsensor]

hum... that is pretty much what I have entered:

Msg 4104, Level 16, State 1, Procedure Web40getdomain, Line 3
The multi-part identifier "dbo.tblCompCustom.Location" could not be bound.

It seems like I cannot use custom fields... all the other ones work???

thank you
bob

[Hemoco]

tblCompCustom

[bobsensor]

thank you.

Do you know the name of the table?

bob

[Hemoco]

Please note that we don't support changing the stored procedures.

but most likely you didn't join the correct table.

[bobsensor]

thank you

I have added :

dbo.tblCompCustom.Location AS Location

in the Web40getdomain procedure but I get this error:

Msg 4104, Level 16, State 1, Procedure Web40getdomain, Line 3
The multi-part identifier "dbo.tblCompCustom.Location" could not be bound.

What am I doing wrong???

thank you
bob

[Hemoco]

You need SQL server management studio (free download) and directly edit the database.