apnagyan

git clone https://devendra_kumarsingh@bitbucket.org/***********/automonitoring.git 1) create a virtual environment virtualenv automonitoring_env  for python- 2.7      virtualenv -p /usr/bin/python automonitoring_env 2) cd automonitoring_env/   // ENVIRONEMNT FOLDER 3)  source bin/activate 4)  cd ../automonitoring  // PROJECT FOLDER  5)  pip install -r pip_req.txt  To set a environment in pycharm - 1) click on app  2) edit configuration 3) add environment- dev then run  GET CLONE RUN- virtualenv PROJECT_FOLDER_NAME_env OR virtualenv -p /usr/bin/python fileupdate_env CD PROJECT_FOLDER_NAME_env THEN RUN-> . bin/activate OR source fileupdate_env/bin/activate CD ../SOURVE_CODE_FOLDER/ THEN RUN - pip install -r pip_req.txt   SET ENVIRONMENT-> CLICK ON APP-> EDIT CONFIGURATION THEN ADD-> “ENV AND VALUES DEV” To set  a virtual environment in ubuntu- 1) pip install virtualenvwrapper  2) vim ~/.bashrc 3) export WORKON_HOME

1) cd /Users/devendra.kumarsingh/.composer/vendor/bin/app   // working  directory 2) php artisan serve

SELECT count (main.id) as count ,main.status, ( sum ( count (main.id)) over ()) as total FROM Tickets main   JOIN Groups Groups_1 ON ( LOWER (Groups_1. Domain ) = 'rt::ticket-role' ) AND ( LOWER (Groups_1. Name ) = 'requestor' )   AND (Groups_1. Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2   ON (CachedGroupMembers_2.Disabled = '0' )   AND ( CachedGroupMembers_2.GroupId = Groups_1.id ) JOIN Users Users_3   ON ( Users_3.id = CachedGroupMembers_2.MemberId )   JOIN queues queues_3 ON ( main.queue = queues_3.id) JOIN users users_4 ON ( main. owner = users_4.id ) WHERE (main.IsMerged IS NULL )   AND (main.Status != 'deleted' ) AND (main. Type = 'ticket' )   and main.created:: timestamp AT time zone 'utc' >= '2017-11-20 23:06:06'   and main.queue in ( 5 , 6 , 7 , 8 ) and main.created:: timestamp AT time zone 'utc' <= '2018-07-11 06:14:26'  

drop view ticket_resolution; create view ticket_resolution as   select t1.id,t1.queue,t1.type,t1.owner,t1.subject,t1.initialpriority,t1.finalpriority,t1.priority,t1.timeestimated,t1.timeworked,t1.status,t1.sla,t1.timeleft, t1.told,t1.starts::timestamp AT time zone 'utc' as starts,t1.started::timestamp AT time zone 'utc' as started,t1.due::timestamp AT time zone 'utc' due,t1.resolved::timestamp AT time zone 'utc' resolved,t1.lastupdatedby,t1.lastupdated::timestamp AT time zone 'utc' lastupdated,t1.creator,t1.created::timestamp AT time zone 'utc' as created , floor((EXTRACT(EPOCH FROM current_timestamp) - EXTRACT(EPOCH FROM t1.created::timestamp AT time zone 'utc'))/60)::integer, case when ( floor( (EXTRACT(EPOCH FROM current_timestamp)   - ( EXTRACT(EPOCH FROM t1.started::timestamp AT time zone 'utc') +coalesce((sum(t2.hold_end_time-t2.hold_start_time))::integer,0)) )/60 )::integer < 3

ADDED TWO NEW CONDITION- case when (EXTRACT(EPOCH FROM (created))/60>30 and sla='Normal SR' and status='new' then 1 else 0 end as SLA_NORML_ITDSK_BREACH, case when (EXTRACT(EPOCH FROM (created))/60>15 and sla='High Priority SR' and status='new' then 1 else 0 end as SLA_HIGH_ITDSK_BREACH, # SO  FINAL      VIEW FOR TICKETS IS AS GIVEN BELOW-------====>>> CREATE VIEW tickets_master AS select id,effectiveid,ismerged,queue,type,owner,subject,initialpriority,finalpriority,priority,timeestimated,timeworked,status,sla,timeleft,told,starts::timestamp AT time zone 'utc' as starts,started::timestamp AT time zone 'utc' as started,due::timestamp AT time zone 'utc' due,resolved::timestamp AT time zone 'utc' resolved,lastupdatedby,lastupdated::timestamp AT time zone 'utc' lastupdated,creator,created::timestamp AT time zone 'utc' as created ,case when (EXTRACT(EPOCH FROM (created::timestamp AT time