Video Screencast Help

Altiris 7.1 Canned Filter email

Created: 25 Jun 2013 | 2 comments

I know you can email reports, but can you email canned filers? (Altiris 7.1) I am trying to get a count of each of our agents automatically sent in an email once a week.  Has anyone been able to accomplish this?

Operating Systems:

Comments 2 CommentsJump to latest comment

SK's picture

You will need to create a report containing this data and then use an automation policy, or add the raw SQL to an automation policy.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

HighTower's picture

Here is the SQL that I use to dump out a filter membership.  You can create your report from this:

SELECT

vComputer.Guid,

vComputer.Name,

vCollection.Name AS 'Filter Name',

CollectionMembership.ResourceGuid,

vCollection.Description

FROM CollectionMembership INNER JOIN

vComputer ON CollectionMembership.ResourceGuid = vComputer.Guid INNER JOIN

vCollection INNER JOIN

Collection ON vCollection.Guid = Collection.Guid ON CollectionMembership.CollectionGuid = Collection.Guid

where vCollection.Name = 'FILTER_NAME'