locked
How do I know how many times a Feature (ID + NAME) has been used with the Log database? RRS feed

  • Question

  • Hi,

    I have been digging inside the RequestUsage table in the Log database. Threre is a field called FeatureID I can only join with FeatureUsage. My problem is, I want to know what featureID means in terms of name, I don't want an ID I want a name of the feature. So... I have been trying to link the FeatureID with the FeatureID from the Content Database, and the table "FeatureTracking" but the id's don't seem to much.

    SO! HOW CAN I GET THE NAME OF THE FEATURE BY PASSING THE FEATUREID FROM THE REQUESTUSAGE TABLE?

    Thanks a lot!!!!


    Gabriel Renom -Innovation Developer - DWF LLP - Blog: <a href="http://www.gabrielrenom.net"> www.gabrielrenom.net</a>

    Thursday, October 10, 2013 1:48 PM

Answers

  • Hi Gabriel,

    For Your Information (and maybe you know already), directly accessing SharePoint database is not recommended. If you make any changes in the database future upgrade might fail.

    Anyway, if you mean feature folder name, then you need to query Config database, objects table. In objects table you will find feature properties (ID, folder name etc.) in the properties field.

    However, if you are looking for Feature Title, then you don't have much option the feature title may come from Resource file (different resource file for different language), the title may be hardcoded in the feature.xml file also. So you need SharePoint Object Model I think to get feature title.

    But anyway, you can share what you are trying to do?


    Thanks,
    Sohel Rana
    http://ranaictiu-technicalblog.blogspot.com

    • Marked as answer by Qiao Wei Monday, October 21, 2013 9:54 AM
    Friday, October 11, 2013 2:15 AM

All replies

  • Hi Gabriel,

    For Your Information (and maybe you know already), directly accessing SharePoint database is not recommended. If you make any changes in the database future upgrade might fail.

    Anyway, if you mean feature folder name, then you need to query Config database, objects table. In objects table you will find feature properties (ID, folder name etc.) in the properties field.

    However, if you are looking for Feature Title, then you don't have much option the feature title may come from Resource file (different resource file for different language), the title may be hardcoded in the feature.xml file also. So you need SharePoint Object Model I think to get feature title.

    But anyway, you can share what you are trying to do?


    Thanks,
    Sohel Rana
    http://ranaictiu-technicalblog.blogspot.com

    • Marked as answer by Qiao Wei Monday, October 21, 2013 9:54 AM
    Friday, October 11, 2013 2:15 AM
  • Directly querying the SharePoint Usage and Health Logging database is fully supported. You are correct in stating the querying any other SharePoint databases directly is definitely not recommended (especially on a Production environment). Directly querying other SharePoint databases on regular basis will also likely put your deployment in an unsupported state.
    Wednesday, November 27, 2013 10:32 AM
  • Thanks Brian for sharing the information. I didn't even know that. For reference: http://technet.microsoft.com/en-us/library/jj715694.aspx

    Thanks,
    Sohel Rana
    http://ranaictiu-technicalblog.blogspot.com

    Thursday, November 28, 2013 12:55 AM