[Bottolf]

Hello.

Is it possible to list all computers NOT having a specified program installed? I make daily reports of all the computers in my network, and I want to know about the computers that has not been able to install the latest software I am rolling out. Thanks!

[Bottolf]

Still no replies? I would believe this is a common situation? Maybe I didn't explain well enough. I run Everest on all my computers and then wants to know which computers NOT having Microsoft Office installed. Thanks for making a great product!

[Fiery]

I'm sorry, we saw your idea/request... Now we are actually considering several ways on how to make that possible through the current GUI. Not easy


Regards,
Fiery

[Bottolf]

Thanks for your reply. I hope you will be able to make this possible soon :-) A search tool inside the audit manager would be nice, so that you could search for the info you need instead of scrolling through lists. The search tool would then also need to have a way of searching for all computers not having the word you type in, for example a program. Cheers!

[Avie]

Still no replies? I would believe this is a common situation? Maybe I didn't explain well enough. I run Everest on all my computers and then wants to know which computers NOT having Microsoft Office installed. Thanks for making a great product!

I run Everest without Microsoft Office. Only use Word 2000. No problems.

[Bottolf]

I am able to do this today by using text search on the csv-files and then compare. If anyone wants details, please ask.

[Maverick]

using a database - it's simple

example:

qry_AntivirusSW

SELECT Report.RHost, Max(Report.RDateTime) AS MaxvonRDateTime, Item.IDevice
FROM Report INNER JOIN Item ON Report.ID = Item.ReportID
GROUP BY Report.RHost, Item.IDevice, Item.IID
HAVING (((Item.IDevice) Like "Symantec*") AND ((Item.IID)=1281));

qry_no_AntivirusSW

SELECT Report.RHost, Report.RHostComment, Max(Report.RDateTime) AS [Max von RDateTime]
FROM Report LEFT JOIN qry_AntivirusSW ON Report.RHost = qry_AntivirusSW.RHost
GROUP BY Report.RHost, Report.RHostComment, qry_AntivirusSW.IDevice
HAVING (((qry_AntivirusSW.IDevice) Is Null));

This first example qry searches for an installed symantec product.
the second example list all clients, which have no symantec programm installed


No need of the gui - use a database and yoou can create your own statements - it's simple

Maverick

This post has been edited by Maverick: 16 December 2005 - 12:58 PM