• Forums
    • Public Forums
      • Community Connect
      • Dynatrace SaaS & Managed
        • Dynatrace SaaS & Managed Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Free Trial
        • AppMon & UEM Open Q&A
        • AppMon & UEM Plugins
      • Data Center RUM
        • DC RUM Open Q&A
        • Enterprise Synthetic Monitoring
      • Dynatrace Synthetic Monitoring
        • Dynatrace Synthetic Open Q&A
        • Dynatrace Synthetic EAP Feedback
      • Keynote Synthetic Monitoring
        • Keynote Synthetic Open Q&A
        • Keynote Synthetic EAP Feedback
      • BSM Open Q&A
      • Server Monitoring Open Q&A
      • Dynatrace Open Q&A en Español
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Dennis M. · Feb 23, 2015 at 11:38 PM ·

SQL bind values filled with asterix " * "

Hi,

Any idea why for the most SQL statements I see bind values but for some I have only " * " (asterix)? While I can imagine that for some bind values this might be ok due to the fact that it is binary data, I dont understand that for others...  any idea? (since I see a lot of bind values already, I can assume configuration is correct?!)

Best regards,
Dennis

Comment

People who like this

0 Show 0
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

1 Reply

· Add your reply
  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Ahmed E. · Feb 23, 2015 at 11:52 PM

Dennis, do you have a screenshot of this?

Ahmed

Comment

People who like this

0 Show 6 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Dennis M. · Feb 24, 2015 at 12:58 AM 0
Share

Hi Ahmed,

No, I dont unfortunately. Restricted customer access.

Best regards,
Dennis

avatar image Ahmed E. Dennis M. · Feb 24, 2015 at 01:15 AM 0
Share

I assume you already enabled capturing bind values in the sensor configuration. Did you also check if the privacy settings are masking the bind values? Settings > dynaTrace Server > Settings > Confidential Strings


Ahmed

avatar image Dennis M. Ahmed E. · Feb 24, 2015 at 01:25 AM 0
Share

Hi Ahmed,

Thanks, I checked the server settings. It was activated there. However, strange that I see it for some and for some not. Also, the description for these server settings say, that it is for setting confidential strings when "exporting a session". However, I was looking at live data.

Best regards,
Dennis

avatar image Ahmed E. Dennis M. · Feb 24, 2015 at 01:55 AM 0
Share

Dennis, which Dyntrace AM version is used there? I think that the Confidential String setting also applies to live data as per the Hint: "This will apply to live / stored sessions and to dashboards where the user does not have permissions to see the values."

It is indeed strange that you see the bind values for some statements and do not see them for others. Is there any difference in DB platform or character encoding that might cause this?

avatar image Rick B. Ahmed E. · Feb 24, 2015 at 03:55 AM 0
Share

Is it that you either see asterisks or "preparation"?  We put "preparation" to differentiate between executed and prepared statements, this wouldn't be censored out as with other confidential strings if your user doesn't have the permission "Read Confidential Strings"

 

Rick B

avatar image Dennis M. Rick B. · Feb 24, 2015 at 07:31 PM 0
Share

Thanks for all your replies.. I saw preparation as well after I unchecked the checkbox for the setting Ahmed mentioned. As I saw some values, I dont think it's the rights of the user. It is dynatrace 6.0.0.7153. I thought maybe it is the way binary data is displayed?!

Your answer

Hint: You can notify a user about this post by typing @username

Up to 5 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Welcome the
Dynatrace Community Forums

Check out the Forum User Guide and Forum Guidelines to learn how to get started.

Community Member of the Month
August 2017

Announcing Dynatrace's Community Member of the Month for August 2017, Rick B.! Click here to read more!

Follow this Question

Answers Answers and Comments

3 People are following this question.

avatar image avatar image avatar image

Forum Tags

nginx upgrade java diagnostics dotnet docker 6.5 ios appmonsaas database sensor performance warehouse chart hybris integration 6.3+ service metrics web performance monitoring production incidents systemprofile transactionflow test automation measures business transaction migration php android javascript dashlet server monitoring purelytics nodejs 6.2 system profile splunk uem appmon reporting framework license appmon 7 mobile monitoring regex collector installation adk licensing messagebroker web services apache xml support iis plugin dashboard rest reports 7.0 mainframe 6.1 client configuration continuous delivery sensors security rest api web dashboard agent alerting window 6.3 administration
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace SaaS & Managed
      • Dynatrace SaaS & Managed Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Free Trial
      • AppMon & UEM Open Q&A
      • AppMon & UEM Plugins
    • Data Center RUM
      • DC RUM Open Q&A
      • Enterprise Synthetic Monitoring
    • Dynatrace Synthetic Monitoring
      • Dynatrace Synthetic Open Q&A
      • Dynatrace Synthetic EAP Feedback
    • Keynote Synthetic Monitoring
      • Keynote Synthetic Open Q&A
      • Keynote Synthetic EAP Feedback
    • BSM Open Q&A
    • Server Monitoring Open Q&A
    • Dynatrace Open Q&A en Español