show username in report and customizing views overall

[jcorso11]

when you click digital dashboard, then a domain, is it possible to list machines the way they are, but also with the username field showing that information.

In addition, the high priority list on the pcs, for example, no F-Secure installed!?!?! Can we change those things. Som e of the built in reporting isnt useful to us.

[Hemoco]

My mistake.
What you want also involves re-programming the actual webpage, which I don't recommend if you are not familiar with asp.net and sql.

[jcorso11]

i fuigured out the execute. Sorry...

But it didnt change anything. I ran it from the config of lansweeper

[jcorso11]

how do i know what file to find?

[jcorso11]

not good with SQL. How do i do the command for the view change in sql 2005.

[jcorso11]

and is there anyway to show show computers with AV too old. Using Symantec.

[Hemoco]

jcorso11 wrote:
and is there anyway to show show computers with AV too old. Using Symantec.

1) you will need to find a file on the computers harddisk with the Symantec file information.
2) Add this file to the custom scanned files.
3) Create a report with the reportbuilder based on the scan results (you can see how it's done based on the f-secure report)

[jcorso11]

This is what the procedure says now,

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[Web30computers](@domain varchar(80))
AS SELECT dbo.tblComputers.Computername, ISNULL(dbo.tblOperatingsystem.Description, '') AS thedescription, dbo.tblOperatingsystem.Caption AS OS,
CASE ISNULL(dbo.tblOperatingsystem.Description, 'NOT SCANNED') WHEN 'NOT SCANNED' THEN 1 ELSE 0 END AS Notscanned,
CAST(dbo.web30ProcessorCapacity.NrOfProcessors AS varchar) + ' * ' + CAST(dbo.web30ProcessorCapacity.MaxClockSpeed AS varchar)
+ ' Mhz' AS Processor, CAST(CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC) AS varchar)
+ ' MB' AS Memory, dbo.tblComputers.Lastseen, dbo.tblComputers.LastknownIP, dbo.web30repallcompstates.Thestate
FROM dbo.tblComputers INNER JOIN
dbo.web30repallcompstates ON dbo.tblComputers.Computername = dbo.web30repallcompstates.Computername LEFT OUTER JOIN
dbo.web30ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web30ProcessorCapacity.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)


How would I change that?

[Hemoco]

Run this sql code to change the stored procedure

ALTER PROCEDURE dbo.Web30computers
(@domain varchar(80))
AS SELECT     dbo.tblComputers.Computername, ISNULL(dbo.tblOperatingsystem.Description, '') AS thedescription, dbo.tblOperatingsystem.Caption AS OS, 
                      CASE ISNULL(dbo.tblOperatingsystem.Description, 'NOT SCANNED') WHEN 'NOT SCANNED' THEN 1 ELSE 0 END AS Notscanned, 
                      CAST(dbo.web30ProcessorCapacity.NrOfProcessors AS varchar) + ' * ' + CAST(dbo.web30ProcessorCapacity.MaxClockSpeed AS varchar) 
                      + ' Mhz' AS Processor, CAST(CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC) AS varchar) 
                      + ' MB' AS Memory, dbo.tblComputers.Lastseen, dbo.tblComputers.Username, dbo.tblComputers.LastknownIP, 
                      dbo.web30repallcompstates.Thestate
FROM         dbo.tblComputers INNER JOIN
                      dbo.web30repallcompstates ON dbo.tblComputers.Computername = dbo.web30repallcompstates.Computername LEFT OUTER JOIN
                      dbo.web30ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web30ProcessorCapacity.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.Computername

[Hemoco]

when you click digital dashboard, then a domain, is it possible to list machines the way they are, but also with the username field showing that information.

You need to change Stored Procedure Web30Computers.

In addition, the high priority list on the pcs, for example, no F-Secure installed!?!?! Can we change those things. Som e of the built in reporting isnt useful to us.

See page 20 of the documentation