Client Management Suite

So i'm looking to create a scheduled report that lists our product license in use count.

I found under:

Tasks  
 -  Jobs and Tasks  
 -  System Jobs and Tasks  
 -  Notification Server  
 -  Automation Policy Tasks  
 

Email 'Product License Count Notice' 

Which contains:

        This alert has been sent to you because "licenses in use" percentage is equal to or greater than %!Percentage!% percent

        Please review the following information carefully and take action as appropriate. (further Licensing information can be found on the "Licensing" page under the "Configuration" tab).

        Product Name:                        %!Name!%

        Licenses in use:                     %!LicenseInUseCount!%
        Allocated licenses:                  %!TotalCount!%
        Licenses in use percentage:          %!PercentageUsed!%        

So when i go to Schedule this as a Now run, the email sent to me contains no information, here's what i get:

This alert has been sent to you because "licenses in use" percentage is equal to or greater than  percent

        Please review the following information carefully and take action as appropriate. (further Licensing information can be found on the "Licensing" page under the "Configuration" tab).

        Product Name:                       

        Licenses in use:                    

        Allocated licenses:                 

        Licenses in use percentage:                 

So i'm wondering Is this a out of the box email that I just run, but for somereason ours has a issue? OR am i suppose the modify any of these properties? 

Any help would be greatly appreciated.

Per the information provided, "Licensing information can be found on the "Licensing" page under the "Configuration" tab". What do you see when going here?

Hi!

If you want to receive notification messages about license state of solution products, then you can use this query

SELECT vp.[Name] as [Product Name],
    (case
        WHEN la.[PolicyType] = 'Server' and la.[TotalCount] <> 0 THEN 1
        WHEN la.[PolicyType] = 'Server' and la.[TotalCount] = 0 THEN 0
        ELSE la.[LicensingPolicyInUseCount]
    end) AS [Consumed amount],
    la.[LicenseGuidInUse] AS [Product Guid],   
    (CASE
          WHEN la.[PolicyType] = 'Server' and la.[TotalCount] <> 0 THEN '1'
          WHEN la.[PolicyType] = 'Server' and la.[TotalCount] = 0 THEN '0'
          WHEN la.[TotalCount] = -1 THEN 'Unlimited'    
          ELSE cast(la.[TotalCount] AS char(20))   
      end) AS [License Total]   
FROM vProduct vp     
      inner join LicenseStatus la
         ON la.[ProductGuid] = vp.[Guid]     
          and la.[TotalCount] <> -2  
 ORDER BY [Consumed amount]
DESC

Here is a link with basic steps of how to create automation policy and set task to send email notifications, based on query from auto-policy

• https://www-secure.symantec.com/connect/articles/auto-notification-about-agent-service-crash-mail-and-further-connection-client

Thanks,

IP.

I've tried the suggestions abouve with the same result.

Did you try to manually execute this SQL Query above for you database to see whether it will return a list of installed products and will show their license state?

There is a licensing web part you could use...

easiest way to test it... 

put your server name in....

http://YourServerNameOrIP/Altiris/Reporting/Licensing.aspx

This brought up the page for me.. so i can see what we have. try that first and see what you get. 

then I will walk you through how the create the automation policy for it if needed.