Absent Member.
Absent Member.
1498 views

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

Jump to solution

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?

0 Likes
1 Solution

Accepted Solutions
Absent Member.
Absent Member.

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

View solution in original post

0 Likes
1 Reply
Absent Member.
Absent Member.

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

View solution in original post

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.