SPC 2.1 Monitoring and Reporting
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 Comments • Jump to latest comment
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.symante
Thanks for the response.
Regards,
Dean
Would you like to reply?
Login or Register to post your comment.