my note 3

 select I.primarysr, I.requesterurgency, I.INCIDENTOPENDATETIME, i.INCIDENTLASTUPDATED, i.incidentcloseddatetime, C.TSDB_Activity_Code, C.TSDB_Text_1, C.TSDB_user_id, C.TSDB_DateTime

from dbo.incident_SRMS_TSDB C (nolock) 

inner join FS_ServiceIncidents I (nolock) on primarysr = incident_number 

where NATIONALACCOUNT = '0043200131'

and contact_country = 'US'

and I.INCIDENTOPENDATETIME between '2020-07-01' 

and getdate() and primarysr=sourcesr

and TSDB_Text_1 in ('C30','C31', 'U1')


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


select *

from FS_ServiceIncidents

where NATIONALACCOUNT = '0043200131'

and incidentlastupdated between '2020-01-01' 

and getdate() and primarysr=sourcesr



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

Select

FORMAT(getdate(), 'MM/dd/yyyy') as Date,

FORMAT(getdate(), 'yyyyMMdd') as Date_KY,

ServiceIncidentID,

PrimarySR,

ParentSR,

CustomerSR,

[REQUESTERURGENCY] as Urgency,

[CURRENTWORKFLOWSTATUS] as Status,

ProblemAbstract,

ProductLevel,

VProblemDetail,

Product1,

Product2,

Product3,

Manufacturer,

ManufacturerModel,

UnisysStyle,

90 as SerialNumber,

DeviceName,

convert(datetime, [RESPONSEDATETIME]) as ResponseDateTime,

[SERVICETYPE] as [Service type],

CustomerIdentifier,

CustomerIdentifierType,

[NATIONALACCOUNT] as NationalAccountId,

convert(int, [CUSTOMERCUIC]) as CustomerCUIC,

[CURRENTPROVIDER1] as CountryCode,

[CURRENTPROVIDER2] as Brnach,

[CURRENTPROVIDER3] as Assignment,

[CURRENTPROVIDER4] as TechID,

[CURRENTPROVIDERNAME] as TechName,

convert(datetime,[PROVIDERONSITEDATETIME]) as ProviderOnsiteDateTime,

convert(datetime,[INCIDENTOPENDATETIME]) as OpenDateTime,

convert(datetime,[INCIDENTLASTUPDATED]) as LastUpdatedDateTime,

convert(datetime,[INCIDENTCLOSEDDATETIME]) as ClosedDateTime,

convert(datetime,[SCHEDULEDDATETIME]) as ScheduleDateTime,

PartsAvailable,

UCCURRENTWORKFLOWSTATUS as UcurrentWorkFlowStatus,

SLA,

convert(datetime,[RESTOREDATETIME]) as RestoreDateTime,

isnull(I.Transaction_ID, 'Backlog') as FalseBacklog

from incident_SRMS_backlog (nolock) B

left outer join Incident (nolock) I on B.PRIMARYSR = I.Transaction_ID and I.DataSourceID = 42 and I.Last_Resolved_Date is not null 

where NATIONALACCOUNT = '0043200131'

and sourcesystem = 'SRMS' and primarysr=sourcesr

and currentworkflowstatus not in ('C', 'D')

and [CURRENTPROVIDER1] not in('0248', '0397')

------------------------------------
2022-01-14 06:12:34.213596: Starting ingestion...
2022-01-14 06:12:34.647436: Time Gap: 15:00:00, No of retries: 5, Time gap to be decreased: 2
2022-01-14 06:12:34.789863: Fetching data from 1/13/2022 23:1 to 1/14/2022 06:0
2022-01-14 06:12:34.893470: Generated URL: https://iva.unisys.com/AmeliaRest/api/v1/admin/metrics/domains/conversations/export?format=JSON&domainIds=487c0a9d-80bf-4082-a446-5be72dd0b1cc&from=1/13/2022 23:1&to=1/14/2022 06:0&includeTranscripts=true&includeEscalationLogs=true
2022-01-14 06:12:35.200429: Status code 500 and message: java.util.concurrent.ExecutionException: org.springframework.web.client.RestClientException: Could not extract response: no suitable HttpMessageConverter found for response type [class net.ipsoft.ameliav3.sdk.admin.metrics.model.ConversationExportCheck] and content type [text/html;charset=UTF-8]. Retrying...
2022-01-14 06:12:35.362644: Fetching data from 1/13/2022 23:1 to 1/14/2022 06:0
2022-01-14 06:12:35.475574: Generated URL: https://iva.unisys.com/AmeliaRest/api/v1/admin/metrics/domains/conversations/export?format=JSON&domainIds=487c0a9d-80bf-4082-a446-5be72dd0b1cc&from=1/13/2022 23:1&to=1/14/2022 06:0&includeTranscripts=true&includeEscalationLogs=true
2022-01-14 06:12:35.695697: No data found.
2022-01-14 06:12:35.836990: Total time taken: 1.0477917194366455
2022-01-14 06:12:47.832278: Exit string: 0.0$0.0$0.0$0$0$0$0$0.0$0.005225364367167155$0.0033404072125752765$1900-01-01 00:00:00$1900-01-01 00:00:00$0$8$2$0$ucaredlakesynsp$56$1/14/2022 18:0$0$-$1/14/2022 04:0$true$0$0$0$0$2022-01-14 06:12:39.948122$2022-01-14 06:12:40.034437$0$0

---------------------
imortant query for amelia checking
SELECT  distinct a.conversationId FROM dbo.Amelia_Conversation a (nolock)
INNER JOIN  [dbo].[Amelia_Context] e (nolock)
    ON a.conversationId = e.conversationId
where e.domainid in ('cace8a78-45b4-4dee-bd75-15cecc3a1351')
and conversationCreated >= '2022-1-13 23:1:00.000' and conversationCreated <= '2022-1-14 6:0:00.000'

change the the domain id according to the customer and change the timing according to the lof file lates time to azure explorer
-------------------------
select * from CopyActivitySink where CopyActivitySinkKey in( 
select CopyActivitySinkKey from CopyActivityExecutionPlan where CopyActivityExecutionGroupKey=8)

select * from [dbo].[AmeliaAPIConfig]
select * from [dbo].[APIClientConfig] where ClientName like 'cush%'

select * from [dbo].[CopyActivityExecutionGroup]


select * from keyvaultconfig
select  * from [dbo].[UcareExecutionLog] where client ='regen
--------------------------

update TEST

SET EncryptCol=EncryptByKey(Key_GUID('s_key'),convert(varbinary(MAX),XML_DATA2))

CLOSE SYMMETRIC KEY S_Key



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

DAY 12 -AZURE DP900(Microsoft Azure Data Fundamentals: Explore non-relational data in Azure)

Image
  Microsoft Azure Data Fundamentals: Explore non-relational data in Azure 1. Explore non-relational data offerings in Azure 2. Explore provisioning and deploying non-relational data services in Azure 3. Manage non-relational data stores in Azure Explore non-relational data offerings in Azure---------- Introduction Completed 100 XP 1 minute Data comes in all shapes and sizes, and can be used for a large number of purposes. Many organizations use relational databases to store this data. However, the relational model might not be the most appropriate schema. The structure of the data might be too varied to easily model as a set of relational tables. For example, the data might contain items such as video, audio, images, temporal information, large volumes of free text, encrypted information, or other types of data that aren't inherently relational. Additionally, the data processing requirements might not be best suited by attempting to convert this data into the relational format. In ...
Read more

java exercise4

  //implement a library using java class library //methods: issuebook,returnbook,showavailablebooks //properties:to store available books,store issued books //exercise 4 package com.company ; class library { String [] books ; int no_of_books ; library () { this . books = new String[ 100 ]; this . no_of_books = 0 ; } void addbook ( String book) { this . books [ no_of_books ] = book; no_of_books ++; System . out .println(book + ".... has been added....." ); } void showavailablebooks () { System . out .println( "available books are :" ); for ( String book : this . books ) { if ( book == null ) { //break;------//issue book jdi null hoye jy tale porer books shor krbe na tai continue continue ; } System . out .println( "*..." + book ); } } void issuebook ( String book) { //for (String b:th...
Read more