Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

SPC 2.1 Monitoring and Reporting

Created: 06 Jun 2012 • Updated: 07 Jun 2012 | 2 comments
EssKay's picture
This issue has been solved. See solution.

Hi Guys,

 

Just looking at a POC that involves SPC and have a couple of questions around monitoring and reporting from SPC.

 

Monitoring

Within our organisation system monitoring solutions are used to drive workflow around all sorts of events, particularly system events. The use of e-mail as an alerting tool is not considered a valid option. Typically these solutions require the installation of an agent that polls the system for general health and potentially more (i.e. application log files and/or database queries).

Given SPC 2.1 is an application running atop Microsoft Windows Server 2008 R2 Web are we able to install one of these monitoring agents to perform it's required tasks and not void support? Or is this still considered a black box appliance?

 

Reporting

The database for SPC 2.1 is a Micorosft SQL Server variant. As such is this database able to be queried directly? Assuming the answer is yes, is there a database schema reference for the SPC database?

Regards,

Dean

Comments 2 CommentsJump to latest comment

rscovel's picture

Greetings!

Q1: Given SPC 2.1 is an application running atop Microsoft Windows Server 2008 R2 Web are we able to install one of these monitoring agents to perform it's required tasks and not void support? Or is this still considered a black box appliance?
A1: This is a black box appliance.

Q2: The database for SPC 2.1 is a Micorosft SQL Server variant. As such is this database able to be queried directly? Assuming the answer is yes, is there a database schema reference for the SPC database?
A2: Answer is No. See A1 above.

Q3: Can we move the SQL Server Off Box?
A3: In most instances we recommend that people with the requirement to have the SQL Server Off Box look into using IT Analytics and data-mining the SEP data with the SEP Supplied Reports and Cubes. If the use of ITA is not wanted, then it is possible to move the SQL off box, but it requires a powershell script to be run that will make modifications to the base system configuration as well as export a copy of the Symantec_CMDB that SPC uses to your SQL Server. At this time the script hasn't been made available for external use as it hasn't been QA tested. If it were to be allowed out it would be in an unsupported fashion.

Q4: If we move the SQL Off Box would there be a database schema available?
A5: Other than the standard CMDB 7.1 schema there might be a schema available, but I haven't seen it.

Regards

Russ Scovel
Inside Systems Engineer

Altiris SOS – Endpoint Management and Mobility
Symantec Corporation 
www.symantec.com

SOLUTION
EssKay's picture

Thanks for the response.

Regards,

Dean