Khoros Atlas Logo

%3CLINGO-SUB%20id%3D%22lingo-sub-438012%22%20slang%3D%22en-US%22%3EUser%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438012%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20user%20report%20that%20I%20can%20run%20that%20lists%20all%20users%20from%20a%20certain%20company%20(assuming%20same%20domain%20name%20in%20email%20address%2C%20for%20example)%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20case%20is%20that%20we%20have%20a%20new%20customer%20engagement%20and%20our%20management%20would%20like%20to%20track%20their%20activities%20in%20the%20community.%20Many%20of%20these%20folks%20have%20already%20registered%20so%20too%20late%20to%20assign%20a%20role%20by%20SSO.%20I%20can%20use%20site%20search%20to%20see%20a%20list%20of%20user%20accounts%2C%20but%20cannot%20export%20from%20there.%20And%20LSI's%20member%20reports%20only%20have%20certain%20filters%20that%20do%20not%20apply%20here.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20try%20to%20assign%20these%20folks%20a%20role%20manually%2C%20but%20we%20are%20talking%20hundreds%20of%20accounts.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%2C%20LSI%2Freporting%20gurus%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20the%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438181%22%20slang%3D%22en-US%22%3ERe%3A%20User%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438181%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F65485%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40lindafrembes%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20system%20enables%20you%20to%20export%20up%20to%20100%2C000%20users%20to%20the%20CSV%20file%20and%20the%20limit%20can%20be%20increased%20upon%20request%20to%20support.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJason%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438104%22%20slang%3D%22en-US%22%3ERe%3A%20User%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438104%22%20slang%3D%22en-US%22%3E%3CP%3E%3Ca%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F63194%22%3E%40ClaudiusH%3C%2Fa%3E%26nbsp%3BYes%2C%20I%20would%20love%20to%20get%20to%20this%20point!%20The%20thing%20that%20is%20messing%20me%20up%20is%20that%20a%20few%20hundred%20of%20these%20people%20have%20already%20signed%20up%20(and%20more%20signing%20up%20daily%2Fweekly)%2C%20so%20it%20would%20be%20a%20bear%20to%20manually%20assign%20a%20role%20at%20this%20point.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438097%22%20slang%3D%22en-US%22%3ERe%3A%20User%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438097%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%26nbsp%3B%3Ca%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F12041%22%3E%40JasonHill%3C%2Fa%3E.%20Found%20that%20and%20tried%20it%2C%20but%20my%20report%20exceeds%205%2C000%20lines%20(we%20have%20a%20big%20community%20overall).%20I%20don't%20see%20a%20way%20to%20filter%20the%20report%20run%20by%20email%20(using%20that%20as%20a%20company%20identifier)%20prior%20to%20CSV%20export.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438078%22%20slang%3D%22en-US%22%3ERe%3A%20User%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438078%22%20slang%3D%22en-US%22%3EAlso%20if%20the%20eventual%20list%20turns%20out%20abit%20longer%20and%20you%20are%20looking%20to%20assign%20a%20role%20to%20these%20to%20track%20them%20going%20forward%20it%20might%20we%20worth%20looking%20at%20the%20batch%20role%20assignment%20via%20importing%20user%20roles%20from%20a%20CSV%20file%3A%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2FRoles-and-permissions%2FImport-user-roles-from-a-CSV-file%2Fta-p%2F24276This%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.lithium.com%2Ft5%2FRoles-and-permissions%2FImport-user-roles-from-a-CSV-file%2Fta-p%2F24276This%3C%2FA%3E%20way%20once%20you%20have%20a%20role%20assigned%20you%20can%20filter%20for%20these%20users'%20activities%20in%20LSI.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438030%22%20slang%3D%22en-US%22%3ERe%3A%20User%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438030%22%20slang%3D%22en-US%22%3E%3CP%3E%40Inactive%20User%3C%2Fa%3E%3A%20Adding%26nbsp%3B%20weight%20to%26nbsp%3B%3Ca%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F12041%22%3E%40JasonHill%3C%2Fa%3E%26nbsp%3BComment.%20Kindly%20check%20this%20articles%20for%20more%20information%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2FAdmin-Metrics%2FRun-Community-Admin-User-reports%2Fta-p%2F5911%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.lithium.com%2Ft5%2FAdmin-Metrics%2FRun-Community-Admin-User-reports%2Fta-p%2F5911%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2FAdmin-Metrics%2FRun-Advanced-Community-Admin-reports%2Fta-p%2F136182%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.lithium.com%2Ft5%2FAdmin-Metrics%2FRun-Advanced-Community-Admin-reports%2Fta-p%2F136182%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20my%20post%20is%20helpful%20and%20answers%20your%20question%2C%20please%20give%20%22Kudos%22%20and%20%22Accept%20it%20as%20a%20Solution.%22Thanks%20%26amp%3B%20Regards%2CAbhishek%20Illindra%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438027%22%20slang%3D%22en-US%22%3ERe%3A%20User%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F65485%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40lindafrembes%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStraightforward.%20You%20can%20produce%20a%20user%20report%20with%20an%20email%20address%20field%2C%20and%20export%20to%20a%20CSV%2C%20then%20sort%20the%20spreadsheet%20by%20email.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20find%20User%20Reports%20in%20the%20Admin%20under%20Metrics.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJason%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438026%22%20slang%3D%22en-US%22%3ERe%3A%20User%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438026%22%20slang%3D%22en-US%22%3EGreat%20question.%20We%20just%20migrated%20to%20Lithium%20so%20I%20am%20not%20familiar%20with%20using%20the%20API.%20If%20there%20is%20an%20LSI%20option%2C%20then%20I%20would%20prefer%20that%20route%20at%20this%20point%20in%20my%20learning%20curve.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438019%22%20slang%3D%22en-US%22%3ERe%3A%20User%20report%20by%20company%20name%20or%20company%20email%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438019%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F65485%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40lindafrembes%3C%2FA%3E%3C%2FP%3E%3CP%3EDO%20you%20want%20it%20through%20the%20LSI%20only%20or%20you%20are%20also%20interested%20in%20API%20as%20well.%20As%20I%20think%20API%20can%20do%20the%20job%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Inactive User
Not applicable

User report by company name or company email?

Jump to solution

Hi all,

 

Is there a user report that I can run that lists all users from a certain company (assuming same domain name in email address, for example)? 

 

Use case is that we have a new customer engagement and our management would like to track their activities in the community. Many of these folks have already registered so too late to assign a role by SSO. I can use site search to see a list of user accounts, but cannot export from there. And LSI's member reports only have certain filters that do not apply here. 

 

I can try to assign these folks a role manually, but we are talking hundreds of accounts. 

 

Any ideas, LSI/reporting gurus?

 

Thanks in advance for the help!

 

0 Kudos
8 Replies 8
Highlighted
Honored Contributor
Honored Contributor

Re: User report by company name or company email?

Jump to solution

@Inactive User

DO you want it through the LSI only or you are also interested in API as well. As I think API can do the job here.

Give kudos if you find my posts helpful or mark solution if it answers your query
0 Kudos
Reply
Loading...
Highlighted
Inactive User
Not applicable

Re: User report by company name or company email?

Jump to solution
Great question. We just migrated to Lithium so I am not familiar with using the API. If there is an LSI option, then I would prefer that route at this point in my learning curve.
0 Kudos
Reply
Loading...
Highlighted
Honored Contributor Honored Contributor
Honored Contributor

Re: User report by company name or company email?

Jump to solution

@Inactive User

 

Straightforward. You can produce a user report with an email address field, and export to a CSV, then sort the spreadsheet by email.

 

You can find User Reports in the Admin under Metrics.

 

Jason 

Generic1.jpg

Reply
Loading...
Highlighted
Honored Contributor Honored Contributor
Honored Contributor

Re: User report by company name or company email?

Jump to solution

@Inactive User: Adding  weight to @JasonHill Comment. Kindly check this articles for more information

 

https://community.lithium.com/t5/Admin-Metrics/Run-Community-Admin-User-reports/ta-p/5911

https://community.lithium.com/t5/Admin-Metrics/Run-Advanced-Community-Admin-reports/ta-p/136182

 

If my post is helpful and answers your question, please give "Kudos" and "Accept it as a Solution."

Thanks & Regards,
Abhishek Illindra

Reply
Loading...
Highlighted
Khoros Alumni (Retired) Khoros Alumni (Retired)
Khoros Alumni (Retired)

Re: User report by company name or company email?

Jump to solution
Also if the eventual list turns out abit longer and you are looking to assign a role to these to track them going forward it might we worth looking at the batch role assignment via importing user roles from a CSV file: https://community.lithium.com/t5/Roles-and-permissions/Import-user-roles-from-a-CSV-file/ta-p/24276

This way once you have a role assigned you can filter for these users' activities in LSI.

Khoros Best Practice until August 2019. Onwards posting as Claudius.
Learn how to master Khoros. Learn Best Practice in the Community Documentation
If you appreciate my efforts, please give me a kudo ↓
Accept as solution to help others find it faster.
Reply
Loading...
Highlighted
Inactive User
Not applicable

Re: User report by company name or company email?

Jump to solution

Thanks, @JasonHill. Found that and tried it, but my report exceeds 5,000 lines (we have a big community overall). I don't see a way to filter the report run by email (using that as a company identifier) prior to CSV export. 

0 Kudos
Reply
Loading...
Highlighted
Inactive User
Not applicable

Re: User report by company name or company email?

Jump to solution

@ClaudiusH Yes, I would love to get to this point! The thing that is messing me up is that a few hundred of these people have already signed up (and more signing up daily/weekly), so it would be a bear to manually assign a role at this point. 

0 Kudos
Reply
Loading...
Highlighted
Honored Contributor Honored Contributor
Honored Contributor

Re: User report by company name or company email?

Jump to solution

@Inactive User

 

The system enables you to export up to 100,000 users to the CSV file and the limit can be increased upon request to support.

 

Jason

 

 

 

 

Generic1.jpg

Reply
Loading...