Dsiplay Anti Virus infomation

[Pollak]

Is there a way to display the antivirus version of McAfee. I would like to see DatDate, DATVersion, EngineVersion and Version which I found in the registry and added to the registry scan of LAnsweeper, but see no waty to display this information.

Also it would be cool if I could display, based on the most current DatDate, which ones are not up to date. So if one computer reports 04/01/2009 as the current DAT version the rest that were out of date would be listed so.



Thanks,
Niles

[Pollak]

Active Scanning . I have disabled the lsclinet script from the login process.




Thanks,
Niles

[Hemoco]

Pollak wrote:
Active Scanning . I have disabled the lsclinet script from the login process.
Thanks,
Niles

Niles,

Could you open another thread for this in the premium forum please.
Please post some screenshots and an extract of your errorlog.txt file

[Pollak]

Works like a charm...

...and thank you for including the Last Log on script. Now where can I change the number of computers last logged onto? Also under Domain in the Dashoard my domain is displayed twice. One as "domain" and the other as "domain.com". Is there a way to only show one or the other?




Thanks,
Niles

[Hemoco]

Pollak wrote:
Also under Domain in the Dashoard my domain is displayed twice. One as "domain" and the other as "domain.com". Is there a way to only show one or the other?

Is this with Active scanning or with Lsclient?

[Hemoco]

Problem confirmed, and fixed in the current 3.5.1 beta. http://www.lansweeper.com/forum/yaf_postst1514_Lansweeper-Service-351-update-1-beta.aspx

[Pollak]

On the Lansweeper server when I browse to the Dashboard I get a slightly differnet error when trying to view the custom report.

Server Error in '/lansweeper' Application.
--------------------------------------------------------------------------------

Column 'software' 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 'software' 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 'software' does not belong to table theTable.]
System.Data.DataRow.GetDataColumn(String columnName) +1775301
System.Data.DataRow.get_Item(String columnName) +13
ASP.it_cust_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +1276
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
System.Web.UI.Page.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1266




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

[jtnfoley]

Co-worker of 'Pollak' here (one who knows enough SQL to be dangerous!)
The above Test2 that works within Report Designer but crashes the web interface is "SELECT * from aavwMcAfeeXtab" where "aavwMcAfeeXtab" is a view I created in Enterprise Manager for SQL Server. (i.e. created manually, NOT WITHIN the query designer in LanSweeper.)

I'm suspicious that my named view does not appear in the list of views in the Report Designer tree view. Is ReportDesigner's own Query Editor required create a report and associated view which will work in the web GUI?



--Edit: Before anybody asks, the Xtab query cannot be entered directly into the Query Editor: It chokes on the syntax that is perfectly acceptable to SQL Server:
SELECT TOP 100 PERCENT
dbo.tblComputers.Computername, dbo.tblComputers.Domain,
MIN(CASE Valuename WHEN 'HotFixVersions' THEN Value END) AS HotFixVersions,
MIN(CASE Valuename WHEN 'Version' THEN Value END) AS Version,
MIN(CASE Valuename WHEN 'EngineVersion' THEN Value END) AS EngineVersion,
MIN(CASE Valuename WHEN 'DATVersion' THEN Value END) AS DATVersion
FROM dbo.tblRegistry INNER JOIN dbo.tblComputers ON dbo.tblRegistry.Computername = dbo.tblComputers.Computername
WHERE
(dbo.tblRegistry.Regkey LIKE '%VIRUSCAN8600%')
GROUP BY
dbo.tblComputers.Computername, dbo.tblComputers.Domain
ORDER BY
dbo.tblComputers.Domain, dbo.tblComputers.Computername

[Hemoco]

jtnfoley wrote:

I'm suspicious that my named view does not appear in the list of views in the Report Designer tree view. Is ReportDesigner's own Query Editor required create a report and associated view which will work in the web GUI?

The reports shown must start with "web30rep"

The web site "crashing" on a report must be investigated by us

[Pollak]

Well I was able to figure out a few things. One, Iam able to get both SQL and ReportBuilder to display correctly, but I get the following when I try to view it in the Dashboard.


Server Error in '/lansweeper' Application.
--------------------------------------------------------------------------------

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>


Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>




Please advise,
Niles