• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Network Application Monitoring /
  • NAM Open Q&A /
avatar image
Question by Bob Z. · Jun 22, 2015 at 01:29 PM ·

How do I get a list of all users and email addresses.

Is there a way to write a report where I can get a list of user names and email addresses.  

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

3 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Bob Z. · Jun 22, 2015 at 04:46 PM

Adam, I just used SQL Server Mgt Stuido directly on the DB to run the query, but I only received back the local users, (36 of 360 users) none of the LDAP users were returned.  I have been using DC RUM Prior to the creation of CSS, so the user list is also available in the CAS.  Is there a table in the CAS DB that I can query to get my results.  

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Adam P. ♦♦ · Jun 22, 2015 at 05:02 PM 0
Share

It would be:

select * from wslastused

but it's going to give you only user names for compatibility purposes.

Right, the CSS query returns only local users. For LDAP users you should rather use:

select PRINCIPAL_NAME, PRIMARY_EMAIL_ADDRESS from SECURITY_PRINCIPAL

but it will still not get the e-mails that are retrieved dynamically.

 

However Development helped us to find out ... CSV export in CSS :)

Go to CSS -> Users -> Export All

 

(smile)

avatar image

Answer by Adam P. · Jun 22, 2015 at 02:36 PM

Bob,

I'm afraid the only way is to run:

select PRINCIPAL_NAME, PRIMARY_EMAIL_ADDRESS from SECURITY_PRINCIPAL WHERE PRIMARY_EMAIL_ADDRESS IS NOT null

query against CSS DB.

Feel free to add such ENH on our forum.

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Bob Z. · Jun 22, 2015 at 03:36 PM 0
Share

Thanks Adam, can you please remind me how to launch the SQL Query tool. 

avatar image

Answer by Ulf T. · Jun 22, 2015 at 01:51 PM

Observed Users in a traffic flow or configured users in the application?

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Bob Z. · Jun 22, 2015 at 02:01 PM 0
Share

A list of all users with access to DC RUM.  I need to send an email to all users informing them of a system outage. 

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Forum Tags

esm siebel Dynatrace Managed license nam probe wan citrix dna rest api configuration mq alerting NAM 2018 dashboard dcrumadvisory reports css nam universal decode database mobileapp RUM ads sap nam console scripting nam server sequence transactions nam 2019 upgrade
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A