my note 4

 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

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

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Model Number','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Serial Number','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Customer Primary Name','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Address Line1','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Address Line2','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Address Line3','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Address Line4','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('City','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('State Code','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Postal Code','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Country Code','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Primary Contact Name','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Primary Contact Email ID','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Primary Contact Phone','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Secondary Phone Number','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Agent Report Description','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Agent Instructions','UcareAdmin','1','In a note in SRMS when sent. No way to redact or encrypt')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('CompanyName','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Contact Type','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('ContactName','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Customer Alternate Name','UcareAdmin','1','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Customer Mood','UcareAdmin','1','In a note in SRMS when sent. No way to redact or encrypt.')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('ENVIRONMENT','UcareAdmin','1','In a note in SRMS when sent. No way to redact or encrypt.')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Item Subclassification Code','UcareAdmin','1','Not passed to ODS In a note in SRMS')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Operating System','UcareAdmin','1','In a note in SRMS when sent. No way to redact or encrypt.')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Product Description','UcareAdmin','1','This might be considered the Dell model style but there is a separate field already in the list for that. Otherwise the data from Dell in the B2b field is in a note, no way to redact or encrypt')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Warranty Expiration Date','UcareAdmin','1','Probably located in a note in SRMS.  No way to redact or encrypt.')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Diagnostic Information','UcareAdmin','1','In a note in SRMS when sent. No way to redact or encrypt.')

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

CLICK

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

Serial Number,Customer Primary Name,Customer Alternate Name,City,State Code,Postal Code,Primary Contact Name

Primary Contact Email ID,Primary Contact Phone,Secondary Phone Number,Customer Mood,ContactName,CompanyName

Product Description


Item Subclassification Code,Agent Report Description,Agent Instructions,Warranty Expiration Date,Operating System

Diagnostic Information,ENVIRONMENT,Address Line2,Address Line3

Address Line4

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

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Serial Number','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Customer Primary Name','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Customer Alternate Name','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('City','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('State Code','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Postal Code','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Primary Contact Name','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Primary Contact Email ID','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Primary Contact Phone','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Secondary Phone Number','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Customer Mood','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('ContactName','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('CompanyName','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Product Description','UcareAdmin','3','NULL')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Item Subclassification Code','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Agent Report Description','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Agent Instructions','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Warranty Expiration Date','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Operating System','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Diagnostic Information','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('ENVIRONMENT','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Address Line2','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Address Line3','UcareAdmin','3','would not be in CLICK')

insert into  [dellpii].[dbo].[piiconfig]

(FieldName,LastUpdatedBy,ClientParentID,Comments)

values('Address Line4','UcareAdmin','3','would not be in CLICK')

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

piidbconfig

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

SRMS

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

DBConfigId DBName TableName FieldName FieldIdFK LastUpdatedBy LastModifiedDate SecureID ClientParentID ISActive PriColumnName

1 ODS Incident_SRMS_Specific Reported_Style 1 UcareAdmin 2022-02-03 14:54:31.570 1 1 1 Incident_Number

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


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

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Specific','Reported_Style','1','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Attention','Vendor_Style','1','UcareAdmin','1','1','1','NULL')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Attention','Vendor_OEMSerialNumber','2','UcareAdmin','1','1','1','NULL')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Specific','Reported_Serial_Number','2','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Specific','Override_Install_Site','3','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident','Cust_Address','4','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_NOTES','NOTETEXT','5','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_NOTES','NOTETEXT','6','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_NOTES','NOTETEXT','7','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident','Cust_City','8','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident','Cust_State','9','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident','Cust_ZipCode','10','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Specific','Customer_Phone_Provided_1st','14','UcareAdmin','2','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','ITIL_Transaction','Description','16','UcareAdmin','1','1','1','NULL')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','ITIL_Transaction','Headline','16','UcareAdmin','1','1','1','NULL')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Specific','Call_type','20','UcareAdmin','2','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_srms_notes','NoteText','12','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_srms_notes','NoteText','13','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_srms_notes','NoteText','15','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Specific','Override_Install_Site','19','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident','Product_Model_version','1','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_NOTES','NoteText','2','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_srms_notes','NoteText','4','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_srms_notes','NoteText','8','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_srms_notes','NoteText','9','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_srms_notes','NoteText','10','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_srms_notes','NoteText','14','UcareAdmin','2','1','1','ATTENNO')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Specific','Override_Install_Site','21','UcareAdmin','1','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_SRMS_Specific','Contact_fulll_name','21','UcareAdmin','2','1','1','Incident_Number')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','CLIENTID','19','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','CONTACT_COMPANY','19','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','CLIENTID','19','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','ORGANIZATIONNAME1','19','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','COMPANY1','19','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','ORGANIZATIONNAME2','19','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','COMPANY2','19','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','MANUFACTURERMODEL','1','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','CUSTOMERIDENTIFIER','1','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','MANUFACTURERMODEL','1','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','CUSTOMERIDENTIFIER','1','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','SERIALNUMBER','2','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','SERIALNUMBER','2','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','CONTACT_CITY','8','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','CITY1','8','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','CITY2','8','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','CONTACT_STATEPROVINCE','9','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','STATEPROVINCE1','9','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','STATEPROVINCE2','9','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','CONTACT_CONTACT','12','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Fs_Serviceincidents','CONTACT_COUNTRY','11','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','COUNTRY1','11','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','COUNTRY2','11','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','LASTNAME1','3','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','FIRSTNAME1','3','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','MIDDLENAME1','3','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','LASTNAME2','3','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','FIRSTNAME2','3','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','MIDDLENAME2','3','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Tsdb','TSDB_User_Id','22','UcareAdmin','1','1','1','NULL')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','GEOADDRESS12','4','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','GEOADDRESS11','4','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','GEOADDRESS21','5','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','GEOADDRESS22','5','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','GEOADDRESS31','6','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','GEOADDRESS32','6','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','GEOADDRESS41','7','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','GEOADDRESS42','7','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','POSTALCODE1','10','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','POSTALCODE2','10','UcareAdmin','1','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','VOICEPHONE1','14','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','ALTERNATEPHONE1','14','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','FAXPHONE1','14','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','VOICEPHONE2','15','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','ALTERNATEPHONE2','15','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','FAXPHONE2','15','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','EMAIL1','13','UcareAdmin','2','1','1','SourceSR')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('ODS','Incident_Srms_Backlog','EMAIL2','13','UcareAdmin','2','1','1','SourceSR')

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

CLICK

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

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','contactname','41','UcareAdmin','1','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','city','33','UcareAdmin','1','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','contactname','36','UcareAdmin','1','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','contactname2','32','UcareAdmin','1','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','ContactPhoneNumber','38','UcareAdmin','2','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','ContactPhoneNumber2','39','UcareAdmin','2','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','customer','42','UcareAdmin','2','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','CustomerEmail','37','UcareAdmin','2','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','postcode','35','UcareAdmin','1','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','SerialNumber','30','UcareAdmin','1','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','state','34','UcareAdmin','1','3','1','Callid')

insert into  [dellpii].[dbo].[piidbconfig]

(DBName,TableName,FieldName,FieldIdFK,LastUpdatedBy,SecureID,ClientParentID,ISActive,PriColumnName)

values('UNNCLICKDBT','W6TASKS','contactname','31','UcareAdmin','1','3','1','Callid')












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

CHECK THE LAST MODIFIED DATE IN ODS

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

Incident_SRMS_Specific

Incident_SRMS_Attention

ITIL_Transaction

Incident

Fs_Serviceincidents_Backup

-

Incident_Srms_Backlog_Backup

Incident_SRMS_TSDB

w6tasks

Incident_SRMS_Notes

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

select top 10 * from Incident_SRMS_specific


select max(Last_modified_Date) from Incident_SRMS_Attention

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

select max(LASTUPDATEDON) from Incident_SRMS_Notes----2022-03-07 06:00:24.160

select max(LASTDT) from Incident_SRMS_Notes--2022-03-06

select max(Last_modified_Date) from Incident_SRMS_TSDB--2020-06-08 19:42:00.000

select max(INCIDENTLASTUPDATED) from Incident_Srms_Backlog--2021-07-16 05:59:13.0000000

select max(TimeModified) from w6tasks   --2020-07-01 08:05:46.000



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

USE ODS


SP_HELP 'w6tasks'

select top 10 * from w6tasks


select max(LASTUPDATEDON) from Incident_SRMS_Notes----2022-03-07 06:00:24.160

select max(LASTDT) from Incident_SRMS_Notes--2022-03-06

select max(Last_modified_Date) from Incident_SRMS_TSDB--2020-06-08 19:42:00.000

select max(INCIDENTLASTUPDATED) from Incident_Srms_Backlog--2021-07-16 05:59:13.0000000


USE DELLPII

SP_HELP 'w6tasks'


USE UNNCLICKDBT

-----



for FRAMEWORK CHECK

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

List of all Tables used in the Framework

[Dellpii]. [dbo].[DataSecure]

[Dellpii]. [dbo].[PIIClientParent]

[Dellpii]. [dbo].[PIIClientChild]

[Dellpii]. [dbo].[PIIConfig]

[Dellpii]. [dbo].[PIIDBConfig]

[Dellpii]. [dbo].[logtable]

List of all SP’S used in the Framework

sp_CryptMaster

sp_dynamicupdate1

sp_logging

List of all views used in the Framework

[Dellpii]. [dbo].[vw_DellPII_TXNS]

Sequence of steps in executing the Framework:

1.Configuring the PIIDBConfig table with respective values and setting isactive=1.

2.Execute sp_CryptMaster.

Desired Result:

Cryptographic operation to be applied on respective columns.

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


1.sample Testing query 


SELECT * FROM  Dellpii.dbo.PIIDBConfigtest

where isactive=1


2.Sample Testing Query 


select   Reported_Style ,

Reported_Serial_Number,

Override_Install_Site,

Customer_Phone_Provided_1st,

Call_type,

Override_Install_Site,

Override_Install_Site,

Reported_Style,

Override_Install_Site from [DellPII].[dbo].Incident_SRMS_Specific1

where incident_number in(

select incident_number from [dbo].[vw_DellPII_TXNS] ) 

 

 

3.To verify logging 

 

 select * from [dbo].logtable with(nolock)

 

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



Also please find the attachment for list of tables, sp’s ,sequence of operation and sample queries.

https://unisys.zoom.us/rec/share/BVoQnfPP9N5CsYu3uwi5tnfYVnkFCjuqhRYWZIKHUo1ddHmnUnOcVXewI-17teJA.080f7-lMc040s7WE Passcode: Je%63i4s


------------------------------------------------------------------------------------------------------------------------------------------
1.SP_HELPTEXT'[dbo].[Sp_CryptMaster]'
2.SELECT  DBName,TableName,FieldName,SecureID,ClientParentID,PriColumnName,ISactive  
  FROM  Dellpii.dbo.PIIDBConfigtest
  
3.SELECT  DBName,TableName,FieldName,SecureID,ClientParentID,PriColumnName,ISactive  
  FROM  Dellpii.dbo.PIIDBConfigtest      
  where ISActive=1   
  
4. SELECT TOP 100* FROM [DELLPII].[DBO].Incident_SRMS_Specific1
5.EXECUTE [Sp_CryptMaster]
6.SELECT
 Reported_Style ,
 Reported_Serial_Number,
 Override_Install_Site,
 Customer_Phone_Provided_1st,
 Call_type,
 Override_Install_Site,
 Override_Install_Site,
 Reported_Style,
 Override_Install_Site
 FROM [DELLPII].[DBO].Incident_SRMS_Specific1
 WHERE INCIDENT_NUMBER IN(SELECT INCIDENT_NUMBER FROM [dbo].[vw_DellPII_TXNS] )
 
7.SELECT *FROM [DBO].LOGTABLE WITH(NOLOCK) 
8.TRUNCATE TABLE [DBO].LOGTABLE
9.SELECT  DBName,TableName,FieldName,SecureID,ClientParentID,PriColumnName,ISactive  
 FROM  Dellpii.dbo.PIIDBConfigtest      
 where ISActive=1 



---------------------------------------------------------------------------------------------------------------
use dellpii

SELECT  DBName,TableName,FieldName,SecureID,ClientParentID,PriColumnName,ISactive  
FROM  Dellpii.dbo.PIIDBConfigtest      
where ISActive=1

SELECT * FROM [DELLPII].[DBO].Incident_SRMS_Specific1

 EXECUTE [Sp_CryptMaster]

SELECT TOP 1000* FROM Incident_SRMS_Specific1


--truncate table [DELLPII].[DBO].Incident_SRMS_Specific1


SELECT
Reported_Style ,
Reported_Serial_Number,
Override_Install_Site,
Customer_Phone_Provided_1st,
Call_type,
Override_Install_Site,
Override_Install_Site,
Reported_Style,
Override_Install_Site
FROM [DELLPII].[DBO].Incident_SRMS_Specific1
WHERE INCIDENT_NUMBER IN(SELECT INCIDENT_NUMBER FROM [dbo].[vw_DellPII_TXNS] )


SELECT *FROM [DBO].LOGTABLE WITH(NOLOCK)
--TRUNCATE TABLE [DBO].LOGTABLE

--truncate table [DELLPII].[DBO].Incident_SRMS_Specific1

select top 1000 * from ods.dbo.incident_srms_specific

select top 100 * from ods.[dbo].[Incident]
where incident_number in (select incident_number from dellpii.dbo.vw_dellpii_txns)

--where incident_number not in (select incident_number from dellpii.dbo.vw_dellpii_txns)

select top 1000 * from dellpii.dbo.incident_srms_specific1

select into dellpii.dbo.incident_srms_specific1
SELECT * FROM [dbo].[incident_test1] 
SELECT * FROM [dbo].[incident]

54104369

--DellPII Incident_SRMS_Attention Vendor_Style 1 1 NULL 0
--Cust_Address     Cust_City    Cust_State Cust_ZipCode
--885 W ENTRANCE DR   AUBURN HILLS        MI          4832600  

WT.ISEncrypt<>1


"select top 1000 * from dellpii.dbo.incident_srms_specific1
where incident_number in (
'54104369',
'54177135',
'54175801',
'54175837')"

-------------------------------use dellpii
 use dellpii
select  IA.Completion_DateTime,I.CONTACT_COMPANY  FROM Fs_Serviceincidents I inner join incident_srms_specific IT on (I.sourcesr=it.incident_number) 
LEFT OUTER JOIN  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='43200131' and IA.Completion_DateTime<=DATEADD(d,-90, getdate())
From C N, Pallavi to Everyone:  04:22 PM
(NOLOCK) LEFT OUTER JOIN  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='43200131' and IA.Completion_DateTime<=DATEADD(d,-90, getdate()) and isencrypt='1'
select I.@columns ,isencrypt FROM @tables I, incident_srms_specific IT WITH (NOLOCK) LEFT OUTER JOIN  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='43200131' and IA.Completion_DateTime<=DATEADD(d,-90, getdate()) and isencrypt='1'










---------------------------------------------------------------------------------------------------
use dellpii

select * from PIIDBConfigtest
select * from PIIDBConfig

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

--update [DellPII].[dbo].PIIDBConfigtest
--set SecureID =2    
--where TableName='Incident_SRMS_Specific1' and FieldName='Contact_fulll_name' and SecureID='1'
--------------------------------------------------------------------------------------

select tb.incident_number,tb.REPORTED_STYLe,tb.OVERRIDE_INSTALL_SITE,tb.REPORTED_SERIAL_NUMBER ,vw.Completion_DateTime
--isencrypt
FROM  Incident_SRMS_Specific1  tb   
INNER JOIN [vw_DellPII_TXNS] Vw                                      
ON tb.Incident_Number = Vw.Incident_Number           
--WHERE VW.Datasourcename='SRMS'
where tb.Incident_Number in (
'51379120',
'51421275',
'51450427',
'51450427'
)
and vw.Completion_DateTime<=DATEADD(d,-90, getdate())

----------------------------------------------------------------
select * from incident_srms_specific1 where incident_number  in ('51379120',
'51421275',
'51450427',
'51450427')

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

EXECUTE [Sp_CryptMaster]
SELECT  DBName,TableName,FieldName,SecureID,ClientParentID,PriColumnName,ISactive  
  FROM  Dellpii.dbo.PIIDBConfigtest      
  where ISActive=1
  WT.ISEncrypt<>1





















-------------------------------------------------------------------------------------------------------------------
1--Create a loading user
 -- Connect to master
   CREATE LOGIN loader WITH PASSWORD = 'a123STRONGpassword!';
   
-- Connect to the dedicated SQL pool
   CREATE USER loader FOR LOGIN loader;
   GRANT ADMINISTER DATABASE BULK OPERATIONS TO loader;
   GRANT INSERT ON <yourtablename> TO loader;
   GRANT SELECT ON <yourtablename> TO loader;
   GRANT CREATE TABLE TO loader;
   GRANT ALTER ON SCHEMA::dbo TO loader;
   
   CREATE WORKLOAD GROUP DataLoads
   WITH ( 
       MIN_PERCENTAGE_RESOURCE = 0
       ,CAP_PERCENTAGE_RESOURCE = 100
       ,REQUEST_MIN_RESOURCE_GRANT_PERCENT = 100
);

   CREATE WORKLOAD CLASSIFIER [wgcELTLogin]
   WITH (
     WORKLOAD_GROUP = 'DataLoads'
       ,MEMBERNAME = 'loader'
   
   );  

2--Create statistics after the load
create statistics [SensorKey] on [Customer_Speed] ([SensorKey]);
create statistics [CustomerKey] on [Customer_Speed] ([CustomerKey]);
create statistics [GeographyKey] on [Customer_Speed] ([GeographyKey]);
create statistics [Speed] on [Customer_Speed] ([Speed]);
create statistics [YearMeasured] on [Customer_Speed] ([YearMeasured]);
3--
Original key is created
CREATE DATABASE SCOPED CREDENTIAL my_credential WITH IDENTITY = 'my_identity', SECRET = 'key1'
otate key from key 1 to key 2
ALTER DATABASE SCOPED CREDENTIAL my_credential WITH IDENTITY = 'my_identity', SECRET = 'key2'   
----------------------------------------------------------------------------------------------------------
fsm

select top 10 * from u_county
u_county
asmt_assessment_instance_question---(dv_instance--AINST0012882),(u_task_id--WOT0684444)
sysdiagrams
alm_transfer_order(--dv_service_order_task--WOT0497272),(number--TO0010292)
cmn_m2m_skill_model
cmn_skill
sn_openframe_phone_log(--dv_task--WOT0504074),(u_number--PHL0001240)
sys_user_group_visibility
sys_user_has_role
sys_history_set
sys_journal_tech_worknotes(--TICKET--WOT0623360)
core_company(--u_customer_id--6476377)
cmn_department

select u_global_account_number from wm_task where u_global_account_number = '0045100371'
core_country
domain
sc_req_item(--dv_request--REQ0010001),(--number--RITM0010001)
sc_request(--number--REQ0010001)
u_country_language
sys_user(--employee_number--242217)
wm_task(--number--WOT0493536),(dv_parent--WO0216844),(u_global_account_number--0049104031),(task_effective_number--WOT0493536)
wm_order(--number--WO0220726)
sys_choice
sys_history_line(--dv_set--Work Order Task: WOT0388749)
sys_group_has_role
cmdb_ci(--correlation_id--I-00013586287),(dv_model_id--TMP7000010-VLI),(u_customer_id--1724730)

select top 10 * from wm_task_stg
sys_journal_field(--name--u_sid_integration_work_order_task_update--wm_task)
task_sla(--dv_task--WOT0500740)
sm_part_requirement(--number--SOPR4017016),(dv_service_order_task--WOT0396547)
task_time_worked(--dv_task--WOT0509913)
contract_sla(--collection--wm_task)
asmt_assessment(--number--ASG0010151)
asmt_assessment_instance(--dv_assessment_group--ASG0010134),(--dv_task_id--WOT0396547),(number--AINST0010137),(trigger_table--wm_task)
asmt_metric
asmt_metric_result(--dv_assessment_group--ASG0010001),(dv_instance--AINST0010001)
wm_task_bkp_20210830
wm_task_stg
-----------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------
VOLUMNE BASE REPORT --(PRODUCTTION)
###Incident_SRMS_Specific
USE ODS
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())
---------------------------------------------------------------------------
------------------------------

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