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

[Hemoco]

These errors state that the views (dbco_viewMcAfee,...) do not exists

You just need basic sql, no vb,asp,...

[Pollak]

Not asking you to teach me SQL scripting, but I feel that I am not telling Lansweeper how to present the data correctly or not using the correct syntax. I learned that there are different ways to script in SQL, such as VB and ASP.. I guess I am not sure what type Lanseeper supports.

Please advise.


Thanks,
Niles

[Pollak]

Okay, I have been working hard on learning SQL scripting, but I am stuck on this one. I tried entering in my code into the Query Analyzer and get the following. What are your thoughts?

Thanks,
Niles

[Hemoco]

My guess is that the error is caused by one of the subqueries. (that would explain the line 2)

[Pollak]

Here is a fresh report that I am trying to create. It does not matter what I type, I keep getting the same error. Even code that I know that worked before.

[Hemoco]

Could you post a screenshot of this please.

[Pollak]

Now when I try to create and save a new report I get syntax error. Even a blank report.




Thanks,
Niles

[Hemoco]

What exactly do you mean by :

Yes, but now the Report Builder will not let me edit or create a new test report with the same code.

[Pollak]

Sorry to be a pain, but any thoughts on my post?




Thanks,
Niles

[Pollak]

What about creating views and stored stored procedure directly in SQL?




Thanks,
Niles