AnsweredAssumed Answered

Explain the timestamps on Work Items and Change Requests

Question asked by Paul Duer on Jun 15, 2016
Latest reply on Jun 19, 2016 by Boris Lekumovich

Like • Show 0 Likes0
Comment • 11

I am trying to better understand how VIA records timings. I see that these fields are often found:

COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."AVAILABLE_DATE" IS 'Date, with time, that the work item became available.';

COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."OPEN_DATE" IS 'Date, with time, that the work item was most recently opened.';

COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."FIRST_OPEN_DATE" IS 'Date, with time, that the work item was first opened.';

COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."COMPLETE_DATE" IS 'Date, with time, that the work item was completed.';

COMMENT ON COLUMN "AVUSER"."V_CHANGE_REQUEST_WORK_ITEM"."DUE_DATE" IS 'Date, with time, that the work item was due.';

That text comes from the Change Request Work Item , can someone explain how VIA records timings?

Edwin Mullie

Jun 16, 2016 8:47 AM

Correct Answer

The requestors can see the progress in Via L&G, all the information is available in the change request. When it was started, when it was approved, etc

Available is the creation date, open is when it was opened (first time and last time)

Edwin

See the reply in context

No one else had this question

Outcomes

11 Replies

Edwin Mullie Jun 16, 2016 3:09 AM
Mark Correct
Correct Answer
What do you mean? I think the comment text explains it all?

Edwin
Like • Show 0 Likes0
Actions
Paul Duer Jun 16, 2016 8:27 AM
Mark Correct
Correct Answer
Well what I mean is that we are constantly being asked to report on change requests. The requestors always want to know when a request started, when it was approved (or finally approved is probably a better way of saying it) and when it was fulfilled.

Of course this is for EACH item on a request. So that's to say the user and item requested, everybody wants reports on that.

I don't understand the difference between Available and Open really.
Like • Show 0 Likes0
Actions
- Edwin Mullie @ Paul Duer on Jun 16, 2016 8:47 AM
  Unmark Correct
  Correct Answer
  The requestors can see the progress in Via L&G, all the information is available in the change request. When it was started, when it was approved, etc
  
  Available is the creation date, open is when it was opened (first time and last time)
  
  Edwin
  Like • Show 0 Likes0
  Actions
  - Paul Duer @ Edwin Mullie on Jun 16, 2016 9:04 AM
    Mark Correct
    Correct Answer
    Yeah but what is the definition of "Opened", what does it mean in context?
    
    We're writing reports, so we're not looking at the UI. We're looking at your Views and looking to make SURE we understand every field we report.
    
    These are reports for our Auditors. If I don't MAKE SURE that I can explain every field in detail, then my kids don't eat.... I know that seems silly, but it's the truth. Making a mistake on an audit report is the quickest way to stop collecting a paycheck at my company. No pay check means it's hard to buy food. Means I have to find something new, but I am shaken up because I've just lost my job of 10 years because I didn't know what Open meant!
    
    I know, it's insane.
    Like • Show 1 Like1
    Actions
Edwin Mullie Jun 16, 2016 10:07 AM
Mark Correct
Correct Answer
is it clear now?
Like • Show 0 Likes0
Actions
- Paul Duer @ Edwin Mullie on Jun 16, 2016 10:41 AM
  Mark Correct
  Correct Answer
  Sorta, we're getting there.
  Okay explain this to me...
  
  What is a Business Source?
  How is it different than an Application or Directory?
  Are all Apps and Dirs just types of Business Sources?
  Can how do Entitlements relate to all of these?
  Like • Show 0 Likes0
  Actions
  - Edwin Mullie @ Paul Duer on Jun 16, 2016 10:45 AM
    Mark Correct
    Correct Answer
    A business source is an application or directory, entitlements are collected with the specific business source collector and linked to a specific business source
    Like • Show 0 Likes0
    Actions
    - Paul Duer @ Edwin Mullie on Jun 16, 2016 10:47 AM
      Mark Correct
      Correct Answer
      How do Applications and Directories differ from one another?
      
      Both can have accounts and entitlements, but what about groups. Can both have groups?
      Like • Show 0 Likes0
      Actions
      - Edwin Mullie @ Paul Duer on Jun 16, 2016 10:57 AM
        Mark Correct
        Correct Answer
        From the help:
        Directories are objects you create and manage in RSA Via L&G that represent the data sources in your organization from which identities (users) and, in some cases, accounts and entitlements are collected. As the data sources in your organization contain the data you collect, the directories you create serve as containers for the collectors and the collected source data. Directories also serve as the managed entity for the data contained in them, which means directory owners can be designated as participants in the review process and in approval and fulfillment phases for change request workflows.
        
        An application is an object you create and manage in RSA Via L&G that represents an application in your organization that users access to do their jobs. For any application in your organization, there are any number of ways users can access its resources. Users can be directly granted granular entitlements, accounts, and application roles that provide access. They can also be granted access by virtue of belonging to groups and roles that have been granted entitlements to an application.
        
        So a directory object can contain the identities and an application cannot. A directory can hold accounts for applications
        Edwin
        1 person found this helpful
        Like • Show 0 Likes0
        Actions
        Paul Duer @ Edwin Mullie on Jun 16, 2016 11:04 AM
        Mark Correct
        Correct Answer
        Perfect! I so get it now. Thanks Edwin, thanks for taking your time this morning!
        
        We're VERY happy with our VIA product, fyi. We're not so happy with the silly decisions we made!
        Like • Show 0 Likes0
        Actions
      - Boris Lekumovich @ Paul Duer on Jun 19, 2016 6:52 AM
        Mark Correct
        Correct Answer
        related post - application vs. directory?
        Like • Show 0 Likes0
        Actions

Explain the timestamps on Work Items and Change Requests

Outcomes

Related Content

Recommended Content