MY WORK DIARY

 fsm>>>> insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Model Number','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Serial Number','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Item Subclassification Code','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Product Description','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate,ClientParentID) values('Customer Primary Name','UcareAdmin',getdate(),'2') insert into  [dellpii].[dbo].[piiconfig] (FieldName,LastUpdatedBy,LastModifiedDate

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

  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          08:43:19.610       1           NULL -----------