Return Return     Main page Main page      Update Update     PDF PDF     Choice of period :  Day Day  Week Week  All All  Customized Customized


           (m/d/yy)     



Request Hits by parent request Mean time (ms)Max time (ms) Standard deviationMean cpu time (ms) Mean allocated Kb % of system error Mean hits sql Mean time sql (ms)
http  /UserMgmt_Add.jsp GET  3,913 6,525 3,693 296 71,272 0.00 114 129
sql  graphSELECT UserID FROM userdetails where UserName = ?
 16.00 1 275 8     0.00    
sql  graphSELECT AccessType FROM usermgmt_details where AccessID in (1,5)
 16.00 1 49 2     0.00    
sql  graphSelect AccessTo from site_privilege_details where RuleID in(select RuleID from site_privilege_details where AccessCategory=2 and AccessTo in(0,1,5)) and AccessCategory=1
 1.00 1 49 3     0.00    
sql  graphSelect ud.UserName as userid, um.FullName, um.EmailAddress from userdetails ud inner join usermgmt_master um on ud.userid = um.userid where ud.UserID = ?
 1.00 1 40 3     0.00    
sql  graphSELECT GroupID FROM groupdetail where UserID in (SELECT UserID FROM userdetails where UserName=?) and GroupID=1
 1.00 0 1 0     0.00    
sql  graphselect Accessid from usermgmt_details where accessid = (SELECT AccessID FROM usermgmt_master where userID = ?) and (accessnodes like '%Share BSM Dashboard%' or accessnodes like '%Performance%')
 1.00 3 278 25     0.00    
sql  graphSELECT UserID FROM userdetails where UserName=?
 2.00 0 38 2     0.00    
sql  graphselect bsm.siteid from bsmrolebasedsystem_info bsm inner join resourcepollermapping rpm on bsm.siteid = rpm.siteid and bsm.systemid = rpm.resourceid where bsm.userid = ? and bsm.custompoller=1 and bsm.rootid = 0 and find_in_set(rpm.pollerid, ?) limit 1
 3.00 1 24 2     0.00    
sql  graphSELECT um.userid FROM usermgmt_master um,usermgmt_details ud where um.accessid = ud.accessid and ud.accessnodes like '%Performance%' and um.userid = ?
 1.00 1 31 3     0.00    
sql  graphselect br.siteid from bsmrolebasedsystem_info br inner join resourcepollermapping rpm on br.siteid =rpm.siteid and br.systemid = rpm.resourceid inner join businessservicemaster bsm on rpm.siteid = bsm.siteid and rpm.resourceid = bsm.resourceid inner join sla_master sm on bsm.siteid = sm.siteid and bsm.ruleid = sm.bsmRuleID where br.custompoller=1 and br.rootid = 0 and br.userid = ? limit 1
 1.00 5 33 5     0.00    
sql  graphselect bsm.siteid from bsmrolebasedsystem_info bsm inner join inventorymaster i on bsm.siteid = i.siteid and bsm.systemid = i.systemid inner join devicecategorymaster d on d.devicecategoryid = i.devicecategoryid where bsm.custompoller=2 and bsm.rootid = 0 and bsm.userid = ? and d.DeviceGroupID = ? and i.configpoll = 1 limit 1
 3.00 1 47 3     0.00    
sql  graphselect bsm.siteid from bsmrolebasedsystem_info bsm inner join resourcepollermapping rpm on bsm.siteid = rpm.siteid and bsm.systemid = rpm.resourceid inner join pollercategorydetails pcd on rpm.pollerid = pcd.pollerid where bsm.userid = ? and bsm.custompoller=1 and bsm.rootid = 0 and pcd.pollergroupid=? limit 1
 2.00 1 68 4     0.00    
sql  graphSELECT group_concat(PollerID) FROM pollercategorydetails where pollergroupid not in (67,63,130,257)
 1.00 1 17 1     0.00    
sql  graphselect bsm.siteid from bsmrolebasedsystem_info bsm inner join cp_sysinfo cp on bsm.siteid = cp.siteid and bsm.systemid = cp.monitoringid where bsm.custompoller=? and bsm.rootid = 0 and bsm.userid = ? and cp.iscustompoller=? limit 1
 2.00 1 37 3     0.00    
sql  graphSelect SettingValue from configsettings where SettingKEY='SYMANTEC_AV_COLLECTION'
 1.00 1 28 4     0.00    
sql  graphselect modulename from asset_module_master where moduleid=?
 21.00 1 256 4     0.00    
sql  graphSELECT PRIVILEGEID FROM privilege_master where PRIVILEGE_NAME='My Asset'
 1.00 1 3 0     0.00    
sql  graphSELECT GROUP_CONCAT(GroupID) FROM groupdetail where UserID=1
 8.00 1 108 4     0.00    
sql  graphSelect GroupID from groupdetail where UserID=1
 0.50 0 47 2     0.00    
sql  graphSelect AccessTo from site_privilege_details where RuleID in(select RuleID from site_privilege_details where AccessCategory=3 and AccessTo=1) and AccessCategory=1
 0.50 0 34 1     0.00    
sql  graphselect ifnull(group_concat(distinct accessto),'') from site_privilege_details where accesscategory = 4 and ruleid in (select ruleid from site_privilege_details where (accessto = 1 and accesscategory = 3) or (accesscategory = 2 and accessto in(Select GroupID from groupdetail where UserID=1))) and accessto not in(0)
 0.50 2 47 3     0.00    
sql  graphSELECT RoleID FROM bsmroleuserdetails where Type=2 and Value=1
 0.50 1 5 0     0.00    
sql  graphSELECT * FROM bsmroleuserdetails where Type=2 and Value=1
 0.50 1 21 2     0.00    
sql  graphselect userId from assetusers where AssetRoleID in (select AssetRoleID from assetroles where InheritedFrom='3' or InheritedFrom='1' or InheritedFrom='2') and UserId=1
 0.50 2 37 5     0.00    
sql  graphSELECT ProjectID, ProjectName FROM sd_project_master where Status=0 and ProjectID in (SELECT distinct(ProjectID) FROM sd_project_roles where ProjectRoleID in (SELECT ProjectRoleID FROM sd_project_roles_details where UserID=1))
 0.50 1 28 2     0.00    
sql  graphSelect count(RoleID) from bsmroledetails where iscustompoller = 0 and type = 4 and MonitoringID = 0 and RoleID in (2,1)
 1.50 1 18 1     0.00    
sql  graphSELECT AccessID FROM usermgmt_master where UserID=1
 0.50 0 2 0     0.00    
sql  graphSELECT * FROM privilege_details where GroupID in (select GroupID from groupdetail where UserID=1) and PrivilegeID=4
 0.50 1 14 1     0.00    
sql  graphSELECT GROUP_CONCAT(GroupID) FROM groupdetail where UserID=1848
 8.00 1 271 8     0.00    
sql  graphSelect GroupID from groupdetail where UserID=1848
 0.50 1 58 5     0.00    
sql  graphSelect AccessTo from site_privilege_details where RuleID in(select RuleID from site_privilege_details where AccessCategory=3 and AccessTo=1848) and AccessCategory=1
 0.50 0 3 0     0.00    

Powered by JavaMelody