Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Query To Locate Action Variable Being Called From


we have this "M011 - 0" action variable that resets the value back to 0. i can't seems to find where this action variable is being called from the tidal. i looked at every places and failed to locate it. does anyone have a SQL query to find where this piece of info can be located?

thank you,
warren

1 REPLY
New Member

Try the Query that joins

Try the Query that joins events and actions to find your event... then you can do a similar query to find jobs

Marc

 

SELECT dbo.tskmst.tskmst_name AS [Action Name], dbo.trgmst.trgmst_name AS [Event Name]

FROM dbo.trgmst INNER JOIN

dbo.trgtsk ON dbo.trgmst.trgmst_id = dbo.trgtsk.trgmst_id RIGHT OUTER JOIN

dbo.tskmst ON dbo.trgtsk.tskmst_id = dbo.tskmst.tskmst_id

WHERE (dbo.tskmst.tskmst_name LIKE '%M011%')

70
Views
0
Helpful
1
Replies
CreatePlease login to create content