Symantec Management Platform (Notification Server)

How do I create a filter to include all machines that have an Oracle Client installed?

The Oracle clients do not have an Add or Remove Programs entry.  In SCCM I had built a collection query that would pull in all machines that had a "tnsnames.ora" file residing within "%network\\admin%".  This is what I use when pushing out tnsnames.ora file updates to the network.  I am unsure of how to proceed to accomplish the same goal using Filters.   I've included the query below that I currently use in my SCCM collection.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "tnsnames.ora" and SMS_G_System_SoftwareFile.FilePath like "%network\\admin%"

I don't know much about the Oracle Client.  But does this help at all?

https://www-secure.symantec.com/connect/forums/can-app-meter-71-meter-dll-usage

QuietLeni ended up metering the applications that use Oracle Client.  Would you be able to look for apps that use it, rather than the Oracle Client itself?

Otherwise, I recommend creating a software resource that installs it, with a valid detection check based on things like files existing (as you mentioned) or registry values/paths/versions, then use the Installed Software Report based on that software resource.

Does this help?

Are there equivalent tables in the Altiris database to match those that are in SCCM?  In other words, does Altiris catalog the file system the same way that SCCM does? 

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "tnsnames.ora" and SMS_G_System_SoftwareFile.FilePath like "%network\\admin%"

Altiris doesn't enumerate the entire contents of the hard drive; that would be ridiculous!  But you can monitor specific files.  Does the following article help:

http://www.symantec.com/docs/HOWTO47841