Query parameter for action state code

Customizations
1

(imported topic written by RobG1)

I’m moving away from api/action/{actionId}/status to a query for specific info in a particular order. I have been able to get the name, id, state, status (as text) and detailed status of the action and member action results, but I cannot figure out how to get the status as an integer for a result.

api/query?relevance=( ids of it, names of it,state of it, status of result of it, detailed status of result of it ) of member actions of bes actions whose (id of it = 4192) returns

4198MS14-031: Vulnerability in TCP Protocol Could Allow Denial of Service - Windows Server 2008 R2 SP1 - KB2957189 (x64)Open<Answer type=“string”

Fixed<
/Answer>The action executed successfully.

I want the numerical value for Fixed. In this case it would be 3. I have tried status as integer of result of it, actionstate of result of it and a few other guesses.

Can someone tell me what the name for this value is?

Thanks,

Can someone tell me what the n

ame of the state value is and is it located on the result object?

Thanks,

2

(imported comment written by BrianPGreen)

You can’t always safely convert from the string status back to the integer status. For example the text “Fixed” corresponds both to the “Fixed” integer state and the “Restart Cancelled by User” integer state. A list of all of the integer states and usual string is in the ACTIONSTATESTRINGS table in the database.

Here it is:

-14

-13

-12

-11

-10

-9

-8

-7

-6

-5

-4

-3

-2

-1

0 Not Relevant

1 Evaluating

2 Running

3 Fixed

4 Failed

5 Locked

6 Waiting for Downloads

7 Waiting for Restart

8 Waiting for User Input

9 Constrained by Retry Delay

10 Constrained by Action Dependency

11 Constrained by Time Range

12 Constrained by Date Range

13 Constrained by License

14 Constrained by Distribution Time

15 Constrained by Active User Condition

16 Constrained by Properties Condition

17 User Cancelled

18 Download Failed

19 Waiting for User Login

20 Expired before execution

21 Postponed by User

22 Restart Waiting for User Input

23 Invalid Action Signature

24 Restart Cancelled by User

25 Constrained by Client Version

26 Action Files in Use

27 Pending Offer Acceptance

28 Offers Disabled

29 Constrained by Client Setting __BESClient_Download_PreCacheStageLimitMB

30 Constrained by Client Setting __BESClient_Download_MinimumDiskFreeMB

31 Download Hash Mismatch

32 Transcoding Error

33 Pending Client Restart

3

(imported comment written by RobG1)

Thanks. What I need to know is how tag in query to use to get the integer state value. Using “state of it” returns the text value of the state. I don’t know how to have IEM return the integer value.

4

(imported comment written by BrianPGreen)

It doesn’t look like it’s possible in relevance to get the action state number.

5

(imported comment written by RobG1)

Thanks Brian.