IBM Support

How can I see the number of Real-Time Scoring Requests

Technote (troubleshooting)


Problem(Abstract)

I want to evaluate the utilization of Real-Time Scoring requests in our C&DS environment. How can I do this.

Cause

C&DS no longer logs each scoring request with the Audit tables because
of volume and performance. Scores are aggregated when the Scoring
Configuration is paused or restarted.

Resolving the problem

SELECT SUM(CAST(B.Value AS INT))
FROM [CnDS7].[dbo].[SPSSAUDIT_EVENTS] A, [CnDS7].[dbo].[SPSSAUDIT_PARAMETERS] B
where A.SERIAL = B.SERIAL and TITLE ='Scoring Test' and NAME = 'Total Score Change'

Change both [CnDS7] value to the name of your C&DS repository database.
Change 'Scoring Test' to the name of your scoring config.

This query can be modified/iterated for each scoring config you have or want to see.

Document information

More support for: SPSS Collaboration and Deployment Services
Content Repository

Software version: 5.0, 6.0, 7.0

Operating system(s): Platform Independent

Reference #: New

Modified date: 2016-03-28