locked
Track who creates a system view? RRS feed

  • Question

  • 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

  • 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

  • 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
  • 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
  • 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
  • You are the life-saver! The query is exactly what I was looking for.

    Cheers,
    Sue

    Tuesday, October 7, 2014 6:12 PM