2019-06-23 12:04:31 http://homologacao.egestao.net:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2019-06-23 12:04:32 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=
select count(1) from users
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=
select count(1) from users
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=

select us_username, us_id, us_password, isnull(us_salt,0) us_salt, us_active
from users
where us_username = N'interno.egestao'
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=
update users set us_most_recent_login_datetime = getdate() where us_id = 536
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=
select us_id from users where us_username = N'interno.egestao'
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/default.aspx guid=a963e41c-b7f0-46f6-9274-098e36fac2c5
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=
insert into sessions (se_id, se_user) values('a963e41c-b7f0-46f6-9274-098e36fac2c5', 536)
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/default.aspx AppPath:/BugTracker
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/bugs.aspx url=/BugTracker/bugs.aspx
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/bugs.aspx sql=
/* check session */
					declare @project_admin int
					select @project_admin = count(1)
						from sessions
						inner join project_user_xref on pu_user = se_user
						and pu_admin = 1
						where se_id = 'a963e41c-b7f0-46f6-9274-098e36fac2c5';

					select us_id, us_admin,
					us_username, us_firstname, us_lastname,
					isnull(us_email,'') us_email,
					isnull(us_bugs_per_page,10) us_bugs_per_page,
					isnull(us_forced_project,0) us_forced_project,
					us_use_fckeditor,
					us_enable_bug_list_popups,
					og.*,
					isnull(us_forced_project, 0 ) us_forced_project,
					isnull(pu_permission_level, 2) pu_permission_level,
					@project_admin [project_admin]
					from sessions
					inner join users on se_user = us_id
					inner join orgs og on us_org = og_id
					left outer join project_user_xref
						on pu_project = us_forced_project
						and pu_user = us_id
					where se_id = 'a963e41c-b7f0-46f6-9274-098e36fac2c5'
					and us_active = 1
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/bugs.aspx sql=
declare @us_org int
			select @us_org = us_org from users where us_id = 536

			select qu_id, qu_desc
			from queries
			where (isnull(qu_user,0) = 0 and isnull(qu_org,0) = 0)
			or isnull(qu_user,0) = 536
			or isnull(qu_org,0) = @us_org
			order by qu_desc
2019-06-23 12:04:45 http://homologacao.egestao.net:8080/BugTracker/bugs.aspx sql=
select qu_id, qu_sql from queries where qu_id in
			(select us_default_query from users where us_id = 536)
2019-06-23 12:04:46 http://homologacao.egestao.net:8080/BugTracker/bugs.aspx 1181 868 1022
2019-06-23 12:04:46 http://homologacao.egestao.net:8080/BugTracker/bugs.aspx sql=
select isnull(pr_background_color,'#ffffff') [color], bg_id [id],
bg_short_desc [desc],
bg_reported_date [reported on],
isnull(rpt.us_username,'') [reported by],
isnull(pj_name,'') [project],
isnull(og_name,'') [organization],
isnull(ct_name,'') [category],
isnull(pr_name,'') [priority],
isnull(asg.us_username,'') [assigned to],
isnull(st_name,'') [status], 
isnull([Modulo],'') [Modulo], 
isnull([Prioridade Cliente],'') [Prioridade Cliente], 
isnull([Tempo Gasto],'') [Tempo Gasto]
from bugs
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join statuses on st_id = bg_status
where /* altered - both  */ (   bg_project in (4)
and  bg_category in (0,1,3,4,6,7,8,9,25)
and  bg_status in (0,1,2,4,6,9,10)
and bg_org <> 2
and Modulo <> '98.Equipamentos'
 ) AND (  (bg_project not in (
					select pu_project
					from project_user_xref
					where pu_user = 536
					and pu_permission_level = 0))  ) order by isnull([Modulo],'99'),  og_excecao DESC, og_indice_prioridade, og_indice_criticidade desc, og_adimplente DESC, og_contrato DESC, bg_reported_date desc
2019-06-23 12:04:47 http://homologacao.egestao.net:8080/BugTracker/bugs.aspx sql=
/* custom columns */ select sc.name, st.[name] [datatype], sc.length, sc.xprec, sc.xscale, sc.isnullable,
				mm.text [default value],
				isnull(ccm_dropdown_type,'') [dropdown type],
				isnull(ccm_dropdown_vals,'') [vals],
				isnull(ccm_sort_seq, sc.colorder) [column order],
				sc.colorder
				from syscolumns sc
				inner join systypes st on st.xusertype = sc.xusertype
				inner join sysobjects so on sc.id = so.id
				left outer join syscomments mm on sc.cdefault = mm.id
				left outer join custom_col_metadata on ccm_colorder = sc.colorder
				where so.name = 'bugs'
				and st.[name] <> 'sysname'
				and sc.name not in ('rowguid',
				'bg_id',
				'bg_short_desc',
				'bg_reported_user',
				'bg_reported_date',
				'bg_project',
				'bg_org',
				'bg_category',
				'bg_priority',
				'bg_status',
				'bg_assigned_to_user',
				'bg_last_updated_user',
				'bg_last_updated_date',
				'bg_user_defined_attribute',
				'bg_project_custom_dropdown_value1',
				'bg_project_custom_dropdown_value2',
				'bg_project_custom_dropdown_value3')
				order by sc.id, isnull(ccm_sort_seq,sc.colorder)
2019-06-23 12:04:49 http://homologacao.egestao.net:8080/BugTracker/bugs.aspx sql=
delete from sessions
			where se_id = N'a963e41c-b7f0-46f6-9274-098e36fac2c5'
			or datediff(d, se_date, getdate()) > 2
2019-06-23 12:04:49 http://homologacao.egestao.net:8080/BugTracker/default.aspx?msg=logged+off url=/BugTracker/default.aspx?msg=logged+off
2019-06-23 12:04:50 http://homologacao.egestao.net:8080/BugTracker/default.aspx?msg=logged+off sql=
select count(1) from users
2019-06-23 12:08:40 http://homologacao.egestao.net:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2019-06-23 12:08:40 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=
select count(1) from users
2019-06-23 12:08:40 http://homologacao.egestao.net:8080/BugTracker/default.aspx Cannot open database "GERAL" requested by the login. The login failed.
Login failed for user 'sa'.
2019-06-23 12:08:40 http://homologacao.egestao.net:8080/BugTracker/default.aspx SERVER=192.168.1.112;DATABASE=GERAL;Persist Security Info=false;USER ID=sa;PWD=qquma@1
2019-06-23 13:30:15 http://homologacao.egestao.net:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2019-06-23 13:30:15 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=
select count(1) from users
2019-06-23 13:30:15 http://homologacao.egestao.net:8080/BugTracker/default.aspx Cannot open database "GERAL" requested by the login. The login failed.
Login failed for user 'sa'.
2019-06-23 13:30:15 http://homologacao.egestao.net:8080/BugTracker/default.aspx SERVER=192.168.1.112;DATABASE=GERAL;Persist Security Info=false;USER ID=sa;PWD=qquma@1
2019-06-23 18:31:23 http://homologacao.egestao.net:8080/BugTracker/default.aspx url=/BugTracker/default.aspx
2019-06-23 18:31:23 http://homologacao.egestao.net:8080/BugTracker/default.aspx sql=
select count(1) from users