01-21-2015 10:04 AM
I attempted to add my questions as a comment on a similar DI Reporting Issue forum, but I'm not sure if my response was received. Here is my question:
I have ran into a couple issues with reporting in DI:
Stemming from the first question, I've noticed that outputs generated by reports with the same queries, but in different categories, yield different results. To put this into context, see the attached report titled "Raw-InactiveUsers.xlsx". In this situation, I've selected Title and Country and it displays all of the Inactive Users; however, in the Access Summary report (first attachment) when I selected the same thing, it only displays the top users (as stated above).
Please let me know if there is a quick fix to these issues, and thanks for your help!!
Evan
**all sensitive information was removed from the reports
Solved! Go to Solution.
01-22-2015 05:47 AM
Hi Evan,
Unfortunately, you cannot specify more than 5 users in summary table of access summary (as the display is meant to provide overview of the report) and custom attributes is not appliacble to 2nd table today. Would it suffice if custom attribute were added to 2nd report? If yes, can you get a support case opened for tracking it?
For your requirement to get active users on a share (site collection), you can utilize a DQL repoort to get information for active users on a share along with their AD attributes:
Something like following. You can add more columns in selections OR add/edit conditions as per your need.
FROM activity
GET user.name,
user.department,
sum(count) AS access_count
IF timestamp >= duration('6 months')
AND
path.msu.name = '<Share Name>'
GROUPBY user.name, user.department
SORTBY sum(count) DESC
LIMIT 20
Thanks,
Rishi
01-22-2015 05:47 AM
Hi Evan,
Unfortunately, you cannot specify more than 5 users in summary table of access summary (as the display is meant to provide overview of the report) and custom attributes is not appliacble to 2nd table today. Would it suffice if custom attribute were added to 2nd report? If yes, can you get a support case opened for tracking it?
For your requirement to get active users on a share (site collection), you can utilize a DQL repoort to get information for active users on a share along with their AD attributes:
Something like following. You can add more columns in selections OR add/edit conditions as per your need.
FROM activity
GET user.name,
user.department,
sum(count) AS access_count
IF timestamp >= duration('6 months')
AND
path.msu.name = '<Share Name>'
GROUPBY user.name, user.department
SORTBY sum(count) DESC
LIMIT 20
Thanks,
Rishi