January 24, 2014 at 8:07 am
I have the DataBase Mail up and running. When I sent a test email it goes through without a hitch. I am trying to sent an email after insert and the data in the SQL statement looks correct but when the Server goes to send out the email nothing happens. I go to the Log file viewer and this is what appears:
Date,Source,Severity,Log ID,Message,Process ID,Mail Item ID,Account ID,Last Modified,Last Modified By
01/24/2014 09:57:56,,Information,8,DatabaseMail process is shutting down,2940,,,1/24/2014 9:57:56 AM,NT AUTHORITY\SYSTEM
01/24/2014 09:47:56,,Information,7,DatabaseMail process is started,2940,,,1/24/2014 9:47:56 AM,NT AUTHORITY\SYSTEM
01/24/2014 09:45:57,,Information,6,DatabaseMail process is shutting down,3860,,,1/24/2014 9:45:57 AM,NT AUTHORITY\SYSTEM
01/24/2014 09:35:57,,Information,5,DatabaseMail process is started,3860,,,1/24/2014 9:35:57 AM,NT AUTHORITY\SYSTEM
01/24/2014 09:19:22,,Information,4,DatabaseMail process is shutting down,3804,,,1/24/2014 9:19:22 AM,NT AUTHORITY\SYSTEM
01/24/2014 08:57:11,,Information,3,DatabaseMail process is started,3804,,,1/24/2014 8:57:11 AM,NT AUTHORITY\SYSTEM
01/21/2014 16:19:23,,Information,2,DatabaseMail process is shutting down,2804,,,1/21/2014 4:19:23 PM,NT AUTHORITY\SYSTEM
01/21/2014 16:09:22,,Information,1,DatabaseMail process is started,2804,,,1/21/2014 4:09:22 PM,NT AUTHORITY\SYSTEM
My trigger looks like this:
Create Trigger IHelpDesk_TR
On [dbo].[support]
After Insert
As
Begin
Declare @Information nvarchar(2000);
Set @Information = (Select 'Ticket Number: ' + Cast(TicketID As varchar) + ' ' + 'Submitted By: ' + L.firstname + L.lastname + ' ' + 'Callback: ' + S.callback + ' '
+ 'Email Address: ' + username + '@security101.com' + ' ' + 'Branch: ' + B.title + ' ' + 'MainPhone: ' + B.mainphone + ' '
+ 'Error: ' + ISNULL(S.ErrMsg, 'None') + ' ' + 'Problem: ' + S.problem + ' ' + 'User Host Address: ' + hostaddress
From support As S
Inner Join Logins As L
On L.LgID = S.LgID And L.BRID = S.BRID
Inner Join db_branches As B
On B.BRID = L.BRID And B.BRID = S.BRID
Where TicketID = (Select Max(TicketID) From Support))
End
Exec msdb.dbo.sp_send_dbmail
@profile_name = 'HelpDesk',
@recipients = 'helpdesk@security101.com',
@body = @Information,
@subject = 'Support Ticket';
Go
Any help would be great
January 24, 2014 at 8:16 am
since dbmail is already set up adn running, it might be something related tot eh recipient or relaying;
if you run this query, is the specific email you sent in there? what is the error description (if any?)
SELECT
err.[description],
fail.*
FROM [msdb].[dbo].[sysmail_event_log] err
inner join [msdb].[dbo].[sysmail_faileditems] fail
ON err.mailitem_id = fail.mailitem_id
Lowell
January 24, 2014 at 8:19 am
Lowell (1/24/2014)
since dbmail is already set up adn running, it might be something related tot eh recipient or relaying;if you run this query, is the specific email you sent in there? what is the error description (if any?)
SELECT
err.[description],
fail.*
FROM [msdb].[dbo].[sysmail_event_log] err
inner join [msdb].[dbo].[sysmail_faileditems] fail
ON err.mailitem_id = fail.mailitem_id
There is no error and the query returns nothing in the results.
January 24, 2014 at 9:00 am
well, what you are seeing in the log is normal, i believe. if the service broker gets an email, it starts the database mail executable,and it's default lifetime is ten minutes(600 seconds) before it shuts down from non-use.
that setting can be changed, to say, 24 hours(43200), bu t that's just unneeded CPU cycles.
so the question is whether your email was sent, but not received, or is it stuck in the service broker, and not even processed yet.
this query would show all emails and any errors:
SELECT
err.[description],
fail.*
FROM [msdb].[dbo].[sysmail_event_log] err
inner join [msdb].[dbo].[sysmail_allitems] fail
ON err.mailitem_id = fail.mailitem_id
Are there any items that are "unsent" ?
That's where i'd think the issue is in dbmail instead of anywhere else.
most of the time, the queue is going to be in an INACTIVE state:
exec msdb.dbo.sysmail_help_queue_sp @queue_type = 'Mail' ;
if you had things that were unsent, you'd first try cycling the mail service (from experience, works maybe 30% of the time if things are stuck int the queue),
exec msdb.dbo.sysmail_stop_sp
exec msdb.dbo.sysmail_start_sp
if that doesn't clear it, i've had to bounce the sql instance itself to get things moving through the queue again:
Lowell
January 24, 2014 at 9:04 am
Lowell (1/24/2014)
well, what you are seeing in the log is normal, i believe. if the service broker gets an email, it starts the database mail executable,and it's default lifetime is ten minutes(600 seconds) before it shuts down from non-use.that setting can be changed, to say, 24 hours(43200), bu t that's just unneeded CPU cycles.
so the question is whether your email was sent, but not received, or is it stuck in the service broker, and not even processed yet.
this query would show all emails and any errors:
SELECT
err.[description],
fail.*
FROM [msdb].[dbo].[sysmail_event_log] err
inner join [msdb].[dbo].[sysmail_allitems] fail
ON err.mailitem_id = fail.mailitem_id
Are there any items that are "unsent" ?
That's where i'd think the issue is in dbmail instead of anywhere else.
most of the time, the queue is going to be in an INACTIVE state:
exec msdb.dbo.sysmail_help_queue_sp @queue_type = 'Mail' ;
if you had things that were unsent, you'd first try cycling the mail service (from experience, works maybe 30% of the time if things are stuck int the queue),
exec msdb.dbo.sysmail_stop_sp
exec msdb.dbo.sysmail_start_sp
if that doesn't clear it, i've had to bounce the sql instance itself to get things moving through the queue again:
There is on inactive Below:
queue_typelengthstatelast_empty_rowset_timelast_activated_time
mail0INACTIVE2014-01-24 14:57:56.9802014-01-24 14:58:00.633
How does the query look in the trigger
January 24, 2014 at 9:08 am
What do you mean by:
if that doesn't clear it, i've had to bounce the sql instance itself to get things moving through the queue again:
Please explain
January 24, 2014 at 9:23 am
well, now i see two things;
first is a critical permissions issue:
the end user who inserts into this table must ALSO be a user in the msdb database, and must also be in the role [DatabaseMailUserRole]
if a user is not in that role, then the trigger would fail, the row would not be inserted in the table, and you'd not get any email, either.
the lazy fix is to put everyone in the msdb's [DatabaseMailUserRole] role, but i leave that up to you.
your trigger is currently designed to handle only a single row, and assumes the max() ticketid (identity?) is the one to worry about.
i would modify the query to use the INSERTED virtual table,and to make it handle multiple rows;
thent he email could say "these ticket(s) were entered, and list the details for all of them together.
this is untested, but modified form my working example, but something like this:
ALTER TRIGGER IHelpDesk_TR
ON [dbo].[support]
After INSERT
AS
BEGIN
SET NOCOUNT ON;
--gather the information, making sure you get it from the INSERTED virtual table, and not the full table
DECLARE @CAPTUREDSTRING VARCHAR(max)
--In this example i want a comma delimited list of important facts about what was inserted.
--using the xml technique to make my comma delimited string.
SELECT @CAPTUREDSTRING = [BigMessage]
FROM (
SELECT TOP 1 GETDATE()As TheDate,stuff((
SELECT ','
+ 'Ticket Number: '
+ Cast(S2.TicketID AS VARCHAR)
+ ' '
+ 'Submitted By: '
+ L.firstname
+ L.lastname + ' '
+ 'Callback: '
+ S2.callback + ' '
+ 'Email Address: '
+ S2.username
+ '@security101.com'
+ ' '
+ 'Branch: '
+ B.title
+ ' '
+ 'MainPhone: '
+ B.mainphone
+ ' '
+ 'Error: '
+ ISNULL(S2.ErrMsg, 'None')
+ ' ' + 'Problem: '
+ S2.problem + ' '
+ 'User Host Address: '
+ hostaddress
+ '[CRLF]'
FROM INSERTED AS S2
INNER JOIN Logins AS L
ON L.LgID = S2.LgID
AND L.BRID = S2.BRID
INNER JOIN db_branches AS B
ON B.BRID = L.BRID
AND B.BRID = S2.BRID
--WHERE s2.WHATEVERID= s1.WHATEVERID --- must match GROUP BY below
WHERE 1 = 1
ORDER BY DESCRIP
FOR XML PATH('')
),1,1,'') as [BigMessage]
FROM INSERTED s1
GROUP BY s1.TicketID --- without GROUP BY multiple rows are returned
ORDER BY s1.TicketID) myAlias
--now email the results.
declare @Information varchar(4000)
set @Information = 'New Item Notification on the Support System Table '
+ CONVERT( VARCHAR( 20 ), GETDATE(), 113 )
+ '
<P> The following new Tickets were inserted into the table:<P>'
+ REPLACE(@CAPTUREDSTRING,'[CRLF]',CHAR(13) + CHAR(10) + '<br />' )
+ '
'
EXEC msdb.dbo.sp_send_dbmail [DatabaseMailUserRole]
@profile_name='HelpDesk',
@recipients='helpdesk@security101.com',
@subject = 'Support Ticket',
@body = @Information,
@body_format = 'HTML'
END --TRIGGER
GO
Lowell
January 24, 2014 at 9:32 am
Lowell (1/24/2014)
well, now i see two things;first is a critical permissions issue:
the end user who inserts into this table must ALSO be a user in the msdb database, and must also be in the role [DatabaseMailUserRole]
if a user is not in that role, then the trigger would fail, the row would not be inserted in the table, and you'd not get any email, either.
the lazy fix is to put everyone in the msdb's [DatabaseMailUserRole] role, but i leave that up to you.
your trigger is currently designed to handle only a single row, and assumes the max() ticketid (identity?) is the one to worry about.
i would modify the query to use the INSERTED virtual table,and to make it handle multiple rows;
thent he email could say "these ticket(s) were entered, and list the details for all of them together.
this is untested, but modified form my working example, but something like this:
ALTER TRIGGER IHelpDesk_TR
ON [dbo].[support]
After INSERT
AS
BEGIN
SET NOCOUNT ON;
--gather the information, making sure you get it from the INSERTED virtual table, and not the full table
DECLARE @CAPTUREDSTRING VARCHAR(max)
--In this example i want a comma delimited list of important facts about what was inserted.
--using the xml technique to make my comma delimited string.
SELECT @CAPTUREDSTRING = [BigMessage]
FROM (
SELECT TOP 1 GETDATE()As TheDate,stuff((
SELECT ','
+ 'Ticket Number: '
+ Cast(S2.TicketID AS VARCHAR)
+ ' '
+ 'Submitted By: '
+ L.firstname
+ L.lastname + ' '
+ 'Callback: '
+ S2.callback + ' '
+ 'Email Address: '
+ S2.username
+ '@security101.com'
+ ' '
+ 'Branch: '
+ B.title
+ ' '
+ 'MainPhone: '
+ B.mainphone
+ ' '
+ 'Error: '
+ ISNULL(S2.ErrMsg, 'None')
+ ' ' + 'Problem: '
+ S2.problem + ' '
+ 'User Host Address: '
+ hostaddress
+ '[CRLF]'
FROM INSERTED AS S2
INNER JOIN Logins AS L
ON L.LgID = S2.LgID
AND L.BRID = S2.BRID
INNER JOIN db_branches AS B
ON B.BRID = L.BRID
AND B.BRID = S2.BRID
--WHERE s2.WHATEVERID= s1.WHATEVERID --- must match GROUP BY below
WHERE 1 = 1
ORDER BY DESCRIP
FOR XML PATH('')
),1,1,'') as [BigMessage]
FROM INSERTED s1
GROUP BY s1.TicketID --- without GROUP BY multiple rows are returned
ORDER BY s1.TicketID) myAlias
--now email the results.
declare @Information varchar(4000)
set @Information = 'New Item Notification on the Support System Table '
+ CONVERT( VARCHAR( 20 ), GETDATE(), 113 )
+ '
<P> The following new Tickets were inserted into the table:<P>'
+ REPLACE(@CAPTUREDSTRING,'[CRLF]',CHAR(13) + CHAR(10) + '<br />' )
+ '
'
EXEC msdb.dbo.sp_send_dbmail [DatabaseMailUserRole]
@profile_name='HelpDesk',
@recipients='helpdesk@security101.com',
@subject = 'Support Ticket',
@body = @Information,
@body_format = 'HTML'
END --TRIGGER
GO
Every end user that inserts into this support table has to be in the [DatabaseMailUserRole] in order for an email to be sent.
January 24, 2014 at 9:55 am
Dieselbf2 (1/24/2014)
Lowell (1/24/2014)
well, now i see two things;first is a critical permissions issue:
the end user who inserts into this table must ALSO be a user in the msdb database, and must also be in the role [DatabaseMailUserRole]
if a user is not in that role, then the trigger would fail, the row would not be inserted in the table, and you'd not get any email, either.
the lazy fix is to put everyone in the msdb's [DatabaseMailUserRole] role, but i leave that up to you.
your trigger is currently designed to handle only a single row, and assumes the max() ticketid (identity?) is the one to worry about.
i would modify the query to use the INSERTED virtual table,and to make it handle multiple rows;
thent he email could say "these ticket(s) were entered, and list the details for all of them together.
this is untested, but modified form my working example, but something like this:
ALTER TRIGGER IHelpDesk_TR
ON [dbo].[support]
After INSERT
AS
BEGIN
SET NOCOUNT ON;
--gather the information, making sure you get it from the INSERTED virtual table, and not the full table
DECLARE @CAPTUREDSTRING VARCHAR(max)
--In this example i want a comma delimited list of important facts about what was inserted.
--using the xml technique to make my comma delimited string.
SELECT @CAPTUREDSTRING = [BigMessage]
FROM (
SELECT TOP 1 GETDATE()As TheDate,stuff((
SELECT ','
+ 'Ticket Number: '
+ Cast(S2.TicketID AS VARCHAR)
+ ' '
+ 'Submitted By: '
+ L.firstname
+ L.lastname + ' '
+ 'Callback: '
+ S2.callback + ' '
+ 'Email Address: '
+ S2.username
+ '@security101.com'
+ ' '
+ 'Branch: '
+ B.title
+ ' '
+ 'MainPhone: '
+ B.mainphone
+ ' '
+ 'Error: '
+ ISNULL(S2.ErrMsg, 'None')
+ ' ' + 'Problem: '
+ S2.problem + ' '
+ 'User Host Address: '
+ hostaddress
+ '[CRLF]'
FROM INSERTED AS S2
INNER JOIN Logins AS L
ON L.LgID = S2.LgID
AND L.BRID = S2.BRID
INNER JOIN db_branches AS B
ON B.BRID = L.BRID
AND B.BRID = S2.BRID
--WHERE s2.WHATEVERID= s1.WHATEVERID --- must match GROUP BY below
WHERE 1 = 1
ORDER BY DESCRIP
FOR XML PATH('')
),1,1,'') as [BigMessage]
FROM INSERTED s1
GROUP BY s1.TicketID --- without GROUP BY multiple rows are returned
ORDER BY s1.TicketID) myAlias
--now email the results.
declare @Information varchar(4000)
set @Information = 'New Item Notification on the Support System Table '
+ CONVERT( VARCHAR( 20 ), GETDATE(), 113 )
+ '
<P> The following new Tickets were inserted into the table:<P>'
+ REPLACE(@CAPTUREDSTRING,'[CRLF]',CHAR(13) + CHAR(10) + '<br />' )
+ '
'
EXEC msdb.dbo.sp_send_dbmail [DatabaseMailUserRole]
@profile_name='HelpDesk',
@recipients='helpdesk@security101.com',
@subject = 'Support Ticket',
@body = @Information,
@body_format = 'HTML'
END --TRIGGER
GO
Every end user that inserts into this support table has to be in the [DatabaseMailUserRole] in order for an email to be sent.
Also We want a ticket for every insert into this table. Can you help me use the xml technique with my original trigger please.
Thank you
January 24, 2014 at 11:32 am
my example trigger, while untested, would not error out if an automated process inserted multiple tickets in a single operation; but it would create a single email that said these ten tickets were added.
this should be very easy for you to test; if you provided the DDL for the table, and a couple of sample INSERT statements, i could test it on my side.
i'm pretty sure your specific issue is related to end users creating tickets but not being having permissions to execute sp_send_dbmail, and the trigger would roll back.
did you address that yet?
easy to test in SSMS:
EXECUTE AS USER='BobTheNormalUser'
INSERT INTO Support(ColumnList)
SELECT ColumnList
--was there an error?
REVERT; ---change back into yourself
Lowell
January 24, 2014 at 12:18 pm
Lowell (1/24/2014)
my example trigger, while untested, would not error out if an automated process inserted multiple tickets in a single operation; but it would create a single email that said these ten tickets were added.this should be very easy for you to test; if you provided the DDL for the table, and a couple of sample INSERT statements, i could test it on my side.
i'm pretty sure your specific issue is related to end users creating tickets but not being having permissions to execute sp_send_dbmail, and the trigger would roll back.
did you address that yet?
easy to test in SSMS:
EXECUTE AS USER='BobTheNormalUser'
INSERT INTO Support(ColumnList)
SELECT ColumnList
--was there an error?
REVERT; ---change back into yourself
USE [BB2]
GO
/****** Object: Table [dbo].[support] Script Date: 1/24/2014 2:14:29 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[support](
[TicketID] [int] IDENTITY(1,1) NOT NULL,
[AssignedTo] [int] NOT NULL,
[LgID] [int] NOT NULL,
[BRID] [int] NOT NULL,
[ticketDate] [datetime] NOT NULL,
[callback] [nvarchar](100) NOT NULL,
[bit] NOT NULL,
[client] [tinyint] NOT NULL,
[webpage] [nvarchar](500) NOT NULL,
[ErrMsg] [nvarchar](3000) NULL,
[problem] [nvarchar](3000) NOT NULL,
[thiscomputer] [bit] NOT NULL,
[computerid] [nvarchar](1000) NOT NULL,
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) [nvarchar](1000) NOT NULL,
[hostaddress] [nvarchar](100) NOT NULL,
[urgent] [bit] NOT NULL,
[intermittent] [bit] NOT NULL,
[havedone] [bit] NOT NULL,
[resolveDate] [datetime] NULL,
[status] [nvarchar](500) NULL,
[followup] [datetime] NULL,
[resolutionCode] [tinyint] NOT NULL,
[resolution] [nvarchar](3000) NULL,
[ackSent] [bit] NOT NULL,
[resSent] [bit] NOT NULL,
[userUpdate] [bit] NOT NULL,
[TopicID] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[support] ([TicketID], [AssignedTo], [LgID], [BRID], [ticketDate], [callback], , [client], [webpage], [ErrMsg], [problem], [thiscomputer], [computerid], Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), [hostaddress], [urgent], [intermittent], [havedone], [resolveDate], [status], [followup], [resolutionCode], [resolution], [ackSent], [resSent], [userUpdate], [TopicID]) VALUES (74, 1, 157, 15, CAST(0x00009D3D00C18D65 AS DateTime), N'863-797-5718', 0, 0, N'/PropLoc.aspx?PropNo=27.0&ComID=18&LocID=675', NULL, N'Re: last message on the error message. We entered a ''0'' in the quantity, saves and the extra lines deleted. Can the error message be specific for this?', 0, N'NT AUTHORITY\NETWORK SERVICE', N'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6', N'72.151.232.161', 0, 0, 0, CAST(0x00009D3D00000000 AS DateTime), NULL, NULL, 9, N'Please add remarks to existing tickets. No need to create a new ticket to send additional info.', 0, 1, 0, NULL)
GO
INSERT [dbo].[support] ([TicketID], [AssignedTo], [LgID], [BRID], [ticketDate], [callback], , [client], [webpage], [ErrMsg], [problem], [thiscomputer], [computerid], Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), [hostaddress], [urgent], [intermittent], [havedone], [resolveDate], [status], [followup], [resolutionCode], [resolution], [ackSent], [resSent], [userUpdate], [TopicID]) VALUES (88, 1, 148, 16, CAST(0x00009D5100FDF2F5 AS DateTime), N'407-739-2539', 0, 2, N'/proposals.aspx', NULL, N'When searching for "customer approved" proposals in the proposal screen, nothing appears. Tried all options, the only one that returned results was "resolved". the only proposals we have in are "customer approved".', 0, N'NT AUTHORITY\NETWORK SERVICE', N'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDC)', N'75.103.1.114', 0, 0, 0, CAST(0x00009D5900000000 AS DateTime), N'waiting for comittee', NULL, 5, N'Ticket converted to forum topic.', 0, 1, 0, 2)
GO
INSERT [dbo].[support] ([TicketID], [AssignedTo], [LgID], [BRID], [ticketDate], [callback], , [client], [webpage], [ErrMsg], [problem], [thiscomputer], [computerid], Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), [hostaddress], [urgent], [intermittent], [havedone], [resolveDate], [status], [followup], [resolutionCode], [resolution], [ackSent], [resSent], [userUpdate], [TopicID]) VALUES (90, 1, 148, 16, CAST(0x00009D5100FDDD63 AS DateTime), N'407-739-2539', 0, 2, N'/companies.aspx?companyid=687&asgn=Anyone&ct=-1&sb=0&pg=0&st=Active&qt=F&query=', NULL, N'Is it possible to have address line 1 instead of website on the main companies screen?', 0, N'NT AUTHORITY\NETWORK SERVICE', N'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDC)', N'75.103.1.114', 0, 0, 0, CAST(0x00009D5E00F3E651 AS DateTime), N'waiting for comittee', NULL, 5, N'converted to forum topic', 1, 0, 0, NULL)
GO
INSERT [dbo].[support] ([TicketID], [AssignedTo], [LgID], [BRID], [ticketDate], [callback], , [client], [webpage], [ErrMsg], [problem], [thiscomputer], [computerid], Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), [hostaddress], [urgent], [intermittent], [havedone], [resolveDate], [status], [followup], [resolutionCode], [resolution], [ackSent], [resSent], [userUpdate], [TopicID]) VALUES (860, 1, 29, 14, CAST(0x00009F4400858BA3 AS DateTime), N'704-909-9864', 0, 0, N'/', N'Dasboard is empty', N'Dashboard is empty', 0, N'NT AUTHORITY\NETWORK SERVICE', N'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)', N'75.181.143.152', 0, 0, 0, CAST(0x00009F4400000000 AS DateTime), NULL, NULL, 7, N'Sorry about that. I am creating the dash manually for now. When the process moves to the server it should never be late. That will happen in a few days and then history of the dash will begin to accumulate too.', 0, 1, 0, NULL)
GO
INSERT [dbo].[support] ([TicketID], [AssignedTo], [LgID], [BRID], [ticketDate], [callback], , [client], [webpage], [ErrMsg], [problem], [thiscomputer], [computerid], Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), [hostaddress], [urgent], [intermittent], [havedone], [resolveDate], [status], [followup], [resolutionCode], [resolution], [ackSent], [resSent], [userUpdate], [TopicID]) VALUES (1689, 484, 264, 31, CAST(0x0000A23600A01415 AS DateTime), N'', 0, 0, N'/brdetail.aspx?branch=0', NULL, N'TEST', 0, N'NT AUTHORITY\NETWORK SERVICE', N'Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.2; WOW64; Trident/6.0; MDDRJS)', N'50.73.154.105', 0, 0, 0, CAST(0x0000A23600000000 AS DateTime), N'Closed', NULL, 9, N'Test', 0, 1, 0, NULL)
GO
INSERT [dbo].[support] ([TicketID], [AssignedTo], [LgID], [BRID], [ticketDate], [callback], , [client], [webpage], [ErrMsg], [problem], [thiscomputer], [computerid], Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), [hostaddress], [urgent], [intermittent], [havedone], [resolveDate], [status], [followup], [resolutionCode], [resolution], [ackSent], [resSent], [userUpdate], [TopicID]) VALUES (69, 1, 3, 15, CAST(0x00009D3C017124B2 AS DateTime), N'954-868-9909', 0, 1, N'/am_NatParams.aspx', NULL, N'I think this should be changed to Rules of Engagement or National Account Parameters
Transaction Parameters', 0, N'NT AUTHORITY\NETWORK SERVICE', N'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.4; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0)', N'72.151.232.161', 0, 0, 0, CAST(0x00009D6B00000000 AS DateTime), N'waiting for comittee', NULL, 5, N'This was named exactly the way Steve''s document (on the resource center) was named. We can discuss this at our next meeting if you like. Mean time I''ll close the ticket.', 0, 1, 0, NULL)
GO
Here are the things that you requested.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply