Topic
  • 28 replies
  • Latest Post - ‏2014-04-09T15:43:35Z by ranakeyur
SystemAdmin
SystemAdmin
890 Posts

Pinned topic Start Date and End Date report

‏2011-02-24T13:58:49Z |
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
  • Download http://www.leewei.com/bigfix/prod/forum/action_start_stop_time.beswrpt
  • To import the report, go to Web Reports/Report List/Import report
  • Use format XML
  • The name imported is "Action Start/End Times"

http://www.leewei.com/bigfix/prod/forum/action_start_stop_time.png

This version provides filters for selecting a computer and status
  • Download http://www.leewei.com/bigfix/prod/forum/action_start_stop_time_with_filters.beswrpt
  • To import the report, go to Web Reports/Report List/Import report
  • Use format XML
  • The name imported is "Action Start/End Times with Filters"

http://www.leewei.com/bigfix/prod/forum/action_start_stop_time_with_filters.png
  • BenKus
    BenKus
    597 Posts

    Re: Start Date and End Date report

    ‏2011-02-25T08:51:47Z  
    Have you looked in web reports and used "explore data" with an "Actions" report?

    Ben
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Start Date and End Date report

    ‏2011-02-25T15:16:55Z  
    I've some issues with the Web report service, hence unable to check the same. Once i resolve the issue will check the same.
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Start Date and End Date report

    ‏2011-03-01T18:13:57Z  
    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.

    Please help - Shalva
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Start Date and End Date report

    ‏2011-03-07T07:54:23Z  
    Any Luck !!!!! ??
  • BenKus
    BenKus
    597 Posts

    Re: Start Date and End Date report

    ‏2011-03-08T09:18:16Z  
    Did you try the built-in reports?

    Ben
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Start Date and End Date report

    ‏2011-03-08T11:21:27Z  
    I'd tried, but it provides only start date, but i need both start date and end date of an action

    Shalva
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-08T22:53:10Z  
    Shalva,

    I have created a report with the action start/end times.
    Please see if it is usable.

    • Download http://www.leewei.com/bigfix/prod/forum/action_start_stop_time.beswrpt
    • To import the report, go to Web Reports/Report List/Import report
    • Use format XML
    • The name imported is "Action Start/End Times"

    I have included a picture of the report in the first post so that it is easier for others who might benefit from this to see.

    Lee Wei
  • cstoneba
    cstoneba
    182 Posts

    Re: Start Date and End Date report

    ‏2011-03-09T14:13:41Z  
    this looks cool, but when I run it, I get "Singular expression refers to nonexistent object." What are it's dependancies?
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-09T22:25:05Z  
    I have added some if/then/else code to protect against properties that might not be returning any values.
    Please download and try again.
    If that does not work, we will have to work to figure out which property within your environment might be causing the issue.
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Start Date and End Date report

    ‏2011-03-10T12:51:09Z  
    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
  • cstoneba
    cstoneba
    182 Posts

    Re: Start Date and End Date report

    ‏2011-03-10T14:15:13Z  
    still no go for me...

    Singular expression refers to nonexistent object
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-10T17:34:18Z  
    Shalva,

    I typed in an error so that "Action Status" is shown instead of the "Issued By".
    I have fixed that and you need to download the report again.
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-10T17:37:14Z  
    Chris,

    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
    
  • cstoneba
    cstoneba
    182 Posts

    Re: Start Date and End Date report

    ‏2011-03-10T21:17:19Z  
    it looks like "(if (exists name of issuer of action of it) then (name of issuer of action of it) else ("Issued By Missing"))" is breaking it for me.
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-10T22:17:32Z  
    Chris,

    This helps. It looks like we will get this error and into this situation if there are actions taken by an operator that has been removed.
    So the Issuer of the Action no longer exists.

    I have modified the report accordingly, and the statement should be:

    (if (color=redexists issuer of action of it and [/color]exists name of issuer of action of it) then (name of issuer of action of it) else ("Issued By Missing"))
  • cstoneba
    cstoneba
    182 Posts

    Re: Start Date and End Date report

    ‏2011-03-11T21:15:45Z  
    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?
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-11T21:38:14Z  
    I agree that it will be better to have a report with filters, otherwise, some deployments will have too much data.
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-12T00:17:08Z  
    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.

    Lee Wei
  • cstoneba
    cstoneba
    182 Posts

    Re: Start Date and End Date report

    ‏2011-03-14T13:13:28Z  
    can you confirm? I just downloaded your post#1 file again and am not seeing any filter options.
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-14T16:00:47Z  
    There are 2 links for 2 reports in the first post.
    Scroll further down to download the report with filters.
  • cstoneba
    cstoneba
    182 Posts

    Re: Start Date and End Date report

    ‏2011-03-14T16:09:08Z  
    ah, i see. I ran your new filtered one showing all computers with an "expired" status and it locked up my browser.
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Start Date and End Date report

    ‏2011-03-14T16:13:40Z  
    You should try it on one computer to determine if it has to do with a large dataset.
    If returning all computers takes too long, then this report is not suitable for a blind query.
  • cstoneba
    cstoneba
    182 Posts

    Re: Start Date and End Date report

    ‏2011-03-14T16:21:31Z  
    yes, it works fine looking at one computer. Yeah, it looks like any querey that is not looking at a single asset takes along time.
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Start Date and End Date report

    ‏2011-10-17T06:31:30Z  
    Hi, how do I add the Action Start and Action End column to the report (version with filters for selecting a computer and status) ? Thanks in advance