Adding Patch Trending to Your Symantec Management Platform Step by Step Guide - Protirus/patchtrending GitHub Wiki
Adding Patch Trending to Your Symantec Management Platform Step by Step Guide
[END OF "SUPPORT" NOTICE]
Hello everyone, after close to 5 years maintaining various tools around Symantec Connect this legacy is turning to be more of a burden than anything else.
It's still is a great set of tool and they all have their use, but as such I'm not going to maintain them anymore.
The source code for this tool may still change over time, and can be found on Github: https://github.com/somewhatsomewhere?tab=repositories
[/END OF "SUPPORT" NOTICE]
Table of content:
Introduction Unpacking Installing Console items Run Once Scheduling Custom destination Conclusion Introduction:
If you look around Connect for Patch Trending you will find a number of downloads, articles or even blog post. These are the result of a customer driven process that allowed the tool set to grow organically to something sizable.
This document aims to be the only place you need to go through to get up and running with the tool.
Top
Unpacking:
The installation pack is available from the Site Builder download page, but here is a quick link (at version 15):
https://www-secure.symantec.com/connect/sites/default/files/Patch Trending Package.zip.
Unpack the package into a location of your choice:
Top
Installing:
Note! If your SMP is not installed using the default drive and path you'll need to customise the installation directory - see below for the details.
Open an elevated command prompt and go to your package directory to run "install.bat".
The installation process will:
Copy SiteBuilder-v14.exe to the destination folder Copy SiteBuilder-v14.exe to SiteBuilder.exe in the destination folder Copy site-layout.txt to the destination folder Copy web.config to the destination folder Import 5 items into the SMP database The destination folder by default is: "C:\Program Files\Altiris\Notification Server\Web\PatchTrending". This allow you to navigate to the generated site via the link http://localhost/altiris/ns/patchtrending/.
Top
Console items:
The SMP console will now have the following items at the root of the "Job and Task" folder:
Run SiteBuilder (Patch Trending) RunOnce SiteBuilder (Install SQL code) TRENDING Compliance by computer TRENDING Compliance by update TRENDING Inactive computer
Top
Run once:
The SiteBuilder executable contains all the required stored procedure to trend compliance by update, compliance by computer and inactive computers. To add the procedures into the db (or rest them) the site builder must be invoked with the command line option "/install".
This is done by running the task "RunOnce SiteBuilder (Install SQL code)".
Top
Scheduling:
Next you need to schedule the 4 remaining tasks to run daily. The trending tasks (that run the SQL) are best run at the end of the day (so you collect and display data for the day on which the collection is done) and the Site Builder task must run once the trending task completed.
Here is an sample scheduling table:
Task Name Schedule TRENDING Compliance by computer Daily 23:45 TRENDING Compliance by update Daily 23:49 TRENDING Inactive computer Daily 23:53 Run SiteBuilder (Patch Trending) Daily 23:57 Top
Custom destination:
If your Notification Server directory is not under the default drive and path you need to take a few additional steps from the above process to install the toolkit.
On the command line and before running install.bat you must set the installation directory in this manner:
set installdir="" For example:
set installdir="C:\Program Files\Altiris\Patch Trending" or
set installdir="D:\Altiris\Notification Server\Web\Patch Trending"
Once the items are imported in the SMP console, you need to modify the 2 tasks that run site builder with your custom path:
Top
Conclusion:
With the data collection and site builder scheduled to run you should be able to see some results after a couple of nightly execution (the first night should build up the site with empty graphs and the second night will bring in the data required to draw lines).
Here is the link you'll need to use to access the site builder landing page:
http://<your_smp_name>/altiris/ns/patchtrending
Note that if you have configured the IIS to listen to a different port the port number will have to follow the smp host name or fqdn, with a colon delimiter (i.e. http://<your_server>:8080 if you have changed the default port to 8080).
Top
References:
[1] {CWoc} Patch Trending SiteBuilder [2] {CWoC} Patch Trending: Adding Patch Compliance Trending Capacity ... [3] {CWoC} Patch Trending Stored Procedures [4] {CWoC} Patch Trending: Adding a Compliance by Computer module [5] {CWoC} Patch Trending: Inactive Computer Trending Report