MY WORK DIARY

 --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...

  piiconfig --------------------------------------------------------------------------------------------------- Model Number,Serial Number,Customer Primary Name,Address Line1,Address Line2,Address Line3,Address Line4 City,State Code,Postal Code,Country Code,Primary Contact Name,Primary Contact Email ID,Primary Contact Phone Secondary Phone Number,Agent Report Description,Agent Instructions,CompanyName,Contact Type,ContactName,Customer Alternate Name Customer Mood,ENVIRONMENT,Item Subclassification Code,Operating System,Product Description,Warranty Expiration Date Diagnostic Information ---------------------------------------------------------------------------------------------------- SRMS ------------------------------------------------------------------------------------          FieldId FieldName LastUpdatedBy LastModifiedDate     ClientParentID Comments 1 1     Model Number UcareAdmin     2022-02-03...