I was wondering if there was a better way to pull access reports that I will be needing on a quarterly basis?  Currently, I can get all of the information I need but it's taking quite a while to gather it.  Here are the three things I am looking for:

1. A list of all users and the number of times they have logged into CT and ITP. 

      -I can pulled the list of number of times accessed each application (in reports, Authentication Domain Log) but it only lists the users that have accessed the environment, not those who haven't (if someone hasn't logged in for 3 months, we're evaluating if they still need access).  To get the list of those who haven't accessed the system,  I have to pull a list of all users, the other list that has logins and compare the two to see who hasn't logged in. 

2. A list of users with access to CT. 

   -When I look at the list of users in Environment Access, I only see roles and not the application.  Some roles such as "view only" may be in both CT and ITP.  I've been pulling all users, pulling the list of those with access to ITP and comparing the two to get the list of users with access just to CT.

3. A list of users with access to ITP, what type of access and what departments.

   -This I seem to be able to pull the easiest in ITP, reference data, Cost Object Permissions.  I export this report and pivot it to see access by departments (or names). 

I'm ok with the process for my third report - it's just the other two reports I feel like I have to go through quite the process to get the information we need for simple access control.  The process document I'm writing is pretty lengthy.

I've heard that better environment usage reporting is coming with the release of 12.7.1 which is due shortly.  You may want to check with your CSM to see when you will be scheduled for that upgrade.  I'm currently scheduled for mid September.  Good luck!

Thank you @Sue Vincent! I'm looking forward to the new release and will check!

@Hee Sung Kang, THANK YOU so much! This is why I love Apptio Community!! I hadn't expanded the filter by and didn't realize application was in there!!

We have the same type of request going and from our conversation with our CSM, Apptio is working on an update for sometime in the fall for the Usage and it would show which environment, what area (CT, Bill of IT, ITP), User name and access date. 

For now your approach is likely the only way.

The Environment access should be able to show by application 

There are reports you can run to see user/access data and it shows the application type

Hope we can get an update that works better than the current solution

@Hee Sung Kang be careful if you're using this filter.  It appears that when I export, the filter doesn't stay on so I still get a report of all users.  Then, if I try to copy and paste from the 4 pages, the filter is reset by moving to the next page.  I don't think there really is a way to get a good list of Cost Transparency users.

So this is not very intuitive but you have to filter by Application then select all Roles applicable to that filter

Not very user friendly but the export should work

@Hee Sung Kang, once again you are absolutely correct! I didn't think to check the roles after that - I just clicked the application filter and hit apply! Thank you so much for all your help!  You have truly saved me a lot of time! 

Thank goodness it's Friday! Have a great weekend!