SSE Reports

Products

• IT Management Suite

Issue/Introduction

 SSE Reports is a collection of reports commonly used by Backline Support and Sustained Engineering. They are very useful for monitoring, administering, and troubleshooting.

Environment

ITMS 8.x

Resolution

This is a collection of reports commonly used by Backline support and Sustained Engineering.

Note:
Currently many of these reports are already part of recent ITMS releases (7.5 and higher). See under SMP Console > Reports > All Reports > Notification Server > Reports > Notification Server Management; however, some reports don't work in 7.6 or higher because the required tables and columns have been removed.

1 - Download the attached file and import into the Reports tree of the Symantec Management Platform.

2 - Import "SSE_Reports.xml" into the Reports tree of the Symantec Management Platform (right-click on "reports" folder -> import)

 

Here is a view of available reports within the SSE package:

 And here is a list of the reports by folders (in bold):

• Agent
  
  • Agent Upgrade Status (This report bases its calculations from the highest known Product Version of each agent. It will show 100% when all agents are at the same version)
  • Agent Version Detail (List of computers with version, for a specified Plug-in)
  • Basic Inventory data not reported within 'N' days (Computers that have not reported Basic Inventory data within the specified number of days)
  • Computers created or last modified by dataclass (This is intended to help troubleshoot where a computer came from or what last modified it ie (AD Import, network discovery, Basic Inventory etc))
  • Computers not requesting configuration in Last 'N' days (Computers that are not communicating with the SMP, many times data is updated through other processes but configuration requests must come from the agent)
• Server
  
  • Deleted Items (Shows Items that have been deleted, including available item management information)
  • GUID search (Find all tables that contain a specific GUID)
  • Site Server Summary (Provides a client count for each Site Server by site and service)
  • Database
    
    • Current Table sizes (Display the sizes of all tables beyond the specified parameters)
    • Index Fragmentation (View the fragmentation level for all indexes created on tables in the SMP database)
    • SQL Object Search
    • Table Growth (Row or Size in KB) Report
  • Performance
    • Server Performance (not updated)
  • Replication
    • Replication rule and job status (Shows latest Replication Job status for each Replication Rule)
  • Security
    
    • Security permission comparison (Items)
    • Security privilege comparison
    • Single Item - Resource permission list
    • Windows-based security role membership (Lists the Windows-based security roles in the CMDB that the user running this report is a member of)
  • Task
    • Currently running tasks (This report lists all running tasks so you can find them and stop them in the console)
    • Latest task status (This report provided as-is, only for use as a supportability template)
    • Task schedules
    • Task table status
• Solutions
  • Inventory
    • Inventory solution data not reported within 'N' days (Computers that have not reported Inventory Solution data within the specified number of days)
    • Server inventory data not reported within 'N' days (Computers that have not reported Server Inventory Solution data within the specified number of days)
  • Monitor Solution
    • Monitor solution data not reported within 'N' hours (Monitor Agents that have not reported detailed data for more than 'N' hours)
  • Patch Management
    • Computers assigned to more than one software update configuration policy (DSUAP)
    • Patch filters
• Subreports
  • Client configuration request details (Performance Drilldown)
  • Installed agents selector
  • Site name-GUID selector
  • Site Service name-GUID selector
  • User
    • Latest user logon and logoff (Displays the latest logon and logoff events recorded for each user and computer)