{"id":12089,"date":"2022-10-25T12:00:17","date_gmt":"2022-10-25T17:00:17","guid":{"rendered":"https:\/\/www.mrc-productivity.com\/docs\/?post_type=ht_kb&#038;p=12089"},"modified":"2025-06-13T13:08:42","modified_gmt":"2025-06-13T18:08:42","slug":"auditing-application-usage","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/auditing-application-usage","title":{"rendered":"Auditing Application Usage"},"content":{"rendered":"\n<p>A frequently asked question about m-Power is how to track application usage. Tracking applications such as which apps are used by whom and when can be extremely helpful in understanding  how your users work with their apps. When the time comes to update your applications, having these metrics available can make prioritizing apps easier by knowing the key apps versus the underutilized ones. This article will explain the two methods available for application auditing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Hosted App Tracker<\/h2>\n\n\n\n<p>This option is a simple and complete turn-key solution. A script is added into the dictionary footer and any time an application is loaded, key app information is sent to our hosted server.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-success\">This service is hosted by mrc free of charge for all customers on active support.<\/p>\n\n\n\n<p>Pre-defined reports and dashboards are available at stats.mrc-productivity.com. Once signed in you are able customize\/create your dashboards based on the data sent by your applications. <\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">This data is secured and you can only access your company&#8217;s data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-92.png\"><img decoding=\"async\" width=\"900\" height=\"377\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-900x377.png\" alt=\"\" class=\"wp-image-12091\" srcset=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-900x377.png 900w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-300x126.png 300w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-150x63.png 150w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-768x322.png 768w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-50x21.png 50w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-1536x643.png 1536w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-60x25.png 60w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-92-100x42.png 100w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-92.png 1881w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/a><\/figure>\n\n\n\n<p>Please contact mrc for the appropriate script to load into your m-Power footer.<\/p>\n\n\n\n<p>There are a plethora of reports and graphs available on stats.mrc-productivity.com. You are able to completely customize and add dashboards to your app tracker. These are the areas mrc wishes to point out to get you started:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Date Filtering<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-96.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"478\" height=\"372\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-96.png\" alt=\"\" class=\"wp-image-12107\" srcset=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-96.png 478w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-96-300x233.png 300w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-96-150x117.png 150w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-96-50x39.png 50w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-96-60x47.png 60w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-96-100x78.png 100w\" sizes=\"(max-width: 478px) 100vw, 478px\" \/><\/a><\/figure>\n\n\n\n<p>By default, the dashboard will load with yesterday&#8217;s date. Clicking the date button will open the ability to filter by day, week, month, year, or a custom date range. <\/p>\n\n\n\n<p>Included in this is the ability to compare the selected date against the previous period, previous year, or a custom selection.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pages Report<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-97.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"900\" height=\"517\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-97-900x517.png\" alt=\"\" class=\"wp-image-12108\" srcset=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-97-900x517.png 900w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-97-300x172.png 300w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-97-150x86.png 150w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-97-768x441.png 768w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-97-50x29.png 50w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-97-60x34.png 60w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-97-100x57.png 100w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-97.png 1161w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/a><\/figure>\n\n\n\n<p>From the <strong>Behavior<\/strong> left-hand menu option, select <strong>Pages<\/strong>. This will run a report breaking down the individual applications that are visited within the selected date range. You will see the dictionary and application that was ran.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">User IDs Report<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-98.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"900\" height=\"461\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-98-900x461.png\" alt=\"\" class=\"wp-image-12109\" srcset=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-98-900x461.png 900w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-98-300x154.png 300w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-98-150x77.png 150w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-98-768x394.png 768w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-98-50x26.png 50w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-98-60x31.png 60w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-98-100x51.png 100w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-98.png 1153w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/a><\/figure>\n\n\n\n<p>Some may be interested in user activity. From the <strong>Visitors<\/strong> left-hand menu option, select <strong>User IDs<\/strong>. This will run a report breaking down individual users visits within the selected date range. Hovering over a User ID row will offer more detailed information about the specific user.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">m-Power Based Auditing<\/h2>\n\n\n\n<p>The hosted turn-key solution is quick and simple. However, some customers wish to have full access to their data for more robust reporting. This approach uses native m-Power features with a simple line of jQuery (provided by mrc below) to accomplish the tracking.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Create Audit Table<\/h3>\n\n\n\n<p>You will first need a table created on your licensed database that will store all of your tracked application data. These fields typically include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>AUDITID<\/strong> &#8212; Auto-sequential record ID.<\/li>\n\n\n\n<li><strong>AUDITDATE<\/strong> &#8212; Date the application was loaded.<\/li>\n\n\n\n<li><strong>AUDITTIME<\/strong> &#8212; Time the application was loaded.<\/li>\n\n\n\n<li><strong>AUDITUSER<\/strong> &#8212; Signed in user whom loaded the app. <strong>Note:<\/strong> Dictionary security must be enabled to record the user.<\/li>\n\n\n\n<li><strong>AUDITAPP<\/strong> &#8212; The application number which was loaded in the URL.<\/li>\n\n\n\n<li><strong>AUDITDICT<\/strong> &#8212; The dictionary of the application that was loaded.<\/li>\n<\/ul>\n\n\n\n<p>Register this table to your m-Power dictionary.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Create Audit Maintainer<\/h3>\n\n\n\n<p>Create a Single Row Maintainer over the audit table created in the last step.<\/p>\n\n\n\n<p>In the <strong>Dimensions<\/strong> screen, select the AUDITID field and check the box for <strong>Auto Sequence<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-95.png\"><img decoding=\"async\" width=\"900\" height=\"309\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-95-900x309.png\" alt=\"\" class=\"wp-image-12095\" srcset=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-95-900x309.png 900w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-95-300x103.png 300w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-95-150x51.png 150w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-95-768x263.png 768w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-95-50x17.png 50w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-95-60x21.png 60w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-95-100x34.png 100w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-95.png 991w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/a><\/figure>\n\n\n\n<p>From <strong>Edit Field Settings<\/strong>, change the <strong>Basic Field Attributes<\/strong> dropdown to <strong>Form Validation and Auditing<\/strong>. In the Audit column, select the appropriate auditing for corresponding fields (i.e. Add Date for the AUDITDATE field).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-94.png\"><img decoding=\"async\" width=\"900\" height=\"353\" src=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-900x353.png\" alt=\"\" class=\"wp-image-12094\" srcset=\"https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-900x353.png 900w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-300x118.png 300w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-150x59.png 150w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-768x301.png 768w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-50x20.png 50w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-1536x602.png 1536w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-60x24.png 60w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-94-100x39.png 100w, https:\/\/www.mrc-productivity.com\/docs\/images\/image-94.png 1539w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/a><\/figure>\n\n\n\n<p>Finally, compile your maintainer.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Dictionary Footer<\/h3>\n\n\n\n<p>Open <strong>Admin -&gt; HTML\/JS\/CSS Files -&gt; Header\/Footer HTML<\/strong>. In the footer section, paste the below code. <strong>Note: <\/strong>Be sure replace DICTIONARY.MXXXXXs with your actual dictionary and maintainer app number.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;script>\njQuery.get('DICTIONARY.MXXXXXs?action_mode=add&amp;AUDITAPP=${page.app}&amp;AUDITDICT=${visitor.library}&amp;one_step=1');    \n&lt;\/script><\/code><\/pre>\n\n\n\n<p>Save the footer.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">mrc recommends this script to only be used in the production footer instead of development. This ensures the data collected is from your production users, not from development testing. After promoting the footer file, simply remove the script from the footer in development. Additionally, you may want to remove the footer from Promote to Production to prevent accidentally promoting the file to production. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Runtime Usage<\/h3>\n\n\n\n<p>Each time an application is loaded, a record is inserted into the audit table. Once you have data, you may build any\/all reports you wish over the tracked data. You may wish to <strong>Filter <\/strong>the auditing by date, user, dictionary, or app fields. You may also group the report data by setting the date, user, dictionary, or app field as the <strong>Dimension<\/strong> key in the report.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A frequently asked question about m-Power is how to track application usage. Tracking applications such as which apps are used by whom and when can be extremely helpful in understanding how your users work with their apps. When the time comes to update your applications, having these metrics available can&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[266],"ht-kb-tag":[280],"class_list":["post-12089","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-general","ht_kb_tag-audit"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/12089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=12089"}],"version-history":[{"count":13,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/12089\/revisions"}],"predecessor-version":[{"id":14626,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/12089\/revisions\/14626"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=12089"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=12089"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=12089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}