my note 5

 --VOLUMNE BASE REPORT --(PRODUCTTION)



USE ODS

--###Incident_SRMS_Specific

select count(*) 

FROM   ODS.DBO.incident_srms_specific IT WITH (NOLOCK)                    

LEFT OUTER JOIN ODS.DBO.incident_srms_attention IA WITH (NOLOCK)                    

ON ( IT.incident_number =IA.incident_number )                    

WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               

IT.National_Account_ID in('42100372'

,'43200131'

,'43203872'

,'44100131'

,'44100162'

,'44100730'

,'44111022'

,'44111322'

,'44133532'

,'44200171'

,'45100371'

,'47201271'

,'49100472')                     

and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())--4500042

--##ITIL_Transaction

select count(*) 

FROM  ods.dbo.ITIL_Transaction I with (nolock) 

LEFT OUTER JOIN  ODS.DBO.Incident_SRMS_Specific IT  with (nolock) 

ON I.Transaction_ID = IT.Incident_Number

LEFT OUTER JOIN ODS.DBO.[incident_srms_attention ] IA with (nolock)                                    

ON IT.Incident_Number = IA. Incident_Number 

WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               

IT.National_Account_ID in   ('42100372'

,'43200131'

,'43203872'

,'44100131'

,'44100162'

,'44100730'

,'44111022'

,'44111322'

,'44133532'

,'44200171'

,'45100371'

,'47201271'

,'49100472')                                 

and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())--4500867

--####incident


select count(*) 

FROM  ods.dbo.incident I with (nolock) 

LEFT OUTER JOIN  ODS.DBO.Incident_SRMS_Specific IT  with (nolock) 

ON I.Transaction_ID = IT.Incident_Number

LEFT OUTER JOIN ODS.DBO.[incident_srms_attention ] IA with (nolock)                                    

ON IT.Incident_Number = IA. Incident_Number 

WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               

IT.National_Account_ID in   ('42100372'

,'43200131'

,'43203872'

,'44100131'

,'44100162'

,'44100730'

,'44111022'

,'44111322'

,'44133532'

,'44200171'

,'45100371'

,'47201271'

,'49100472')                                 

and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())--2151488


--###incident_srms_attention


SELECT COUNT (*)

FROM  ods.dbo.incident_srms_attention IT with (nolock) 

--LEFT OUTER JOIN

inner join ODS.DBO.Incident_SRMS_Specific IA with (nolock) 

ON IT.Incident_Number = IA. Incident_Number 

WHERE IT.DATASOURCEID=42 AND IT.attention_completion_code='C' AND IA.National_Account_ID in 

  ('42100372'

,'43200131'

,'43203872'

,'44100131'

,'44100162'

,'44100730'

,'44111022'

,'44111322'

,'44133532'

,'44200171'

,'45100371'

,'47201271'

,'49100472')                  

and  IT.Completion_DateTime<=DATEADD(d,-90, getdate())--2197934


----

--##Incident_Srms_Backlog

select count(*) 

FROM  [172.16.123.70].ods.dbo.Incident_Srms_Backlog  FS with (nolock)                                    

LEFT OUTER JOIN [172.16.123.70].ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    

ON FS.Sourcesr = ISS. Incident_Number

LEFT OUTER JOIN [172.16.123.70].ODS.DBO.incident_srms_attention IA

on ISS.incident_number = IA. Incident_Number

WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               

FS.NationalAccount in ('0043200131',

'0045100371')                     

and  IA.Completion_DateTime<=DATEADD(d,-90, getdate()) 

--

--##Fs_Serviceincidents

select count(*) 

FROM  [172.16.123.70].ods.dbo.Fs_Serviceincidents  FS with (nolock)                                    

LEFT OUTER JOIN [172.16.123.70].ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    

ON FS.Sourcesr = ISS. Incident_Number

LEFT OUTER JOIN [172.16.123.70].ODS.DBO.incident_srms_attention IA

on ISS.incident_number = IA. Incident_Number

WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               

FS.NationalAccount in ('0043200131',

'0045100371')                     

and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())

-----------------------------------------------------------------------------------------------------------
use ods
select count(*) 
FROM  ods.dbo.Incident_Srms_Backlog  FS with (nolock)                                    
LEFT OUTER JOIN ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Sourcesr = ISS. Incident_Number
LEFT OUTER JOIN ODS.DBO.incident_srms_attention IA
on ISS.incident_number = IA. Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
FS.NationalAccount in ('0043200131',
'0045100371')                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate()) 

use customerredaction
select count(*)                                      
FROM ODS.DBO.Incident_Srms_Tsdb  tb                                            
INNER JOIN [vw_UCAREPII_TXNS] Vw                                            
ON tb.Incident_Number = Vw.Incident_Number                  
WHERE VW.Datasourcename='SRMS' --11 

select count(*) 
FROM  ods.dbo.Incident_Srms_Backlog  FS with (nolock)                                    
LEFT OUTER JOIN ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Sourcesr = ISS. Incident_Number
LEFT OUTER JOIN ods.DBO.incident_srms_attention IA
on ISS.incident_number = IA. Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
FS.NationalAccount in ('0043200131',
'0045100371')                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())  -9
--168103

select count(*) 
FROM ODS.DBO.Incident_Srms_Tsdb TB                   
INNER JOIN [vw_UCAREPII_TXNS] Vw                                            
ON tb.Incident_Number = Vw.Incident_Number                 
WHERE  VW.Datasourcename='SRMS'



select count(*)
FROM ODS.DBO.Incident_Srms_Backlog  tb                                            
INNER JOIN [vw_UCAREPII_TXNS] Vw                                            
ON tb.SourceSR = Vw.Incident_Number                   
WHERE VW.Datasourcename='SRMS'-------------------------------
--------------------------------------------------------------------------------------------------------------------
--1
use CUSTOMERREDACTION
select count(*) 
FROM  ods.dbo.Incident_SRMS_Specific tb  with (nolock)                                    
INNER JOIN [vw_UCAREPII_TXNS] Vw                                      
ON tb.Incident_Number = Vw.Incident_Number           
WHERE VW.Datasourcename='SRMS' --2197438
                               
--2                              
select count(*) 
FROM  ods.dbo.incident_srms_attention tb  with (nolock)                                    
INNER JOIN [vw_UCAREPII_TXNS] Vw                                      
ON tb.Incident_Number = Vw.Incident_Number           
WHERE VW.Datasourcename='SRMS'--5664415
--3
select count(*) 
FROM  ods.dbo.incident tb  with (nolock)                                    
INNER JOIN [vw_UCAREPII_TXNS] Vw                                      
ON tb.Incident_Number = Vw.Incident_Number           
WHERE VW.Datasourcename='SRMS'
--4
select count(*) 
FROM  ods.dbo.ITIL_Transaction tb  with (nolock)                                    
INNER JOIN [vw_UCAREPII_TXNS] Vw                                      
ON tb.Transaction_ID = Vw.Incident_Number           
WHERE VW.Datasourcename='SRMS'
--5
select count(*) 
FROM  ods.dbo.Fs_Serviceincidents tb  with (nolock)                                    
INNER JOIN [vw_UCAREPII_TXNS] Vw                                      
ON tb.SourceSR = Vw.Incident_Number           
WHERE VW.Datasourcename='SRMS' 
--6
select count(*) 
FROM  ods.dbo.Incident_Srms_Backlog tb  with (nolock)                                    
INNER JOIN [vw_UCAREPII_TXNS] Vw                                      
ON tb.SourceSR = Vw.Incident_Number           
WHERE VW.Datasourcename='SRMS'
--7
select count(*) 
FROM  ods.dbo.Incident_Srms_Tsdb tb  with (nolock)                                    
INNER JOIN [vw_UCAREPII_TXNS] Vw                                      
ON tb.Incident_Number = Vw.Incident_Number           
WHERE VW.Datasourcename='SRMS'





--------------------------------------------------------------------------------------


select count(*) 
FROM   ODS.DBO.incident_srms_specific IT WITH (NOLOCK)                    
LEFT OUTER JOIN  ODS.DBO.incident_srms_attention IA WITH (NOLOCK)                    
ON ( IT.incident_number =IA.incident_number )                    
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in('42100372'
,'43200131'
,'43203872'
,'44100131'
,'44100162'
,'44100730'
,'44111022'
,'44111322'
,'44133532'
,'44200171'
,'45100371'
,'47201271'
,'49100472')                     
--(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())    --2197934   
--------------------------------------------------------------------------------------------------------
--USING VIEW--1 
select count(*) 
FROM  ods.dbo.Incident_SRMS_Specific  IT with (nolock)                                    
LEFT OUTER JOIN ODS.DBO.[incident_srms_attention ] IA with (nolock)                                    
ON IT.Incident_Number = IA. Incident_Number 
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in                     
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())  --2197934
use ods
--2
SELECT COUNT (*)
FROM  ods.dbo.incident_srms_attention IT with (nolock) 
LEFT OUTER JOIN ODS.DBO.Incident_SRMS_Specific IA with (nolock) 
ON IT.Incident_Number = IA. Incident_Number 
WHERE IT.DATASOURCEID=42 AND IT.attention_completion_code='C' AND IA.National_Account_ID in 
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IT.Completion_DateTime<=DATEADD(d,-90, getdate())--2197934

--3 
select count(*) 
FROM  ods.dbo.incident I with (nolock) 
LEFT OUTER JOIN  ODS.DBO.Incident_SRMS_Specific IT  with (nolock) 
ON I.Incident_Number = IT.Incident_Number
LEFT OUTER JOIN ODS.DBO.[incident_srms_attention ] IA with (nolock)                                    
ON IT.Incident_Number = IA. Incident_Number 
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in                     
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())  --2151488

--4
select count(*) 
FROM  ods.dbo.ITIL_Transaction I with (nolock) 
LEFT OUTER JOIN  ODS.DBO.Incident_SRMS_Specific IT  with (nolock) 
ON I.Transaction_ID = IT.Incident_Number
LEFT OUTER JOIN ODS.DBO.[incident_srms_attention ] IA with (nolock)                                    
ON IT.Incident_Number = IA. Incident_Number 
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in                     
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())  --2197894
--------------------------------------------------------------------------------------------------------------
SELECT * FROM SYS.OBJECTS where TYPE='p'
sp_helptext'SP_EncryptFields'
use customerredaction 
SELECT *  fROM PIIClientChild  WHERE ClientParentID='1'
---------------------------------------------------------------------------------------------------------------------------------------------------

select distinct NATIONALACCOUNT from  Fs_Serviceincidents

WHERE DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in                     
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())



select top 10 *  from  Fs_Serviceincidents


0043200131
0045100371

select count(*) 
FROM  [172.16.123.70].ods.dbo.Fs_Serviceincidents  FS with (nolock)                                    
LEFT OUTER JOIN [172.16.123.70].ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Sourcesr = ISS. Incident_Number
LEFT OUTER JOIN [172.16..ODS.DBO.incident_srms_attention IA
on ISS.incident_number = IA. Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
FS.NationalAccount in ('0043200131',
'0045100371')                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())  --168103


select count(*) 
--FROM  ods.dbo.Fs_Serviceincidents  FS with (nolock)    
FROM ODS.DBO.Fs_Serviceincidents  tb                                            
INNER JOIN [vw_UCAREPII_TXNS] Vw                                            
ON tb.SourceSR = Vw.Incident_Number                  
WHERE VW.Datasourcename='SRMS'     


select count(*) 
FROM  ods.dbo.Incident_Srms_Backlog  FS with (nolock)                                    
LEFT OUTER JOIN ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Sourcesr = ISS. Incident_Number
LEFT OUTER JOIN ODS.DBO.incident_srms_attention IA
on ISS.incident_number = IA. Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
FS.NationalAccount in ('0043200131',
'0045100371')                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate()) 


                                                     
select count(*)                                      
FROM ODS.DBO.Fs_Serviceincidents  tb                                            
INNER JOIN [vw_UCAREPII_TXNS] Vw                                            
ON tb.SourceSR = Vw.Incident_Number                  
WHERE VW.Datasourcename='SRMS'  
--------------------------------------------------------------------------------------------------------------------------
--production script--
select count(*) 
FROM  [172.16.123.70].ods.dbo.Fs_Serviceincidents  FS with (nolock)                                    
LEFT OUTER JOIN [172.16.123.70].ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Sourcesr = ISS. Incident_Number
LEFT OUTER JOIN [172.16.123.70].ODS.DBO.incident_srms_attention IA
on ISS.incident_number = IA. Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
FS.NationalAccount in ('0043200131',
'0045100371')                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate()) ----168103
----------------------------------------------------------------------------------------------------

select count(*) 
FROM   ODS.DBO.incident_srms_specific IT WITH (NOLOCK)                    
LEFT OUTER JOIN  ODS.DBO.incident_srms_attention IA WITH (NOLOCK)                    
ON ( IT.incident_number =IA.incident_number )                    
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in('42100372'
,'43200131'
,'43203872'
,'44100131'
,'44100162'
,'44100730'
,'44111022'
,'44111322'
,'44133532'
,'44200171'
,'45100371'
,'47201271'
,'49100472')                     
--(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())    --2197934   
--------------------------------------------------------
--USING VIEW--1 
select count(*) 
FROM  ods.dbo.Incident_SRMS_Specific  IT with (nolock)                                    
LEFT OUTER JOIN ODS.DBO.[incident_srms_attention ] IA with (nolock)                                    
ON IT.Incident_Number = IA. Incident_Number 
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in                     
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())  --2197934
use ods
--2
SELECT COUNT (*)
FROM  ods.dbo.incident_srms_attention IT with (nolock) 
LEFT OUTER JOIN ODS.DBO.Incident_SRMS_Specific IA with (nolock) 
ON IT.Incident_Number = IA. Incident_Number 
WHERE IT.DATASOURCEID=42 AND IT.attention_completion_code='C' AND IA.National_Account_ID in 
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IT.Completion_DateTime<=DATEADD(d,-90, getdate())--2197934

--3 
select count(*) 
FROM  ods.dbo.incident I with (nolock) 
LEFT OUTER JOIN  ODS.DBO.Incident_SRMS_Specific IT  with (nolock) 
ON I.Incident_Number = IT.Incident_Number
LEFT OUTER JOIN ODS.DBO.[incident_srms_attention ] IA with (nolock)                                    
ON IT.Incident_Number = IA. Incident_Number 
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in                     
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())  --2151488

--4
select count(*) 
FROM  ods.dbo.ITIL_Transaction I with (nolock) 
LEFT OUTER JOIN  ODS.DBO.Incident_SRMS_Specific IT  with (nolock) 
ON I.Transaction_ID = IT.Incident_Number
LEFT OUTER JOIN ODS.DBO.[incident_srms_attention ] IA with (nolock)                                    
ON IT.Incident_Number = IA. Incident_Number 
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in                     
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())  --2197894
-----------------------------------------------------------------------------------------------------------------------
use customerredaction

USE DELLPII

select top 10 *  from  Incident_Srms_Tsdb

select distinct NATIONALACCOUNT from  Fs_Serviceincidents

WHERE DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in                     
(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())
----------------------------------------------------------------------------------------


---------------------------------------------------------------------------------------
--production script--
select count(*) 
FROM  [172.16.123.70].ods.dbo.Fs_Serviceincidents  FS with (nolock)                                    
LEFT OUTER JOIN [172.16.123.70].ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Sourcesr = ISS. Incident_Number
LEFT OUTER JOIN [172.16.123.70].ODS.DBO.incident_srms_attention IA
on ISS.incident_number = IA. Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
FS.NationalAccount in ('0043200131',
'0045100371')                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate()) ----168103
----------------------------------------------------------------------------------------------------

select count(*) 
FROM   ODS.DBO.incident_srms_specific IT WITH (NOLOCK)                    
LEFT OUTER JOIN  ODS.DBO.incident_srms_attention IA WITH (NOLOCK)                    
ON ( IT.incident_number =IA.incident_number )                    
WHERE IT.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
IT.National_Account_ID in('42100372'
,'43200131'
,'43203872'
,'44100131'
,'44100162'
,'44100730'
,'44111022'
,'44111322'
,'44133532'
,'44200171'
,'45100371'
,'47201271'
,'49100472')                     
--(select pii.ClientID from PIIClientChild pii WITH (NOLOCK) where pii.ClientParentID=1)                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())    --2197934   
-
----------------------------------------------------------------------------------------------------------------
use ods
select count(*) 
FROM  ods.dbo.Incident_Srms_Backlog  FS with (nolock) 
LEFT OUTER JOIN ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Sourcesr = ISS. Incident_Number
LEFT OUTER JOIN ODS.DBO.incident_srms_attention IA
on ISS.incident_number = IA. Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
FS.NationalAccount in ('0043200131',
'0045100371')                     
and  IA.Completion_DateTime<=DATEADD(d,-90, getdate())--1127715



select count(*) 
FROM  ods.dbo.Incident_Srms_Tsdb FS with (nolock) 
LEFT OUTER JOIN ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Incident_Number = ISS.Incident_Number
LEFT OUTER JOIN ODS.DBO.incident_srms_attention IA with (nolock) 
on ISS.incident_number = IA.Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
ISS.National_Account_ID in('42100372'
,'43200131'
,'43203872'
,'44100131'
,'44100162'
,'44100730'
,'44111022'
,'44111322'
,'44133532'
,'44200171'
,'45100371'
,'47201271'
,'49100472')  and IA.Completion_DateTime<=DATEADD(d,-90, getdate())--78011032


select count(*) 
FROM  ods.dbo.Incident_Srms_Tsdb FS with (nolock) 
LEFT OUTER JOIN ODS.DBO.Incident_SRMS_Specific ISS with (nolock)                                    
ON FS.Incident_Number = ISS.Incident_Number
LEFT OUTER JOIN ODS.DBO.incident_srms_attention IA with (nolock) 
on ISS.incident_number = IA.Incident_Number
WHERE ISS.DATASOURCEID=42 AND IA.attention_completion_code='C' AND               
ISS.National_Account_ID in('42100372'
,'43200131'
,'43203872'
,'44100131'
,'44100162'
,'44100730'
,'44111022'
,'44111322'
,'44133532'
,'44200171'
,'45100371'
,'47201271'
,'49100472')  and IA.Completion_DateTime<=DATEADD(d,-90, getdate())--O


--------------------------------------------------------
SHARATH SIR FSM

USE [ODS_SN_FSM]

SELECT NAME,SYS_DOMAIN FROM domain WHERE NAME LIKE '%DELL%'

SELECT u_customer_id,SYS_DOMAIN,NAME, * FROM core_company  WHERE-- NAME LIKE '%Dell Marketing LP%'
--AND 
SYS_DOMAIN IN (
SELECT SYS_DOMAIN FROM domain WHERE NAME LIKE '%DELL%')
--and u_customer_id='1670247'
SELECT SYS_DOMAIN,account,dv_account,dv_parent,dv_company,dv_primary_location,
primary_location,u_global_account
,DV_COMPANY,* FROM cmn_location WHERE --DV_COMPANY LIKE '%Dell%'
SYS_DOMAIN IN (
SELECT SYS_DOMAIN FROM domain WHERE NAME LIKE '%DELL%')


SELECT dv_company,company,u_global_account_number,count(*) FROM WM_TASK 
WHERE SYS_DOMAIN IN (
SELECT SYS_DOMAIN FROM domain WHERE NAME LIKE '%DELL%')
and  company='4fb888a5dbc42b40425b7b668c9619b2'
group by dv_company,company,u_global_account_number


SELECT dv_company,company,u_global_account_number FROM WM_TASK WHERE SYS_DOMAIN IN (
SELECT SYS_DOMAIN FROM domain WHERE NAME LIKE '%DELL%')
and company='4fb888a5dbc42b40425b7b668c9619b2'
--2586158
--u_cusotmer_id=1670247

-----------------------------------------
USE [ODS_SN_FSM]

select top 10 u_contact_phone,u_street_address2,
u_alternate_contact_phone,
u_contact, number,company,dv_company,location,sys_domain,u_global_account_number, * from wm_task
where u_primary_sr = '71247204' 
and datasourceid=77

select * from wm_task
-----------------------------------------------
USE [ODS_SN_FSM]
select top 10 u_street_address1,u_country,u_contact_email,
u_contact_phone,u_alternate_contact_phone,number,company,dv_company,location,sys_domain,u_global_account_number, * from wm_task
where u_primary_sr = '71270633'

select top 10 u_street_address1,u_country,u_contact_email,
u_contact_phone,u_alternate_contact_phone,number,company,dv_company,location,sys_domain,u_global_account_number, * from wm_task
where u_primary_sr = '71207434'
-----------------------------------------
select  u_customer_id,sys_updated_on, sys_id 
from ods_sn_fsm.dbo.core_company (NOLOCK)
where u_customer_id in ('1694580', '1697158', '1723978', '1737189', '1683282', '1391939', 
'1671051', '1691641', '1684449', '6418694', '1704575', '6001538', '1662894', '6424787', '6407997',
 '1739688', '6304577', '1680948', '1683839', '1704813', '1702761', '6359706', '1685067', '6397444',
 '6425737', '1662096', '1703026', '1711392', '6425987', '1715182', '1662375', '6141340', '1662583', '1672479', '1681189', '1703593')
ORDER BY u_customer_id
-------------------------------------
select  u_customer_id,sys_updated_on, sys_id 
from ods_sn_fsm.dbo.core_company (NOLOCK)
where u_customer_id in ('1694580', '1697158', 
select  u_customer_id,sys_updated_on, sys_id 
from ods_sn_fsm.dbo.core_company (NOLOCK)
where u_customer_id in ('1694580', '1697158', '1723978', '1737189', '1683282', '1391939', '1671051', '1691641', '1684449', '6418694', '1704575', '6001538', '1662894', '6424787', '6407997', '1739688', '6304577', '1680948', '1683839', '1704813', '1702761', '6359706', '1685067', '6397444', '6425737', '1662096', '1703026', '1711392', '6425987', '1715182', '1662375', '6141340', '1662583', '1672479', '1681189', '1703593')
ORDER BY u_customer_id
----------------------------------------------
USE [ODS_SN_FSM]
select top 10 u_street_address1,u_country,u_contact_email,
u_contact_phone,u_alternate_contact_phone,number,company,dv_company,location,sys_domain,u_global_account_number, * from wm_task
where u_primary_sr = '71270633'

select top 10 u_street_address1,u_country,u_contact_email,
u_contact_phone,u_alternate_contact_phone,number,company,dv_company,location,sys_domain,u_global_account_number, * from wm_task
where u_primary_sr = '71207434'
--------------------------------------------------
select top 10 
u_serial_number,
u_alternate_contact,
u_street_address1,
u_street_address2,
u_city,
u_state,
u_country,
contact_type,
u_contact,
u_contact_email,
u_contact_phone,
u_alternate_contact_phone,
number,
company,
dv_company,location,sys_domain,u_global_account_number, * from wm_task
where u_primary_sr = '71207434
-----------------------------------------------------------


Comments

Post a Comment

Popular posts from this blog

java chapter11 practice question on abstruct class and interfaces

  /* Chapter 11 - Practise Set 1... Create an abstract class Pen with methods Write () and refill 1) as abstract methods 2... Use the Pen Class from Q1 to create a Concrete class fountain Pen with additional method change Nibl) 3...Create a class Monkey with jump () and bitel) methods. Create a class Human which inherits this Monkey class and implements Basic Animalinterface with eati) and sleep methods. 4.... Greate a class Telephone with ring() liftus and disconnect ( methods as abstract methods Create another class Smart Telephone and demonstratepolymorphism 5.....Demonstrate polymorphism Msing monkey class from Quess 3. 6.......Create an Interface TV Remote and use it to inheritanother Interface Smart Tv Remote 7...... Create a Class Tv which implements Tv Remote interface qsn 6 */ package com.company ; //programe 1 abstract class Pen { abstract void Write (); abstract void Refill (); } //programe 2 class FountainPen extends Pen { void Writ
Read more

java practice set 8

  questions: /* 1. Create a class Employee with the following properties and methods: Salary (property) (int) getSalary (method returning int) name (property) (String) getName (method returning String) setName (method changing name) 2. Create a class cellphone with methods to print “ringing…”, “vibrating…”, etc. 3. Create a class Square with a method to initialize its side, calculating area, perimeter etc. 4. Create a class Rectangle & problem 3. 5. Create a class TommyVecetti for Rockstar Games capable of hitting (print hitting…), running, firing, etc. 6. Repeat problem 4 for a circle. */ answers package com.company; class Employee{ int salary; String name; public int getSalary(){ return salary; } public String getName(){ return name; } public void setName(String n){ name = n; } } class CellPhone{ public void ring(){ System.out.print
Read more

new stored procidure with interval and frequery code

 CREATE procedure  [dbo].[SP_Baxter_CSAT]                                                                                                             AS                                                            BEGIN            DECLARE @ExtractIdOut INT                                                                   DECLARE @EndDt DATETIME2                                 DECLARE @runDate DATETIME2                                 DECLARE @RecordCount INT = 0                                                                 DECLARE @ProcedureName SYSNAME = OBJECT_NAME(@@PROCID)                                              DECLARE @intErrorCode INT                                                                 Declare @returnCode int = 0                                                                 DECLARE @ExtractProcessControlId UniqueIdentifier                                                                 SET NOCOUNT ON;                              BEGIN TRY           --Log the
Read more