Name

global.PortalAnalyzerUtils

Description

No description available

Script

var PortalAnalyzerUtils = Class.create();
PortalAnalyzerUtils.prototype = {
  initialize: function() {},
  // Get unique active user count by page
  getUserCountByPage: function(pageId) {

      var activePortalUserCount = 0;

      // Last 90 days user has accessed SP at least once
      try {
          var gr = new GlideAggregate('sys_user');
          gr.addAggregate('COUNT');
          var cond = gr.addJoinQuery('sp_log', 'sys_id', 'user');
          cond.addCondition('sys_created_on', '>=', 'javascript:gs.beginningOfLast90Days()');
          cond.addCondition('type', 'Page View');
          cond.addCondition('page', pageId);
          cond.addCondition('portal', '!=', 'NULL');
          gr.setWorkflow(false);
          gr.query();

          if (gr.next())
              activePortalUserCount = gr.getAggregate('COUNT');

      } catch (err) {
          activePortalUserCount = -1;
      }

      return activePortalUserCount;
  },

  // Get page count
  getPageViewCount: function(pageId) {

      var count = 0;

      try {
          var grLog = new GlideAggregate('sp_log');
          grLog.addAggregate('COUNT');
          grLog.addQuery('page', pageId);
          grLog.addQuery('sys_created_on', '>=', 'javascript:gs.beginningOfLast90Days()');
          grLog.addQuery('type', 'Page View');
          grLog.addQuery('portal', '!=', 'NULL');
          grLog.setWorkflow(false);
          grLog.query();

          if (grLog.next())
              count = grLog.getAggregate('COUNT');

      } catch (err) {
          count = -1;
      }

      return count;
  },
  type: 'PortalAnalyzerUtils'
};

Sys ID

e4d9acb1770b0010d81e7811a91061fd

Offical Documentation

Official Docs: