cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bobsensor
Engaged Sweeper
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
11 REPLIES 11
telesphere
Engaged Sweeper
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
~~\\\TNLADMIN///~~ "Life moves pretty fast. If you don't stop and look around, you can miss it." -Ferris Bueller
bobsensor
Engaged Sweeper
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
Lansweeper Alumni
Please post your complete stored procedure
bobsensor
Engaged Sweeper
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
Lansweeper Alumni
tblCompCustom
bobsensor
Engaged Sweeper
thank you.

Do you know the name of the table?

bob
Hemoco
Lansweeper Alumni
Please note that we don't support changing the stored procedures.

but most likely you didn't join the correct table.
bobsensor
Engaged Sweeper
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
Lansweeper Alumni
You need SQL server management studio (free download) and directly edit the database.