Query to data mine information from action scripts

Reporting
1

(imported topic written by MrFixit)

I need to generate a report that would pull all of the URLs from Fixlets and / or Tasks.

Looking at the API I don’t see a way that it can be done and same for session relevance. Closest I’ve been able to come is using session relevance against bes actions but that only gives me data from those that have been taken as an action.

Do I have to resort to mining the files themselves.

thanks,

-Gary

2

(imported comment written by jeremylam)

I hope this is enough to get you started:

unique values of matches (regex “http://\S+”) of scripts of actions of bes fixlets

3

(imported comment written by MrFixit)

Excellent just what I needed to get me going. Now, I’ll be up late.

thanks again,

-Gary

4

(imported comment written by MrFixit)

BES Session Relevance Tester doesn’t like that relevance nor does trying to get it to work in The Excel Connector.

Does work fine from Web Reports and Presentation Debugger, so I’m able to move forward, but would have liked to be able to use those tools.

The error returned in both Session relevance tester and Excel Connector is: Error: A string constant had no ending quotation mark.

-Gary

5

(imported comment written by jeremylam)

My guess from reading the thread on the Session Relevance Tester (http://forum.bigfix.com/viewtopic.php?id=3026) is that the double forward slash in the regex is being interpreted as a comment. You can probably drop one of the forward slashes and it will still work.

I also noticed that the session relevance is also showing the informational links in each Fixlet and not just the ones in the action. You can drop these links by changing the end of the query to:

… actions whose (script type of it != “text/x-uri”) of bes fixlets