After a Service Pack, Hot fix or platform upgrade all the SMA and all the SMA plug ins need to be up-to-date.
A quick bird-eye view of the environment SMA versions is possible following the steps below:
1 - Download the SSE reports XML file at link:
2 - Import "SSE_Reports.xml" into the Reports tree of the Symantec Management Platform (right-click on "reports" folder -> import)
3 - Find "Agent Version Detail" under: SSE Reports -> Agent:
4 - Filter by "Agent Name":
If you found the above information useful, please give this article a thumbs-up(top right of the post) or add a comment below. Your feedback will help the Symantec tech community – Thank you, Mauro
I just want to say, these reports are great, the amount of data altiris collects is overwhelming at times but these reports have basically saved us a lot of time and work developing ourselves.
I defiantly recommend you guys add these to the standard build or make this a KB, defiantly makes the reporting area much more "out of box" usable especially if your not SQL savvy.
Awesome reports, thanks for these!!
I was looking at the database index fragmentation report and I had a ton of indexes over 99% fragmentation so I had one of our SQL guys take a look and he found an issue with his maintenance script which was causing it not to fully defrag indexes. After he cleaned up his script and reran we were comparing reports and we had a wide discrepancy from what my report was showing to what he was seeing in SQL. He took a look at the report included in this pack and found a few issues with it, here's the updated version he provided to me. Let me know if you see any issues with what he changed.
SELECT ao.[name] [Table],
ips.[object_id] AS 'objectID',
ips.index_id AS 'indexID',
avg_fragmentation_in_percent [Avg Fragmentation %],
fragment_count [Fragment Count]
FROM sys.Dm_db_index_physical_stats (Db_id(), NULL, NULL, NULL, NULL) ips
INNER JOIN sys.all_objects ao
ON ips.object_id = ao.object_id
INNER JOIN sys.indexes si
ON si.object_id = ips.object_id
AND ips.index_id = si.index_id
WHERE si.[name] IS NOT NULL
AND avg_fragmentation_in_percent >= '10'
AND ips.index_id > 0
AND ips.page_count > 8
AND ips.index_level = 0
ORDER BY ips.[object_id],
[avg fragmentation %] DESC
Awesome tool - thanks - Just getting ready to migrate to HF5 and this will be very helpful in tracking agent upgrades.
Thank's for a superb pack of reports and especially the ones for checking the Agent details ;-)
Good one!, great way to have an overview of the agent\plugins versions.