Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Track who creates a system view? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Is there a way to track who creates a system view on CRM 2013? Not sure if there is a way to add another column for Created By.

    Thank you in advance for the time.

    Regards,
    Sue

    Monday, October 6, 2014 5:12 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Sue,

    Have another go with this query (using table instead of filteredview). Not sure what you mean by global, If you have more than one organisation in your implementation, then run this against each org. 

    SELECT	Name as viewname, CreatedOn, CreatedByName 
FROM	SavedQuery
WHERE	CreatedByName != 'SYSTEM'

    Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

    • Marked as answer by Sue_C Tuesday, October 7, 2014 6:12 PM
    Tuesday, October 7, 2014 4:46 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Sue,

    If you have administrator access to the CRM db, you can try this sql

    SELECT	v.name as viewname, 
		v.createdon, 
		u.fullname as createdby
FROM	FilteredSavedQuery v left join FilteredSystemUser u
			on v.createdby = u.systemuserid

    Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

    Monday, October 6, 2014 9:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Eric,

    Thank you for the query. Yes, I have administrator access to the database; but I just tested the query and no record was returned. =(

    Additionally, I am looking for any views that is created on the global level. Can I retrieve such information from the CRM db?


    • Edited by Sue_C Monday, October 6, 2014 10:10 PM clarification
    Monday, October 6, 2014 10:06 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Sue,

    Have another go with this query (using table instead of filteredview). Not sure what you mean by global, If you have more than one organisation in your implementation, then run this against each org. 

    SELECT	Name as viewname, CreatedOn, CreatedByName 
FROM	SavedQuery
WHERE	CreatedByName != 'SYSTEM'

    Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

    • Marked as answer by Sue_C Tuesday, October 7, 2014 6:12 PM
    Tuesday, October 7, 2014 4:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You are the life-saver! The query is exactly what I was looking for.

    Cheers,
    Sue

    Tuesday, October 7, 2014 6:12 PM