Identify which software resources are missing from an offline Package Server

Products

• IT Management Suite

Issue/Introduction

 Is there a way to find out what specific software resources are missing from offline Package Servers without having to physically go to every directory for each resource?

Environment

ITMS 8.x

Resolution

Create a report and an email automation policy by doing the following:

1. In the SMP Console, navigate to Reports > All Reports, and then to a folder where you want the new report to reside. Right-click the folder and select New > Report > SQL Report. Give the report a desired name at the top, and replace all text in the Parametrized Query tab with the below SQL code:
   
   SELECT vc.[Name] AS [Package Server], count(pk.[Name]) AS [Package Count], ps.Status AS [Status]
FROM SWDPackageServer ps
JOIN vComputer vc ON ps.PkgSvrId = vc.Guid
JOIN vRM_Package_Item pk ON pk.Guid = ps.PackageId
WHERE pk.ProductUninstalled = 0 and ps.Status <> 'Ready'
GROUP BY VC.NAME, ps.Status
Order by [Package Server]
   
   and click Save Changes.

2. Navigate to Manage > Automation Policies and click the New Policy button.
3. Click on the name and give the policy a suitable name
4. Once testing is complete, set the schedule as desired based on how often you want to check for missing software resources.  Set the schedule to once per day which is reasonable for the server to know if the resource was added to the Package Server
5. In the Data Source section, the Data Source should be the new Report, and then click on Select the new Report and scroll to or search for the report you created above.
6. Leave Conditions – Evaluation Rule as the default of Run for non-empty data
7. Under Actions, click the Select a Job or Task link navigate to Jobs and Tasks > System Jobs and Tasks > Notification Server > Automation Policy Tasks, and select Send automated report e-mail. Then click the OK button. Click the Edit input parameter link and change the “To” drop-down to [Custom] and type in your email address (as a test). For Report name, in the drop-down select Report Name. For Policy name, select Results as HTML.
8. Click Save changes; then select the policy on the left and click the Turn on button in the grey bar above; then Save changes again.
9. Check your email and verify that it looks correct and adjust if needed. Note you may need to adjust the report to obtain results for testing by changing the percentage from 10% to a higher value.

Additional Information

ITMS Technical Documentation on Managing Automation Policies