What would be the best place to hook into the SCTM APIs monitoring changes in SCTM?

[Per _stman]

Hi!

I'm investigating the possibility of creating a plugin of sorts that would monitor updates in SCTM and publish these to an external system.

Initially, I'm thinking of a simple thing - much like what is shown in the "TestBook" gadget on the dashboard but posted to an external system instead.

Does anyone have any input on where to start? Are there any APIs to use for kind of subscribing to events in SCTM?

[Matthew McGibbon · Accepted solution]

Hi,

Question has been answered through Support Case.

In general though if you are looking for changes which take place in the database some areas to look out would be the TM_ActivityLogs, this is where TestBook messages exist in the database.

You can also monitor changes by directly querying the database for changes per day

SELECT rtc.ReqTreeNodeID_pk_fk, rtc.TestPlanNodeID_pk_fk, tpn.Name, tpn.Description FROM TM_ReqTestCoverages rtc JOIN TM_TestPlanNodes tpn ON rtc.TestPlanNodeID_pk_fk = tpn.NodeID_pk WHERE ( DAY(rtc.CreatedAt) = DAY(GETDATE()) AND MONTH(rtc.CreatedAt) = MONTH(GETDATE()) AND YEAR(rtc.CreatedAt) = YEAR(GETDATE()) )

This will show any new Requirement -> Test Coverages which are created today.

If you create these reports in Silk Central you can use the ReportData interface to return this information, which you can find out more about using the following URL:

documentation.microfocus.com/.../SCTM-0A1AA67F-SERVICESEXCHANGE-CON.html

Thanks very much,

Matthew