How to generate a report which contains the Start (date and time) and End (date and time) of a task or Fixlet. I’m looking for a report which can be able fetch in this format “computer_name”, “Task_Name”, “Start_Date”, “End_Date”, “issued_by”
Please help!!!
Edited by Lee Wei
This version returns all actions for all computers, but it might take a long time to run
Now we’ve resolved the web reports issue, however i’m using BES 7.2.5 version, with this version i’m unable to get the option you are suggested me. after some more investigation i’d understood that the option you’d suggested in the upgraded version of the BIGFIX.
Please let me know is thier any relavance can be written to fetch the data from Web reports, i’m not very much comfortable to write the relavance as i’m new to Bigfix.
Dear Lee, Thanks a lot, It was a great help from you… It worked out for me and fetching the data which i requried. But one small concern is that the issued by is showing the Action status, It is possible to check that option, if not no issues… I can still manage the show.
Action Start/End Times
Computer Name Action ID Action Name Status Issued Time Start Date End Date Issued By
302011389L 42 Start SMS Agent Host Service - If Stopped Expired 2010-10-19 00:21:57 2010-10-19 00:21:57 2010-10-21 00:17:21 Expired
303009681LL 42 Start SMS Agent Host Service - If Stopped Expired 2010-10-19 00:21:57 2010-10-19 00:21:57 2010-10-21 00:17:21 Expired
326004895L 42 Start SMS Agent Host Service - If Stopped Expired 2010-10-19 00:21:57 2010-10-19 00:21:57 2010-10-21 00:17:21 Expired
We will need to track down which property is causing the problem.
The relevance statement looks like this.
( html (
"<A name=%22" & (
if (exists name of computer of it) then (name of computer of it)
else (
"Name Missing")) &
"%22 href=%22" & (
if (exists link href of computer of it) then (link href of computer of it)
else (
"")) &
"%22 target=%22_blank%22>" & (
if (exists name of computer of it) then (name of computer of it)
else (
"Name Missing")) &
"</A>"), (
if (exists id of action of it) then (id of action of it as string)
else (
"ID Missing")), html (
"<A name=%22" & (
if (exists name of action of it) then (name of action of it)
else (
"Action Name Missing")) &
"%22 href=%22" & (
if (exists link href of action of it) then (link href of action of it)
else (
"")) &
"%22 target=%22_blank%22>" & (
if (exists name of action of it) then (name of action of it)
else (
"Action Name Missing")) &
"</A>"), (
if (exists state of action of it) then (state of action of it)
else (
"Action State Missing")), (
if (exists time issued of action of it) then (((year of it as string &
"-" & month of it as two digits &
"-" & day_of_month of it as two digits) of date (local time zone) of it &
" " & (two digit hour of it as string &
":" & two digit minute of it as string &
":" & two digit second of it as string) of time (local time zone) of it) of time issued of action of it)
else (
"Issued Time Missing")), (
if (exists start date of action of it and exists start time_of_day of action of it) then (((year of it as string &
"-" & month of it as two digits &
"-" & day_of_month of it as two digits) of date (local time zone) of it &
" " & (two digit hour of it as string &
":" & two digit minute of it as string &
":" & two digit second of it as string) of time (local time zone) of it) of ((start date of it as string &
" " & start time_of_day of it as string) as local time) of action of it)
else (
if (exists time issued of action of it) then ((((year of it as string &
"-" & month of it as two digits &
"-" & day_of_month of it as two digits) of date (local time zone) of it &
" " & (two digit hour of it as string &
":" & two digit minute of it as string &
":" & two digit second of it as string) of time (local time zone) of it) of time issued of action of it))
else (
"No Start Date"))), (
if (exists end date of action of it and exists end time_of_day of action of it) then (((year of it as string &
"-" & month of it as two digits &
"-" & day_of_month of it as two digits) of date (local time zone) of it &
" " & (two digit hour of it as string &
":" & two digit minute of it as string &
":" & two digit second of it as string) of time (local time zone) of it) of ((end date of it as string &
" " & end time_of_day of it as string) as local time) of action of it)
else (
"No End Date")), (
if (exists name of issuer of action of it) then (name of issuer of action of it)
else (
"Issued By Missing")) ) of results of bes actions
You can help debug by running the statement with individual property/column to determine which is the one causing the error.
For example, to run the first property, it would be:
( html (
"<A name=%22" & (
if (exists name of computer of it) then (name of computer of it)
else (
"Name Missing")) &
"%22 href=%22" & (
if (exists link href of computer of it) then (link href of computer of it)
else (
"")) &
"%22 target=%22_blank%22>" & (
if (exists name of computer of it) then (name of computer of it)
else (
"Name Missing")) &
"</A>") ) of results of bes actions
That looks to have fixled it Lee. However, I’m seeing some performance issues. I only have 240 actions within the console (some open, some closed, some expired), and this report is pulling back all of those as expected, and it is taking 10+ minutes to pull the list back. What do you think of having a pulldown to give the operator the option to only show (Open|Stopped|Expired)? Or someway to break the report down?
I have added to the first post a version with filters.
This report is a little interesting (out of the ordinary) for a few reasons.
For version 8.1, in the Explore Data screen, we have yet to add filters for Actions.
The Start Date of an action is actually 2 different fields, one for the date, and the other the time_of_day. So we need to combine both to produce the start date.
Often the Start Date is empty, which means start the action right away. In this case, the start date is derived from Time Issued.
Lastly, the End Date for an action can be null, which makes it a “policy”, so we also need to take that into account as well.
