I've been going through the data contained in the data export, but I have not been able to find anything that links users with their managers. Can anyone point me in the right direction?
If that's the data you need, but you are trying to get it from the All Data Download, could you get it from the users.csv file that comes out in that batch? That report is the same report you would get if you went about it the way I described earlier. It's just another way to access that information. Could that work?
If you go to the Admin section, then select Users & Permissions > Manage Users, you can export the users from there. It puts out a bunch of data about each user, but among that data, there will be a column for Manager that will tell you who they directly report to according to the system.
Does that answer your question?
Not exactly, although it is the data I'm looking for. I am working on an automated process which will make all the data available for reporting, and I was hoping to be able to pull everything out of the data export, which is a zip file with about 90 csv files in it (admin -> tools -> download all data). We can generate and download it with an API call, and now we are working on turning that data into tables which can be queried. To that end, I'm trying to figure out if there is anything not included in this data export, and I'm having trouble finding manager information within the various csv files. If it is not in there, we'll have to come up with some other way to get the information that doesn't involve the UI, because it needs to be automated.
Thank you for taking the time to reply, and I welcome any additional insight you may have.
That was my first thought as well, but I don't see that information anywhere in the users.csv file. There is no column that contains manager data, and none of the columns appears to have a reference to the managers uid or any other indirect reference that would give this info. I've also looked at files memberships.csv, groups.csv, domains.csv, and none of them seem to connect users to managers in any fashion that I could determine. I'm hoping there is some combination of ids (group, membership, user, etc) that can start with a user id and end with the associated manager, but so far I can't find anything like that.
Is there something in the users.csv file that I am not seeing, or misinterpreting?
Update: Immediately after I finished typing this, I realized that I had missed something in the users.csv file. For every user, there is a domain id listed, which does correspond to the domain id in domains.csv for the user who is their manager. I wasn't finding it before because I was searching for the manager within domains.csv using the wrong string!
Thank you for your help, without your replies I would not have gone back for another look and realized what I was missing.
Have a great day!
Retrieving data ...