Symantec Management Platform (Notification Server)

I want to automatically email a "Compliance by Bulletin" report out every day.  I've set up Automation Policies to do this successfully with other reports.  When I run the CbB report regularly, the undesired columns are not displayed.  So, it's not a matter of hiding columns in the report, that's already been done.

However, when this same report is used in an Automation Policy, several GUID-type columns are displayed along with the columns I actually want to display.  I was going to try to change the stored procedure for the report but was hoping there's an easier way.

I don't need any drilldown capability with this emailed report.

A similar post exists on this topic but nobody responded within six months and I didn't see a resolution for it.

If you provide an alias to a column that has an underscore, it will not be displayed.  For example:

DECLARE @v1_TrusteeScope nvarchar(155)
   SET @v1_TrusteeScope = N'{038C15F9-3A63-4F98-AC67-861142974705},{2E1F478A-4986-4223-9D1E-B5920A63AB41},{582029E2-FC5B-4717-8808-B80D6EF0FD67},{B760E9A9-E4DB-404C-A93F-AEA51754AA4F}'
SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name] AS [_Name]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
WHERE
   (
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )
 

This is a new Computer Report where I've used the report builder to add the alias '_Name' to Name.  As a result, it doesn't appear on the report when run.  So for any column you don't want to see, provide it with an alias following the Name example above.  And of course, you just reverse this if you have a hidden column you DO want to see.

Does this help remove those extra columns from the report?

I'm hiding the columns from my reports but the automation policy that uses the "Send automation policy e-mail" task still sends the Guid columns in an email.  I've tried hiding the columns in the default report view as well.  Any other suggestions?

Hi

Modify the report and don't use "[vri2_Computer].Guid" in the select.

Example from above:

SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name] AS [_Name]
FROM
 

just list the columns you need in SELECT, so if you just wish the name:

SELECT
     [vri2_Computer].[Name]

FROM
 

Do you have your example as SQL? Then we could try to change it that it works for your automation policy.

Cheers

Patrick