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]

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





Thanks,
Niles

[Hemoco]

Is the dashboard linked to the correct report?

[Pollak]

Sorry no screen shot. I have not been able to replicate the error. Since yesterday, I have been trying to figure out why the Dashboard will not disable what I see in the Report Builder. The code below displays fine when I run the results, but when I go to view it in the Dashboard or Report Output I only get two colums, Computer and DAT Date.

SELECT dbo.tblComputers.Computername, dbo.tblComputers.[Domain], dbo._viewMcAffeeEngineVersion.[Engine Version],
dbo._viewMcAfeeDATDate.[DAT Date], dbo._viewMcAfeeDATVersion.[DAT Version], dbo._viewMcAfeeHotFixVersion.[Hot Fix Version],
dbo._viewMcAffeeVersion.Version
FROM dbo.tblComputers LEFT OUTER JOIN
dbo._viewMcAfeeDATVersion ON dbo.tblComputers.Computername = dbo._viewMcAfeeDATVersion.Computername LEFT OUTER JOIN
dbo._viewMcAfeeHotFixVersion ON dbo.tblComputers.Computername = dbo._viewMcAfeeHotFixVersion.Computername LEFT OUTER JOIN
dbo._viewMcAffeeEngineVersion ON dbo.tblComputers.Computername = dbo._viewMcAffeeEngineVersion.Computername LEFT OUTER JOIN
dbo._viewMcAffeeVersion ON dbo.tblComputers.Computername = dbo._viewMcAffeeVersion.Computername LEFT OUTER JOIN
dbo._viewMcAfeeDATDate ON dbo.tblComputers.Computername = dbo._viewMcAfeeDATDate.Computername


Please advise

[Hemoco]

Could you post a screenshot of this error, I don't see the word "as" in your second query.

[Pollak]

Any thoughts on my last post?




Thanks,
Niles

[Pollak]

Okay, we created five indivual views in order to get colums from key names. For example;


SELECT dbo.tblComputers.Computername, dbo.tblRegistry.[Value] AS [DAT Date]
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblRegistry ON dbo.tblComputers.Computername = dbo.tblRegistry.Computername
WHERE (dbo.tblRegistry.Valuename = 'DATDate')


Then created a view as below to combine the five individual views. Getting syntax error "near AS".
Looks like query interrupter getting hung up with alias



SELECT dbo.tblComputers.Computername, dbo.tblComputers.[Domain], dbo._viewMcAffeeEngineVersion.[Engine Version],
dbo._viewMcAfeeDATDate.[DAT Date], dbo._viewMcAfeeDATVersion.[DAT Version], dbo._viewMcAfeeHotFixVersion.[Hot Fix Version],
dbo._viewMcAffeeVersion.Version
FROM dbo.tblComputers LEFT OUTER JOIN
dbo._viewMcAfeeDATVersion ON dbo.tblComputers.Computername = dbo._viewMcAfeeDATVersion.Computername LEFT OUTER JOIN
dbo._viewMcAfeeHotFixVersion ON dbo.tblComputers.Computername = dbo._viewMcAfeeHotFixVersion.Computername LEFT OUTER JOIN
dbo._viewMcAffeeEngineVersion ON dbo.tblComputers.Computername = dbo._viewMcAffeeEngineVersion.Computername LEFT OUTER JOIN
dbo._viewMcAffeeVersion ON dbo.tblComputers.Computername = dbo._viewMcAffeeVersion.Computername LEFT OUTER JOIN
dbo._viewMcAfeeDATDate ON dbo.tblComputers.Computername = dbo._viewMcAfeeDATDate.Computername




PLease advise,
Niles

[Hemoco]

mmm, that won't be that simple, you will need multiple queries and unions to get this result.

[Pollak]

A, ha! that worked. I hate to be such a pain, but I was hoping to be able to display each of the catagories under the same display.

Something like this with the data under each colum.


Computername | Domain | Engine Version | Data Version | DAT Version | Hot Fix Version | Version




Thanks,
Niles

[Hemoco]

remove the HKEY_LOCAL_MACHINE\ from the regpath

[Pollak]

Sorry, I know you asked for this yesterday. Just a little busy. The bottom five.