Monitoring JavaMelody on /SapphireIMS

Return

Main page

Update

PDF Choice of period : Day

Day

Week

All

Customized

Request	Hits by parent request	Mean time (ms)	Max time (ms)	Standard deviation	Mean cpu time (ms)	Mean allocated Kb	Mean hits sql	Mean time sql (ms)
/UserMgmt_Add.jsp GET		3,913	6,525	3,693	296	71,272	114	129
SELECT UserID FROM userdetails where UserName = ?	16.00	1	86	3
SELECT AccessType FROM usermgmt_details where AccessID in (1,5)	16.00	1	49	9
Select 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
SELECT SiteID FROM sitemaster where Status=1 and SiteID not in (0) limit 1	1.00	1	2	0
Select 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
SELECT GroupID FROM groupdetail where UserID in (SELECT UserID FROM userdetails where UserName=?) and GroupID=1	1.00	0	1	0
select 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	0	5	0
select um.userid from usermgmt_master um,bsmroleuserdetails brd where um.userid = ? and (um.accessid=brd.value or um.userid= brd.value)	1.00	9	172	36
SELECT UserID FROM userdetails where UserName=?	2.00	0	38	3
select 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	3
SELECT 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
select 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
select 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
select 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	2	68	5
SELECT group_concat(PollerID) FROM pollercategorydetails where pollergroupid not in (67,63,130,257)	1.00	1	18	2
select 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
Select SettingValue from configsettings where SettingKEY='SYMANTEC_AV_COLLECTION'	1.00	1	27	3
select modulename from asset_module_master where moduleid=?	21.00	1	256	4
SELECT PRIVILEGEID FROM privilege_master where PRIVILEGE_NAME='My Asset'	1.00	1	19	3
SELECT GROUP_CONCAT(GroupID) FROM groupdetail where UserID=1	8.00	1	108	3
Select GroupID from groupdetail where UserID=1	0.50	0	47	4
Select 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
select 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	1	47	3
SELECT RoleID FROM bsmroleuserdetails where Type=2 and Value=1	0.50	1	5	0
SELECT * FROM bsmroleuserdetails where Type=2 and Value=1	0.50	1	21	2
select 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
SELECT 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	3	0
Select count(RoleID) from bsmroledetails where iscustompoller = 0 and type = 4 and MonitoringID = 0 and RoleID in (2,1)	1.50	1	18	1
SELECT AccessID FROM usermgmt_master where UserID=1	0.50	0	2	0
SELECT * FROM privilege_details where GroupID in (select GroupID from groupdetail where UserID=1) and PrivilegeID=4	0.50	1	14	1
SELECT GROUP_CONCAT(GroupID) FROM groupdetail where UserID=1848	8.00	1	271	7
Select GroupID from groupdetail where UserID=1848	0.50	2	264	17
Select 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
SELECT RoleID FROM bsmroleuserdetails where Type=2 and Value=1848	0.50	3	20	4
SELECT 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=1848))	0.50	12	180	44
Select count(RoleID) from bsmroledetails where iscustompoller = 0 and type = 4 and MonitoringID = 0 and RoleID in (1)	1.50	1	5	1