BigFix User Group

Here is a query that can help (the data isn't available in the session relevance so it can't be queried in Web Reports)...


select Q.ResultsText as 'ComputerName' , A.ActionID, AD.Name as 'Action Name', AD.CreationTime as 'Action Creation Time', A.StartTime, A.EndTime, A.TryCount, A.RetryCount
from ACTIONRESULTS A, QUESTIONRESULTS Q, LOCAL_OBJECT_DEFS L, ACTION_DEFS AD where
A.ComputerID=Q.ComputerID AND 
L.Name='Computer Name' AND
L.ID = Q.AnalysisID AND
AD.ID = A.ActionID AND
AD.ID = <FILL IN ACTIONID >

order by A.StartTime


Ben

Ok... I forgot that we actually had the retry count in the session inspectors...

Here is the session relevance that is equivalent to the sql query above:

(names of computer of it, id of action of it, name of action of it, time issued of action of it, status of it, apply count of it) of results whose (apply count of it > 5) of bes actions whose (now - time issued of it < 100 * day AND name of it contains "" AND id of it > 0)


(Note that everything in the "whose" clause is optional and I added simply to illustrate the filtering)

The only downside is that you can't get "action taken time" in session relevance...

You can use the BigFix Excel Connector (http://support.bigfix.com/labs/excelconnect.html) to execute this query or you can make a custom report.

Ben

You can create a custom web report using Ben's relevance and have Web Reports send you an email anytime the report changes.  Schzam!